Thursday, December 27, 2018

SQL TRICKS

Muhammad Ashikuzzaman December 27, 2018 0

1. Student Table have:ID, STUDENT_ID, STUDENT_NAME, YEAR, CLASS, ROLL
Find each student name, the last year in database, class name

ID, STUDENT_ID STUDENT_NAME YEAR CLASS ROLL
1 2 A 2010 I 5
2 2 A 2012 III 5
3 5 C 2010 IX 5
4 2 A 2014 V 5
5 7 E 2018 IX 5
6 2 A 2016 VII 5

Query:

Select ST1.ID, ST1.STUDENT_ID, ST1.STUDENT_NAME, ST1.YEAR, ST1.CLASS, ROLL from STUDENT ST1 INNER JOIN
(
SELECT STUDENT_ID , MAX(YEAR) MAXYEAR from STUDENT GROUP BY STUDENT_ID
)
ST2 on ST1.STUDENT_ID = ST2.STUDENT_ID AND ST1.ID = ST2.ID

Monday, December 24, 2018

RDLC Report Definition Language Client Site Snippet

Muhammad Ashikuzzaman December 24, 2018 0

sql

RDLC Report Definition Language Client Site Snippet

1. FormatDateTime to required Format

=FormatDateTime(Fields!OrderDate.Value, DateFormat.ShortDate)
=Format(now( ),"dd-MMM-yyyy HH:mm:ss tt")
=Format( Fields!CreateDate.Value, "dd-MMM-yyyy")
=FormatNumber(Sum(Fields!FinishQty.Value),0)
=FormatDateTime(Fields!DeliveryDate.Value, DateFormat.ShortDate)

For Printing Serial In RDLC

=RowNumber(Nothing)

If Condition in RDLC

=IIf(Parameters!UnitListId.Value = "6", "Color City Ltd.",
IIf(Parameters!UnitListId.Value = "1", "Mymun Textile Ltd.",
IIf(Parameters!UnitListId.Value = "2", "Hamza Textile Ltd",
"Mymun Complex")))
Switch case in RDLC
= Switch( Fields!FlagGroup.Value = 0, "00-60 days",
Fields!FlagGroup.Value = 1, "61-120 Days",
Fields!FlagGroup.Value = 2, "121-180 Days",
Fields!FlagGroup.Value = 3, "181-270 Days",
Fields!FlagGroup.Value = 4, "271-365 Days",
Fields!FlagGroup.Value = 5, "More than 365 Days" ,

1 = 1, "default value" )
Formatting number to Desired Decimal Points:

=FormatNumber(Sum(Fields!FinishQty.Value), 0)

Iff condition in Function:

=FormatNumber( Sum(IIf(Fields!FlagColumn = 0, Fields!FinishQty.Value ,0 ) ),0)
=IIf(Fields!FlagColumn = 0, FormatNumber( Sum(Fields!FinishQty), 0),0 )

Tuesday, November 27, 2018

Programming language & library Exceptions that occurred while developing in C#, JavaScript, Jquery, SQL, Entity framework

Muhammad Ashikuzzaman November 27, 2018 0

Programming

C#-SQL: Procedure or function SPROC_GET_DBTEXQuality_SearchBatchCardDetails has too many arguments specified.
It occurs when System.Data.SqlClient SqlCommand command.Parameters have more parameter rather than declared in the Stored procedure

Parse String to Date Time: Worked For ME:
string CreatedDateStr = "2018-12-13 11:05:45.313";
DateTime CreateDate = DateTime.Parse( CreatedDateStr );

Thursday, November 1, 2018

Using SqlClient connect to sql server and CRUD in Databse thorough Stored Procedure

Muhammad Ashikuzzaman November 01, 2018 0

Stored Procedure

public List<LDNo> LDNoList(Int64? LDNo)
{
ResultModel result = new Models.ViewModel.CommonViewModel.ResultModel();
string error = String.Empty;
QUERY2 query = new QUERY2();
Dictionary<string, object> dict = new Dictionary<string, object>();//= new Dictionary<string, string>
List<LDNo> ldnoList = new List<LDNo>();
dict.Add("@LDNO", LDNo);
dict.Add("@Result", 1.ToString());
dict.Add("@Message", "Message".ToString());
query.SQL = @"SPROC_GET_tblDyesForecastingHead_LDNO";
query.PARAMETER = dict;
clsDataprocess cls = new clsDataprocess();
result = cls.ExecuteSqlStoredProcedureSaveEdit(query, "get", out error);
if (result.Result && result.DtTable != null && result.DtTable.Rows.Count > 0)
{
Int64 tempi = 0;
for (int i = 0; i < result.DtTable.Rows.Count; i++)
{
LDNo lDNo = new LDNo();
Int64.TryParse(result.DtTable.Rows[i]["LDNO"].ToString(), out tempi);
lDNo.LdNo = tempi;
ldnoList.Add(lDNo);
}
string Message = result.Message;
string Result = result.Result.ToString();
}
else if (!result.Result)
{
throw new Exception(result.Message);
}
return ldnoList;
}

Programming Or Algorithms Snippet

Muhammad Ashikuzzaman October 18, 2018 0

Programming

1. Swap value of 2 variable with out using any third variable.
Suppose

a= 5
b = 7
a = a + b; = 12;
b = a - b ; = 5;
a = a -b; = 7

You can also swap two equal length array with out using any temporary third variable by looping and traversing the arrays.

Tuesday, October 9, 2018

C# Snippet

Muhammad Ashikuzzaman October 09, 2018 0

C# Snippet

1. Formatting Date-time: string.Format("{0:dd/MM/yy}", DateTime.Today)
2. Storing List Data in ViewBag and retrieve the List Data in View Or Getting List Data From ViewBag :

3. If you want to pass multiple different list in a View from ASP .Net MVC Controller Action How can you pass it?

Answer: 

In Action:  ViewBag.MyClassList = new List<MyClass>() ;

 List<MyClass> MyClassList = ViewBag.MyClassList as List<MyClass>;

Returning JSON Data From Server To Client ::

var data = obj_dal.LoadAllProductCode(TKTCode, "1", allMenu.User.USER_ID.ToString());
var MaxJson = Json(new { ListProductCode = data});
MaxJson.MaxJsonLength = 999999999;
return MaxJson;

var MaxJson = Json(new { ListOrderBooking = obj_dal.LoadOrderBookingDL(OrderNo, allMenu.User.EMPLOYEE_ID.ToString()) });
MaxJson.MaxJsonLength = 999999999;
return MaxJson;

SQL Snippet

Muhammad Ashikuzzaman October 09, 2018 0

SQL SNIPPET

Select multiple columns from a subquery in Select Statement with SQL Server Or Use OF Outer Apply

SELECT t1.ID, t1.fck, t1.f1, t3.f2, t3.f3

FROM tbl1 AS t1

OUTER APPLY (

SELECT f2, f3

FROM tbl2 AS t2

WHERE t2.ID = t1.fck) AS t3

Decaaring table as Variable And Inserting In it:

declare @listOfTablesArrangementIDs table (id int);

insert @listOfTablesArrangementIDs(id) values(1),(2),(3)

insert @listOfTablesArrangementIDs(id) values(2027),(20258),(7)

select * from TablesArrangement where ID NOT IN (select * from @listOfTablesArrangementIDs ) AND AreaCode = 'tst1'

Create Trigger

-- =============================================

-- Author: <Muhammad Ashikuzzaman,,Name>

-- Create date: <24-10-2018,,>

-- Edit date: <14-08-2018, >

-- Description: <Initial server: 192.168.153.208 >

-- =============================================

CREATE TRIGGER [ccl2].[TRG_TBL_PriceSetup]

ON [ccl2].[TBL_PriceSetup]

AFTER UPDATE

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

--Declare @PriceID bigint

--Select @PriceID = PriceID From deleted

insert into ccl2.ARC_PriceSetup (PriceID,Price)

select PriceID,Price from deleted

END

Create A Stored Procedure

USE [ProjectInfoDB]

/****** Object: StoredProcedure [dbo].[SPROC_GET_tblDyesForecastingHead_LDNO] Script Date: 11/1/2018 12:44:51 PM ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

-- =============================================

-- Author: <Muhammad Ashikuzzaman,,Name>

-- Create date: <14-08-2018,,>

-- Edit date: < ,,>

-- Description: <Initial server: 192.168.153.208 ,,>

-- =============================================

ALTER PROCEDURE [dbo].[SPROC_GET_tblDyesForecastingHead_LDNO]

@LDNO bigint = null,

@Result bit =1 out ,

@Message nvarchar(200) = 'ok' out

BEGIN

SET NOCOUNT ON;

--select top 50 CommonId_For_ForeCastingDetails, DyeingPart, DyesID from dbo.tblDyesForecastingDetail

select DISTINCT LDNO from dbo.tblDyesForecastingHead

where Convert(nvarchar(50), LDNO) like '%'+ Convert(nvarchar(50), ISNULL(@LDNO, LDNO) ) +'%'

--select top 50 CommonId_For_ForeCastingDetails, DyeingPart, DyesID from dbo.tblDyesForecastingDetail

If (@@ERROR<>0)

Begin

set @Result = 0

set @Message = 'Failed to Retrieve, Try Again'

End

Else

BEGIN

set @Result = 1

set @Message = 'Data was Retrieved successfully'

END

Create a Cursor and traverse selected row through this cursor

declare @Test table (Id int, Col1 int, Col2 int, Col3 int)
insert into @Test (Id , Col1 , Col2 , Col3 )
values (1 , 1 , 1 , 40 ),
(2 , 1 , 1 , 41 ),
(3 , 1 , 1 , 41 ),
(4 , 1 , 1 , 42 ),
(5 , 1 , 2 , 40 ),
(6 , 1 , 3 , 41 )
declare @Id bigint
declare @col1 int
declare @col2 int
declare @col3 int
declare @CtnInfo cursor
set @CtnInfo = CURSOR FOR
SELECT Id, COL1, COL2, COL3 FROM @Test
declare @tblBody nvarchar(max)
set @tblBody= 'Start : '
OPEN @CtnInfo
SELECT @@FETCH_STATUS as FETCH_STATUS1
WHILE 1 = 1
BEGIN
FETCH NEXT FROM @CtnInfo INTO
@id, @col1, @col2, @col3
IF @@FETCH_STATUS = -1
Break
Else
SET @tblBody=@tblBody+ ', ' + convert(nvarchar(20), @Id)
END
CLOSE @CtnInfo
DEALLOCATE @CtnInfo
SELECT @@FETCH_STATUS as FETCH_STATUS2
select @tblBody as TotalSelecteddata

Understanding partition by

-- My understanding partition by will count seqs increasingly until partition by column value remain unchanged
declare @Test table (id int, Col1 int, Col2 int, Col3 int)
insert into @Test (id , Col1 , Col2 , Col3 )
values (1 , 1 , 1 , 40 ),
(1 , 1 , 1 , 41 ),
(1 , 1 , 1 , 41 ),
(1 , 1 , 1 , 42 ),
(1 , 1 , 2 , 40 ),
(1 , 1 , 3 , 41 ),
(1 , 1 , 3 , 41 ),
(2 , 1 , 4 , 43 ),
(2 , 2 , 1 , 43 ),
(2 , 2 , 1 , 44 ),
(2 , 2 , 2 , 44 ),
(2 , 2 , 3 , 44 ),
(2 , 2 , 4 , 45 ),
(3 , 3 , 1 , 46 ),
(4 , 3 , 2 , 46 ),
(5 , 3 , 2 , 47 )
-- Normal Group BY
select col1, col2 , count(Col1) Col1Count, count(Col2) Col2Count
from @Test
group by col1, col2 order by Col1
--partition BY With Group BY
-- My understanding partition by will count seqs increasingly untill partition by column value remain unchanged
select col1, col2, col3, count(col3)Col3Count, row_number()
over (Partition BY col1 , col2
order By col1 ) seqs
from @Test
group by col1, col2, col3
order by col1, col2

Remove Time portion from a date time
select DATEADD(DD, DATEDIFF(dd, 0, '2018-12-25 12:25:00' ), 0)-- will remove time portion from the date

select DATEDIFF(dd, 0, '2018-12-25 12:25:00' ) here 2nd parameter 0 means '1900-01-01'

Send Mail By sp_send_dbmail stored procedure

declare @tblBody nvarchar(max)
set @tblBody='<style type="text/css">
#detail_table {
border: 2px solid gray;
border-collapse: collapse;
}
#one td { border: 1px solid #00000; }
#detail_table td , #detail_table th {
text-align: center;
border: 1px solid gray;
} </style>'
set @tblBody=@tblBody+'<div align="center" style=" border:0px solid #000000; width: 98%;height: 95%;padding: 8px;padding-top:0px; margin: 5px;"> <div align="center" style="font-weight: bold;font-size: 22px;"> HamdoonSoft Complex </div> <div style="clear:both;padding: 7px;"></div> <div align="center" style="font-weight: bold;font-size: 16px; width:230px; border-bottom: 1px solid #222;position:absolute; left:42%"> Hamdoon Soft Notification </div> <div style="clear:both;"></div>
<div align="left" style="font-size:12px;border:0px solid #000000; width: 99%;height: 100%;padding: 20px;padding-top:0px;">
<div align="left" style="margin-top:35px;"><b> Date: </b> '+ convert( nvarchar(30) , GETDATE() )+'</div>
<div align="left" style="margin-top:8px;">To, </div>
<div align="left" style="margin-top:10px; margin-left:20px;">DGM/ AGM/ Sr. Manager</div> <div align="left" style="margin-top:5px; margin-left:20px; height: 30px; "> Department: '+ '@ResponsibleDepartment' +'</div> <div align="left" style="margin-top:5px; margin-left:22px;">Subject: Problematic fabric information from off line Inspection to problamatic department.</div> <div align="left" style="margin-top:18px;">Dear Sir</div> <div align="left" style="margin-top:15px; margin-left:20px;">This is to inform you that, we found below batch problematic during 100% inspection in off line quality zone.</div>
<div align="left" style="margin-top:8px;">Details :- </div>
<br/> <table id="detail_table" style="margin-top:20px; margin-right:.5%; width:99.5%; " > <tr id="one"> <th>C1 </th> <th>C2 </th> <th>C3 </th> <th>C4 </th> <th>C5</th> </tr> '
DECLARE @c1 NVARCHAR(40)
DECLARE @c2 NVARCHAR(40)
DECLARE @c3 NVARCHAR(40)
DECLARE @c4 NVARCHAR(40)
DECLARE @c5 NVARCHAR(40)
declare @CtnInfo cursor
set @CtnInfo = CURSOR FOR
SELECT * from (values (1, 2, 3, 4, 5) , (1, 2, 3, 4, 5) )
t21 (c1, c2, c3, c4, c5)
OPEN @CtnInfo
WHILE 1 = 1
BEGIN
FETCH NEXT FROM @CtnInfo INTO
@c1, @c2, @c3, @c4, @c5
IF @@FETCH_STATUS = -1
Break
Else
set @tblBody=@tblBody+' <tr >
<td align="center" > '+@c1+' </td> <td align="center" > '+@c2 +' </td> <td align="center" > '+@c3 +' </td> <td align="center" > '+@c4+' </td><td align="center" > '+@c5+'</td> </tr> '
END
CLOSE @CtnInfo
DEALLOCATE @CtnInfo
SELECT @@FETCH_STATUS as FETCH_STATUS2
select @tblBody as TotalSelecteddata
set @tblBody=@tblBody+' </table> <br/> <div style="position: relative!important;left: -530px!important; top: 10px!important; font-weight:bold; font-family:Verdana, Arial, Helvetica, sans-serif;"> </div> </div> </div>'
Set @tblBody=@tblBody+'<div style="Font-weight:bold; margin-top:30px;font-family:Verdana, Arial, Helvetica, sans-serif; "> Best Regards </div> <div style=" Font-weight:bold; margin-top:10px;font-family:Verdana, Arial, Helvetica, sans-serif; "> MIS Department </div>'
declare @recipient nvarchar(max) = 'ashikcse20@gmail.com;'
declare @copy_recipient nvarchar(max) = ' ashikcse20@gmail.com;'
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'MIS-MTL',
@recipients = @recipient,
@copy_recipients= @copy_recipient ,
@body = @tblBody ,
@subject = 'Automatic Mail Sending',
@body_format = 'HTML'

Tuesday, September 11, 2018

ASP .NET MVC 5 Multi Tenant Example With New Project (Single Different Database For Per Tenant Using Entity Framework)

Muhammad Ashikuzzaman September 11, 2018 0

In the name of Allah, Most Gracious, Most Merciful بِسْمِ اللَّهِ الرَّحْمَنِ الرَّحِيم

Welcome to Hamdoon Soft Fun:
Here I just use this ASP .Net MVC5 application as Multitenant application with single database per tenant
I am doing it from Windows 10 .

All code and supports can achieved from here https://github.com/ashikcse20

And video is here :

A. Technical Steps:
1. Go to C:\Windows\System32\drivers\etc open hosts file with Sublime Text or Notepad with administarator mode. find # 127.0.0.1 localhost and replace it by the following instruction.
# In hosts file a line starting with # is a comment line #The below line is an active line which make many alias of local host (remove the #) 127.0.0.1 localhost hamdoonsoft.com tenant1.hamdoonsoft.com tenant2.hamdoonsoft.com tenant3.hamdoonsoft.com

Jquery Code Snippet

Muhammad Ashikuzzaman August 16, 2018 0

jQuery

Use Of :not(), :not, :nth-child()
Note that since JavaScript arrays use 0-based indexing, these selectors reflect that fact. This is why $( ".myclass:eq(1)" ) selects the second element in the document with the class myclass, rather than the first. In contrast, :nth-child(n)uses 1-based indexing to conform to the CSS specification.
ecause jQuery's implementation of :nth- selectors is strictly derived from the CSS specification, the value of n is "1-indexed", meaning that the counting starts at 1. For other selector expressions such as :eq() or :even jQuery follows JavaScript's "0-indexed" counting. Given a single <ul> containing two <li>s, $( "li:nth-child(1)" ) selects the first <li> while $( "li:eq(1)" ) selects the second.
https://api.jquery.com/nth-child-selector/
https://api.jquery.com/eq-selector/
$("#table4 tr:not(:last,:first,#table4-first-tr, :nth-child(2) )").remove();

Check If A Checkbox Is Checked With jQuery

// Trigger checkbox click on it's parent click

$("body").on("click", ".checkbox-td", function (event) {
debugger;
$(':checkbox', this).trigger('click');
event.stopPropagation();
});

If checkbox is checked or not

if (jQuery(this).is(':checked')) { }
else if (jQuery(this).is(':not(:checked)')) { }

When testing local server ajax was working fine. But when put in http://192.168.153.253/ERP/ ajax wasn't working.
get that ERP was added and for the shake a base url is needed.

<script type="text/javascript">
var base = '@Url.Content("~/")';
</script>

jQuery track when #Mymodal is colosed

$('#myModal').on('hidden.bs.modal', function (e) {})
jQuery Delaying While Removing/Adding CSS
setTimeout(function () {
ClickedTd.css("border", "0px solid green");
}, 2000);

#Remove checkbox with delay one by one: First one work. If I put check box in setTimeout then it will refer $(this) = wind function and checkbox aren't removed

var i = 0;
$(".checkbox-td .ckbox:checkbox:not(:disabled)").each(function () {
i++;
var chkbox = $(this);
setTimeout(function () {
chkbox.remove();
}, 1000 - 100 * i);
});
i = 0;
$(".checkbox-td .ckbox:checkbox:not(:disabled)").each(function () {
i++;
setTimeout(function () {
$(this).remove();
}, 1000 - 100 * i);
});

# Juquery $.Ajax Jquery Ajax Method with object variable as data

//dyes_forecasting.ForecastingHead = dyes_forecasting_head_list;
//dyes_forecasting.DyesRecipe = dyes_recipe_list;
//var data = "{'model':" + JSON.stringify(dyes_forecasting) + "}";
function LoadList() {
var jdata = PrepearJasonData('filter-item');
//alert(JSON.stringify(jdata));
WaitMeStart();
$.ajax({
type: 'POST',
url: '/tablessetup/List',
contentType: "application/json; charset=utf-8",
data: JSON.stringify(jdata),
// data: JSON.stringify({ "Ldno": Ldno }),
success: function (data) {
$('#content-box').html(data);
InitForm();
InitSortingHeader("content-box");
},
error: function (e) {
//alert(e.responseText);
WaitMeStop();
// l.stop();
alertify.error("Something technical error occurred");
}
}).done(function () {
WaitMeStop();
// l.stop();
});
}

Ajax Call To Load Search Data From Server And Get Title Error

$.ajax({
type: 'POST',
url: base + "Chemical/SearchOrderDetails",
contentType: "application/json; charset=utf-8",
//data: JSON.stringify(jdata),
//data: JSON.stringify({ "Ldno": Ldno }),
success: function (data) {
if (data.indexOf("No record was found") >= 0) {
IaoCustomizedMessage(data.toString(), "warning", "dark", true, 2500);
$("#grid").append("<tr><td colspan='12'>" + data + "</tr></td>");
}
else {
$("#grid").append(data);
ProcesDyesRecipePercantageTableDivVisibility("show");
}
},
error: function (error) {
if (typeof error.message == "undefined") {
var element = $(error.responseText);
var message = element.get(1).innerText;
IaoCustomizedMessage(message, "error", "dark", true, 8000);
}
else IaoCustomizedMessage(e.message, "error", "dark", true, 5500);
}
}).done(function () {
IaoCustomizedMessage("Successfully retrieve data from server", "success", true, 1500);
});

Juquery $.Ajax Jquery Ajax Method with variable as data For Php Page

$("body").on("change", "#buyer", function() {
console.log("Allahu Akbor");
var buyer = $("#buyer").val().trim();
var order = $("#order").val().trim();
$.ajax({
type: 'GET',
url: 'GetOrderList.php',
contentType: "application/json; charset=utf-8",
data: { buyer : buyer, order : order } ,
success: function (data) {
$('#message').html(data);
},
error: function (e) {
}
}).done(function () {
console.log("Alhamdulilla");
});
});

Iao Customized Message

IaoCustomizedMessage(data.toString(), "warning", "dark", true, 2500);
<link href="@Url.Content("~/Bootstrap/iao-alert.css?_" + DateTime.Now.Ticks)" rel="Stylesheet" />
<script src="@Url.Content("~/Bootstrap/iao-alert.jquery.js?v=" + 1.1)"></script>
function IaoCustomizedMessage(msg, type, mode, autoHide, alertTime) { // By Muhammad Ashikuzzaman in 2018.10.06
if (typeof type == "undefined" || type === "") {
type = "notification";
} if (typeof autoHide == "undefined" || autoHide === "") {
autoHide = true;
}
if (typeof alertTime == "undefined" || alertTime === "") {
// alertTime = 3000;
}
if (typeof mode == "undefined" || mode === "") {
mode = "dark";
}
$.iaoAlert({
// default message
msg: msg,
// or 'success', 'error', 'warning'
type: type, //"notification",
// or light dark
mode: mode,
// auto hide true, false
//// autoHide: true,
autoHide: autoHide,
// fade animation speed
fadeTime: "2800",
// timeout in milliseconds
alertTime: alertTime,
// shows close button
closeButton: true,
// close on click
closeOnClick: true,
// custom position
position: 'bottom-right',
// fade on hover
fadeOnHover: true,
// z-index
zIndex: '999',
// additional CSS class(es)
alertClass: ''
});
}

Data Table Related Code Snippet :

Reload Datatable after ajax success

$('body #quality_control_table').dataTable().fnDestroy();

Detect Shift + Enter key Press or Ctrl + Enter Key Press Or Any key Press

$(document).keydown(function (e) {
if (e.keyCode == 13 && !e.shiftKey) { // If shiftKey + ENter is hit
debugger;
console.log("Only Enter Press");
e.preventDefault();
}
else if (e.keyCode == 13 && e.shiftKey) { // If shiftKey + ENter is hit
debugger;
console.log("Shift Entered Pressed");
}
});
$("body").on("keydown", ".AfterHeatSetInfo", function (e) {
if (e.keyCode == 13 && !e.shiftKey) { // If shiftKey + ENter is hit
debugger;
console.log("Only Enter Press");
e.preventDefault();
}
else if (e.keyCode == 13 && e.shiftKey) { // If shiftKey + ENter is hit
debugger;
console.log("Shift Entered Pressed");
}
});

Wednesday, August 15, 2018

Using SqlClient connect to sql server and CRUD in Databse thorough code base Inner Query Query

Muhammad Ashikuzzaman August 15, 2018 0

SqlClient

2. SqlClientCode For Calling StoredProcedure for Getting Data

public JsonResult BuyerList()
{
Chemical_DAL obj_dal = new Chemical_DAL();
return Json(obj_dal.BuyerList());
}

2. Service

public class QUERY
{
public string SQL { get; set; }
public Dictionary<string, string> PARAMETER { get; set; }
public Dictionary<string, byte[]> BYTEPARAMETER { get; set; }
}

MY Favorite .Net Question For Interview

Muhammad Ashikuzzaman July 11, 2018 0

sql

This are not tidy. Just for rough. In Sha Allah will make it tiddy soon.

1. DateTime2 Date range 0001-01-01 through 9999-12-31 vs DateTime Date range January 1, 1753, through December 31, 9999 in SQL Server
Ans: https://stackoverflow.com/questions/1334143/datetime2-vs-datetime-in-sql-server

2. Dictionary value different types use object as datatype of the eky value

3. If one property of a class is list<> of another class then how to deal with it if we want to initialize it in essential place to avoid Null Reference. See question 17 below.

4. How to create multi valued dictionary rather than one valued dictionary.

5. Instance Methods as Delegates
6. Generic: Base Class Constraint
7. Defference btn logical ("AND, OR") vs shortcircuit ("AND, OR")repectively

8. Use ref and out Parameters
9. Indexer vs Property Difference
10.Variable Number of Arguments function Arguments

11. How you copy one object to another object . Not reference of the object?

12. Make a simple character stack by a C# class and push pop public member function

13. How to use one constructor to invoke another Constructor and which one will execute first
Optional Arguments vs. Overloading: How optional argument become an alternative to Function Overloading

14. Static class and static method

15. C# 4.0: The Complete Reference: 296 PG: When Are Constructors Called?
For multilevel hierarchy inheritance : During creation of child class object which class constructor is executed first? The one in the derived class or the one defined by the base class? Or only one constructor will be called?

16. Dynamic method dispatch/ C# runtime polymorphism: (C# 4.0: The Complete Reference 297 - 305 PG- : Base Class References and Derived Objects and Virtual Methods and Overriding)
For multilevel hierarchy inheritance, because of calling the virtual method with any level base class reference variable referring to a any of the child /base class object.
case 1: When both have the virtual method then Object being referred class method/reference class overridden method will be called?
Case 2: If a derived class does not override a virtual
method, then, while moving up the hierarchy/down the hierarchy, the only first override of the method that is encountered is the one executed or only the last? or All from first to last vice versa?

17. A field initializer cannot reference the nonstatic field, method, or property

clsDataprocess cls2 = new clsDataprocess();// Wrong
static public SqlConnection Con = cls2.getConnection253_Mymun(); // cls2 showing the errror

You cannot use an instance variable to initialize another instance variable. Why? Because the compiler can rearrange these - there is no guarantee that cls2 will be initialized before Con , so the above line might throw a NullReferenceException.

static clsDataprocess cls2 = new clsDataprocess(); // Correct put static in both variable

static public SqlConnection Con = cls2.getConnection253_Mymun();// Correct

18.Why can't I use alias in a count(*) “column” and reference it in a having clause?

The HAVING clause is evaluated before the SELECT - so the server doesn't yet know about that alias.

Answer: https://stackoverflow.com/a/2068705/2014745

19. Null Reference Exception for Class Lists

Answer :

https://stackoverflow.com/a/38511001/2014745

When you create BookList, you haven't actually initialized the list that is its member. You can do this by changing your initialization to: BookList myBookList = new BookList() {bookList = new List<Book>()};

Or by writing a constructor for the BookList class which initializes the list; which would look like this: class BookList { public List<Book> bookList { get; set; } public BookList(){ //New constructor bookList = new List<Book>(); } }

20. Why compile error “Use of unassigned local variable”?

Local variables aren't initialized. You have to manually initialize them.

Members are initialized, for example:public class X { private int _tmpCnt; // This WiLL initialize to zero ... }

But local variables are not:public static void SomeMethod() { int tmpCnt; // This is not initialized and must be assigned before used. ... }

21. If you want to pass multiple different list in a View from ASP .Net MVC Controller Action How can you pass it?

Answer: 

In Action:  ViewBag.MyClassList = new List<MyClass>() ;

 List<MyClass> MyClassList = ViewBag.MyClassList as List<MyClass>;

PtideSys Vivaa Question:
1. Introduce your selft.
They also introduced their selves. While continuing conversation...
2. What type of word did you done in previous company?
3. Asked me about the working procedure of .Net framework.. MSIL and CLR... mixed it
5. Gave a programe to make the sum and asked it's time and space complexity with various situation. During this session asked me the difference between int type length of ASCII and C# . I said 2 byte and 4 byte, the asked sure, i replied sure..!
4. Garbage collection of .Net framework Dispose. type safety and un safety programming language.
5. Entity framework tasks, codefirst, database first, design first.. Transaction committing with EF
6. Binary search
7. Asked about Singleton patterns -- I said it can be done many ways from that I like JonSkeet c# in depths example with a sealed class and static reference of the same class
8. Factory patterns-- Implemented this with Interface Inheriting
9. Some others question.
10. Asked about My Stack overflow reputation.
11. Asked if I have used Dictionary, List, Tuple
12. Some other features of OOP
13. Difference between string And String, I said they are same. Asked what is main defference between String and Stringbuilder class. i said object of string is immutable, if you want to change one cjaracter of C# built in string class object you have to copy it in an char array o have to changed by pointer which is not intutively supported by c#, Also if string a ="7" and string b = "7". They will occupy same memery address. It is a special property of c# string. And All string builder contents object are not like this in built in string class.
I have gave most of the answers.
But only stucked with the answer of Transaction of Enttity framework with question what will be happened when machine face problem if power goes or network connection goes between program server and database server. I said it can be done manully will complex taskingg... but entity frame work provide easy way to tasking this type of scenario. And made mistake with the name MISL and CLR
Oh Aro 3 ta question Bad Porche
14. Delegates in c# , keno, ki vabe apply kore
15. Dependency injection ki, keno kore subidha
16. Dynamic method dispatching khetre ki vabe ki kore..

Asynchronous method ki..

Interface vs abstract class

Ienumarable vs queryable

Linq ar groupby dicilo

Sql ar 2 query

Extendclass ar example

Delegate ki example

JavaScript closure

Javascrip private public , inheritance

Javascrip callback function ar output

Oop ar kisu basic cilo mona portasa na

Event vs delegate

"string" ka reverse korta hoba c# dara

Muhammad Ashikuzzaman

Select Language

About Me

Social Media Icons

Main Menu

Menu

Social Media Icons

Subscribe To

Labels

Social

Comments

Breaking

Users Countries

Thursday, December 27, 2018

Monday, December 24, 2018

Tuesday, November 27, 2018

Thursday, November 1, 2018

Thursday, October 18, 2018

Tuesday, October 9, 2018

Tuesday, September 11, 2018

In the name of Allah, Most Gracious, Most Merciful بِسْمِ اللَّهِ الرَّحْمَنِ الرَّحِيم

Welcome to Hamdoon Soft Fun: Here I just use this ASP .Net MVC5 application as Multitenant application with single database per tenant I am doing it from Windows 10 .

All code and supports can achieved from here https://github.com/ashikcse20

And video is here :

Thursday, August 16, 2018

Check If A Checkbox Is Checked With jQuery

# Juquery $.Ajax Jquery Ajax Method with object variable as data

Wednesday, August 15, 2018

Wednesday, July 11, 2018

18.Why can't I use alias in a count(*) “column” and reference it in a having clause?

Add Choice

Like us on Facebook

Search This Blog

Select Language

Total Pageviews

Users Countries

Social

Recent

Popular

Comments

Archive

Welcome to Hamdoon Soft Fun:
Here I just use this ASP .Net MVC5 application as Multitenant application with single database per tenant
I am doing it from Windows 10 .