______________________________________________________________________________________

JQUERY
//DROP DOWN CASCADING

function bindCountryMaster() {
$.ajax({
type: "GET",
url:
"[Link]
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (result) {
alert(result);
$.each(result, function () {

$("[id*=CountryId]").append($("<option></option>").val(this['CountryId']).
html(this["Country"]));
});
},
failure: function (error) {
alert(error);
}
});
}
______________________________________________________________________________________

$("#CountryId").change(function () {
var action = { action: $("#CountryId").val() };
alert([Link](action));
$.ajax({
type: "GET",
url:
"[Link]
ryId=" + [Link],
headers: {
"Authorization": "Basic" + Token,
"Content-Type": "application/json"
},
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (result) {
$.each(result, function () {
$("[id*=StateId]").append($("<option></option>").val(this["StateId"]).html
(this["State"]));
});
},
failure: function (response) {

alert(response);
}
});
______________________________________________________________________________________
// SEARCH

$("#btnSearchEmployee").click(function () {
alert("button is working");

var action = { action: $("#drpBindEmpCodeFirstName").val() };

alert([Link](action));
$.ajax({
type: "GET",
url:
"[Link]
+ [Link],
headers: {
"Authorization": "Basic" + Token,
"Content-Type": "application/json"
},
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccessSearchMachineMaster,
failure: function (response) {

alert(response);
}
});
function OnSuccessSearchMachineMaster(response) {
var Empmodal = response;
alert(Empmodal);
debugger;
$("#EmpCode").val(Empmodal[0].EmpCode);
$("#Title").val(Empmodal[0].Title);
$("#FristName").val(Empmodal[0].FristName);
$("#MiddleName").val(Empmodal[0].MiddleName);
$("#LastName").val(Empmodal[0].LastName);
$("#ContactNo").val(Empmodal[0].ContactNo);
$("#MobileNo").val(Empmodal[0].MobileNo);
$("#EmailId").val(Empmodal[0].EmailId);
$("#DOB").val(Empmodal[0].DOB);
$("#GID").val(Empmodal[0].GID);
$("#BloodGroupID").val(Empmodal[0].BloodGroupID);
$("#MSID").val(Empmodal[0].MSID);
$("#CTC").val(Empmodal[0].CTC);
$("#GrossAmount").val(Empmodal[0].GrossAmount);
$("#TempAddress").val(Empmodal[0].TempAddress);
$("#DocumentName").val(Empmodal[0].DocumentName);
$("#TrainingDetails").val(Empmodal[0].TrainingDetails);
$("#PanNo").val(Empmodal[0].PanNo);
$("#ESICACCNO").val(Empmodal[0].ESICACCNO);
$("#AutoMail").val(Empmodal[0].AutoMail);
$("#LeaveId").val(Empmodal[0].LeaveId);
$("#AttendanceID").val(Empmodal[0].AttendanceID);
}
});
// CLEAR FIELDS

function clearFields() {
$("#EmpCode").val("");
$("#Title").val("");
$("#FristName").val("");
$("#MiddleName").val("");
$("#LastName").val("");
$("#ContactNo").val("");
$("#MobileNo").val("");
$("#EmailId").val("");
$("#DOB").val("");
$("#GID").val("");
$("#BloodGroupID").val("");
$("#MSID").val("");
$("#CTC").val("");
$("#GrossAmount").val("");
$("#TempAddress").val("");
$("#DocumentName").val("");
$("#TrainingDetails").val("");
$("#PanNo").val("");
$("#ESICACCNO").val("");
$("#AutoMail").val("");
$("#LeaveId").val("");
$("#AttendanceID").val("");

function clearFields() {
// Clear all input elements within the form with ID "employeeForm"
$("#employeeForm :input").val("");
}
______________________________________________________________________________________
// SAVE

$("#btnSave").click(function () {
alert("button is working !")
var SaveData = {
EmpCode : $("#EmpCode").val(),
Title : $("#Title").val(),
FristName : $("#FristName").val(),
MiddleName : $("#MiddleName").val(),
LastName : $("#LastName").val(),
ContactNo : $("#ContactNo").val(),
MobileNo : $("#MobileNo").val(),
EmailId : $("#EmailId").val(),
DOB : $("#DOB").val(),
GID : $("#GID").val(),
BloodGroupID : $("#BloodGroupID").val(),
MSID : $("#MSID").val(),
CTC : $("#CTC").val(),
GrossAmount : $("#GrossAmount").val(),
TempAddress : $("#TempAddress").val(),
DocumentName : $("#DocumentName").val(),
TrainingDetails : $("#TrainingDetails").val(),
PanNo : $("#PanNo").val(),
ESICACCNO : $("#ESICACCNO").val(),
AutoMail : $("#AutoMail").val(),
LeaveId : $("#LeaveId").val(),
AttendanceID : $("#AttendanceID").val()

};
alert([Link](SaveData));
$.ajax({

type: "POST",
url: "[Link]
contentType: "application/json; charset=utf-8",
dataType: "json",
data: [Link](SaveData),
success: function (result) {

alert("Inserted Successfully")

clearFields();
},
failure: function (error) {
alert(error);
}
});
});
_____________________________________________________________________________

// UPDATE

$("#btnUpdate").click(function () {
alert("button is working !")
var updateData = {
EmpCode: $("#EmpCode").val(),
Title: $("#Title").val(),
FristName: $("#FristName").val(),
MiddleName: $("#MiddleName").val(),
LastName: $("#LastName").val(),
ContactNo: $("#ContactNo").val(),
MobileNo: $("#MobileNo").val(),
EmailId: $("#EmailId").val(),
DOB: $("#DOB").val(),
GID: $("#GID").val(),
BloodGroupID: $("#BloodGroupID").val(),
MSID: $("#MSID").val(),
CTC: $("#CTC").val(),
GrossAmount: $("#GrossAmount").val(),
TempAddress: $("#TempAddress").val(),
DocumentName: $("#DocumentName").val(),
TrainingDetails: $("#TrainingDetails").val(),
PanNo: $("#PanNo").val(),
ESICACCNO: $("#ESICACCNO").val(),
AutoMail: $("#AutoMail").val(),
LeaveId: $("#LeaveId").val(),
AttendanceID: $("#AttendanceID").val(),
EmpPhoto: $("#EmpPhoto").val(),
DateofJoin: $("#DateofJoin").val()

};
alert([Link](updateData));
$.ajax({

type: "PUT",
url:
"[Link]
=" + [Link],
contentType: "application/json; charset=utf-8",
dataType: "json",
data: [Link](updateData),
success: function (result) {
alert("updated Successfully")
clearFields();
},
failure: function (error) {
alert(error);
}
});
});
//DELETE

$("#btnDelete").click(function () {
alert("button is working !")
var deleteData = {
EmpCode: $("#EmpCode").val()
};
alert([Link](deleteData));
$.ajax({
type: "DELETE",
url:
"[Link] +
[Link],
contentType: "application/json; charset=utf-8",
dataType: "json",
data: [Link](deleteData),
success: function (result) {

alert("delete Successfully")
clearFields();
},
failure: function (error) {
alert(error);
}
});

});
MVC WITHOUT N TIER
__________________________________________________________________________
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{

public class SupplierMaster

{
public int Id { get; set; }
public string SuppCode { get; set; }
public string SuppName { get; set; }

public string ContactPerson { get; set; }

public string Branch { get; set; }
public string Address1 { get; set; }
public string Address2 { get; set; }
public string City { get; set; }
public string State { get; set; }

public int PinCode { get; set; }

public string Country { get; set; }

public string EmailID { get; set; }

public int Telephone { get; set; }

public int Mobile { get; set; }

public string Fax { get; set; }

public string Website { get; set; }
public string GSTIN { get; set; }
public string Remarks { get; set; }
public string UserName { get; set; }
public string LoginBranch { get; set; }

public DateTime SysEntryDate { get; set; }

}
public class SupplierMasterCtrlController : Controller
{
// GET: SupplierMasterCtrl
public ActionResult Index()
{
 string str = "data source =PRASAD;initial
catalog=DEMO_DB;integrated security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("getAllSupplierMaster", con);
[Link] = [Link];
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
dt = [Link][0];
List<SupplierMaster> lst = new List<SupplierMaster>();
foreach (DataRow item in [Link])
{
[Link](new SupplierMaster()
{
Id = Convert.ToInt32(item["Id"]),
SuppCode= item["SuppCode"].ToString(),
SuppName= item["SuppName"].ToString(),
ContactPerson = item["ContactPerson"].ToString(),
Branch = item["Branch"].ToString(),
Address1 = item["Address1"].ToString(),
Address2 = item["Address2"].ToString(),
City = item["City"].ToString(),
State = item["State"].ToString(),
PinCode = Convert.ToInt32(item["PinCode"]),
Country= item["Country"].ToString(),
EmailID= item["EmailID"].ToString(),
Telephone= Convert.ToInt32(item["Telephone"]),
Mobile= Convert.ToInt32(item["Mobile"]),
Fax= item["Fax"].ToString(),
Website = item["Website"].ToString(),
GSTIN = item["GSTIN"].ToString(),
Remarks = item["Remarks"].ToString(),
UserName = item["UserName"].ToString(),
LoginBranch = item["LoginBranch"].ToString(),
SysEntryDate=[Link](item["SysEntryDate"])
});
}
return View(lst);
}

// GET: SupplierMasterCtrl/Details/5
public ActionResult Details(int id)
{
string str = "data source =PRASAD;initial
catalog=DEMO_DB;integrated security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("getByIdSupplierMaster", con);
[Link] = [Link];
[Link]("@Id", id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
 dt = [Link][0];
SupplierMaster sup = new SupplierMaster();
[Link] = Convert.ToInt32([Link][0]["Id"]);

[Link] = [Link][0]["SuppCode"].ToString();
[Link] = [Link][0]["SuppName"].ToString();

[Link] = [Link][0]["ContactPerson"].ToString();
[Link] = [Link][0]["Branch"].ToString();

sup.Address1 = [Link][0]["Address1"].ToString();
sup.Address2 = [Link][0]["Address2"].ToString();

[Link] = [Link][0]["City"].ToString();
[Link] = [Link][0]["State"].ToString();

[Link] = Convert.ToInt32([Link][0]["PinCode"]);

[Link] = [Link][0]["Country"].ToString();
[Link] = [Link][0]["EmailID"].ToString();

[Link] = Convert.ToInt32([Link][0]["Telephone"]);
[Link] = Convert.ToInt32([Link][0]["Mobile"]);

[Link] = [Link][0]["Fax"].ToString();
[Link] = [Link][0]["Website"].ToString();
[Link] = [Link][0]["GSTIN"].ToString();
[Link] = [Link][0]["Remarks"].ToString();
[Link] = [Link][0]["UserName"].ToString();
[Link] = [Link][0]["LoginBranch"].ToString();

[Link] = [Link][0]["LoginBranch"].ToString();

return View(sup);
}

// GET: SupplierMasterCtrl/Create
[HttpGet]
public ActionResult Create()
{
return View();
}

// POST: SupplierMasterCtrl/Create
[HttpPost]
public ActionResult Create(SupplierMaster sm)
{
try
{
int res = 0;
string str = "data source =PRASAD;initial
catalog=DEMO_DB;integrated security=true";
SqlConnection con = new SqlConnection(str);
 SqlCommand cmd = new SqlCommand("saveSupplierMaster",
con);
[Link] = [Link];
[Link]();
[Link]("@SuppCode", [Link]);
[Link]("@SuppName", [Link]);

[Link]("@ContactPerson",
[Link]);
[Link]("@Branch", [Link]);
[Link]("@Address1", sm.Address1);
[Link]("@Address2", sm.Address2);
[Link]("@City", [Link]);
[Link]("@State", [Link]);
[Link]("@PinCode", [Link]);
[Link]("@Country", [Link]);
[Link]("@EmailID", [Link]);
[Link]("@Telephone", [Link]);
[Link]("@Mobile", [Link]);
[Link]("@Fax", [Link]);
[Link]("@Website", [Link]);
[Link]("@GSTIN", [Link]);
[Link]("@Remarks", [Link]);
[Link]("@UserName", [Link]);
[Link]("@LoginBranch",
[Link]);
[Link]("@SysEntryDate",
[Link]);

res = [Link]();
[Link]();
return RedirectToAction("Index");
}
catch
{
return View();
}
}

// GET: SupplierMasterCtrl/Edit/5
public ActionResult Edit(int id)
{
string str = "data source =PRASAD;initial
catalog=DEMO_DB;integrated security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("getByIdSupplierMaster", con);
[Link] = [Link];
[Link]("@Id", id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
dt = [Link][0];
 SupplierMaster sup = new SupplierMaster();
[Link]= Convert.ToInt32([Link][0]["Id"]);

[Link] = [Link][0]["SuppCode"].ToString();
[Link] = [Link][0]["SuppName"].ToString();

[Link] = [Link][0]["ContactPerson"].ToString();
[Link] = [Link][0]["Branch"].ToString();

sup.Address1 = [Link][0]["Address1"].ToString();
sup.Address2 = [Link][0]["Address2"].ToString();

[Link] = [Link][0]["City"].ToString();
[Link] = [Link][0]["State"].ToString();

[Link] = Convert.ToInt32([Link][0]["PinCode"]);

[Link] = [Link][0]["Country"].ToString();
[Link] = [Link][0]["EmailID"].ToString();

[Link] = Convert.ToInt32([Link][0]["Telephone"]);
[Link] = Convert.ToInt32([Link][0]["Mobile"]);

[Link] = [Link][0]["Fax"].ToString();
[Link] = [Link][0]["Website"].ToString();
[Link] = [Link][0]["GSTIN"].ToString();
[Link] = [Link][0]["Remarks"].ToString();
[Link] = [Link][0]["UserName"].ToString();
[Link] = [Link][0]["LoginBranch"].ToString();

[Link] = [Link][0]["LoginBranch"].ToString();

return View(sup);

// POST: SupplierMasterCtrl/Edit/5
[HttpPost]
public ActionResult Edit(int id, SupplierMaster sup)
{
try
{
int res = 0;
string str = @"Data Source=PRASAD;Initial catalog=DEMO_DB;
Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("updateSupplierMaster",
con);
[Link] = [Link];
[Link]();

[Link]("@Id", id);
[Link]("@SuppCode", [Link]);
[Link]("@SuppName", [Link]);
 [Link]("@ContactPerson",
[Link]);
[Link]("@Branch", [Link]);
[Link]("@Address1", sup.Address1);
[Link]("@Address2", sup.Address2);
[Link]("@City", [Link]);
[Link]("@State", [Link]);
[Link]("@PinCode", [Link]);
[Link]("@Country", [Link]);
[Link]("@EmailID", [Link]);
[Link]("@Telephone", [Link]);
[Link]("@Mobile", [Link]);
[Link]("@Fax", [Link]);
[Link]("@Website", [Link]);
[Link]("@GSTIN", [Link]);
[Link]("@Remarks", [Link]);
[Link]("@UserName", [Link]);
[Link]("@LoginBranch",
[Link]);
[Link]("@SysEntryDate",
[Link]);

res = [Link]();
int nAffectedRows = [Link]();
[Link]();

if (nAffectedRows > 0)
{
[Link]("<script>alert('update
Successfully....')</script>");

}
else
{
[Link]("<script>alert('Error
Occured...')</script>");
}
return RedirectToAction("Index");
// TODO: Add update logic here

}
catch
{
return View();
}
}

// GET: SupplierMasterCtrl/Delete/5
public ActionResult Delete(int id)
{
 string str = "data source =PRASAD;initial
catalog=DEMO_DB;integrated security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("getByIdSupplierMaster", con);
[Link] = [Link];
[Link]("@Id", id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
dt = [Link][0];
SupplierMaster sup = new SupplierMaster();
[Link] = Convert.ToInt32([Link][0]["Id"]);

[Link] = [Link][0]["SuppCode"].ToString();
[Link] = [Link][0]["SuppName"].ToString();

[Link] = [Link][0]["ContactPerson"].ToString();
[Link] = [Link][0]["Branch"].ToString();

sup.Address1 = [Link][0]["Address1"].ToString();
sup.Address2 = [Link][0]["Address2"].ToString();

[Link] = [Link][0]["City"].ToString();
[Link] = [Link][0]["State"].ToString();

[Link] = Convert.ToInt32([Link][0]["PinCode"]);

[Link] = [Link][0]["Country"].ToString();
[Link] = [Link][0]["EmailID"].ToString();

[Link] = Convert.ToInt32([Link][0]["Telephone"]);
[Link] = Convert.ToInt32([Link][0]["Mobile"]);

[Link] = [Link][0]["Fax"].ToString();
[Link] = [Link][0]["Website"].ToString();
[Link] = [Link][0]["GSTIN"].ToString();
[Link] = [Link][0]["Remarks"].ToString();
[Link] = [Link][0]["UserName"].ToString();
[Link] = [Link][0]["LoginBranch"].ToString();

[Link] = [Link][0]["LoginBranch"].ToString();

return View(sup);

// POST: SupplierMasterCtrl/Delete/5
[HttpPost]
public ActionResult Delete(int id, SupplierMaster sup)
{
try
{
 string str = "data source =PRASAD;initial
catalog=DEMO_DB;integrated security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("deleteSupplierMaster",
con);
[Link] = [Link];
[Link]();

[Link]("@Id", id);
[Link]();
[Link]();

return RedirectToAction("Index");
}
catch
{
return View();
}
}
}
}

WEB API WITHOUT N TIER

__________________________________________________________________________

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public class ModalSalesman
{
public int saleman_ID { get; set; }
public string Sname { get; set; }
public string city { get; set; }
public decimal commission { get; set; }
}
 [EnableCors(origins: "*", headers: "*", methods: "*")]
public class SalesmanController : ApiController
{
//[Link]
[HttpGet]
public DataTable getAllSalesman()
{
string str = @"Data Source=PRASAD;Initial catalog=MVC;
Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("getAllSalesman", con);
[Link] = [Link];
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
dt = [Link][0];
return dt;
}

[HttpGet]
//[Link]
public DataTable GetById(int id)
{
string str = @"Data Source=PRASAD;Initial catalog=MVC;
Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("getByIdsalesman", con);
[Link] = [Link];
[Link]("@saleman_ID", id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
dt = [Link][0];
return dt;
}

[HttpPost]
//[Link]
public int SaveData(ModalSalesman modal)
{
string str = "Data Source=PRASAD;Initial catalog=MVC;
Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("saveSalesman", con);
[Link] = [Link];
[Link]();
[Link]("@Sname", [Link]);
[Link]("@city", [Link]);
[Link]("@commission", [Link]);
int res = [Link]();
[Link]();
return res; }
 [HttpPut]
//[Link]
public int UpdateData(int id, ModalSalesman modal)
{
string str = @"Data Source=PRASAD;Initial catalog=MVC;
Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("updateSalesman", con);
[Link] = [Link];
[Link]("@saleman_ID", id);
[Link]("@Sname", [Link]);
[Link]("@city", [Link]);
[Link]("@commission", [Link]);
[Link]();
int res = [Link]();
[Link]();
return res;
}

[HttpDelete]
//[Link]
public int DeleteSalesman(int id, ModalCustomer modal)
{
string str = @"Data Source=PRASAD;Initial catalog=MVC;
Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("deleteSalesman", con);
[Link] = [Link];

[Link]("@saleman_ID", id);

[Link]();
int res = [Link]();
[Link]();

return res;
}
}
}
CODE GENERATION

public string BindIndentNumber(IndentMasterModel IndentModal)

{
string str = @"Data Source=PRASAD; Initial
catalog=OfflineProject ; Integrated Security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("newItemCode", con);
[Link] = [Link];
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
[Link](ds);
dt = [Link][0];
int IndentCode =
Convert.ToInt32([Link][0]["IndentNoAutoGen2"].ToString());
string NewIndentCode = [Link](IndentCode + 1);
string Code = [Link](4, '0');
string IndentCode2 = "PMRSMP" + Code;
[Link]();
return IndentCode2;

Custom Validation

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public class CustomValidation : ValidationAttribute
{
protected override ValidationResult IsValid(object value,
ValidationContext validationContext)
{
var model =
(CompanyMasterModel)[Link];
 if (model != null)
{
if (value != null && value is string stringValue)
{
if ([Link] == "Mobile")
{

if ([Link] == 10 &&
[Link]([Link]))
{
return [Link];
}
else
{
return new ValidationResult("Mobile number
must be 10 digits long.");
}
}
else if ([Link] ==
"CompanyName")
{

if ([Link] == 5 &&
[Link]([Link]))
{
return [Link];
}
else
{
return new ValidationResult("Company name must
be 5 letters.");
}
}
//PinCode
else if ([Link] == "PinCode")
{

if ([Link] == 6 &&
[Link]([Link]))
{
return [Link];
}
else
{
return new ValidationResult("PinCode name must
be 6 digit.");
}
}
}
}

return new ValidationResult("Invalid model type or null

value");
 }
}
}

POP UP PARTIAL VIEW

<script
src="[Link]
cript>

<button type="button" class="btn-block" style="width:225px">Create

Customer</button>
<div class="modal fade" id="myModal" role="dialog" data-
url='@[Link]("Create","CustomerMasterCtrl")'></div>
<script type="text/javascript">

$(document).ready(function () {

$('.btn-block').click(function () {

var url = $('#myModal').data('url');

$.get(url, function (data) {

$("#myModal").html(data);
$("#myModal").modal('show');
});

});
});
</script>

<div class="container">
 <div class="row">
<div class="modal-dialog">
<div class="modal-content">

<!-- Modal Header -->

<div class="modal-header">

<button type="button" class="close" data-

dismiss="modal">&times;</button>
<h4 class="modal-title" id="myModal-label">Modal
Title</h4>
</div>

<!-- Modal Footer -->

<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-
dismiss="modal">Close</button>
</div>

</div>
</div>
</div>
</div>

<button type="button" class="BtnEdit2_@[Link] btn-success"

style="width:65px">Edit</button>
<div class="modal fade"
id="myModal1_@[Link]" role="dialog" data-
url='@[Link]("Edit","Master", new { id=[Link]})'></div>

<script type="text/javascript">
$(document).ready(function () {

$('.BtnEdit2_@[Link]').click(function () {
var url =
$('#myModal1_@[Link]').data('url');
$.get(url, function (data) {

$("#myModal1_@[Link]").html(data);

$("#myModal1_@[Link]").modal('show');
});
});

});
</script>
<div class="modal-dialog" style="height: Auto; width:auto;">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
&times;
</button>
<h4 class="modal-title">Add New Item </h4>
</div>
<div class="modal-body form-group-sm">
<div class="col-lg-12 col-md-12">
<div class="box box-info">

//code

<!-- /.box-header -->

<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
</div>
<div class="modal-footer">
</div>
</div>
</div>

VIEW BAG
DataTable dt = new DataTable();
dt = [Link]();
List<SupplierMasterMVCModal> lst = new
List<SupplierMasterMVCModal>();
foreach (DataRow item in [Link])
{
[Link](new SupplierMasterMVCModal()
{
CountryId = Convert.ToInt32(item["CountryId"]),
Country = item["Country"].ToString()
});
}
[Link]= lst;

@[Link](model => [Link], new

SelectList(ViewBag.list4, "CountryId", "Country"), "Select Country",
htmlAttributes: new { @class = "form-control" })
DOWNLOAD TO EXCEL

public ActionResult ExportToExcel()

{
dt9 = [Link]();
using (var workbook = new XLWorkbook())
{
var worksheet =
[Link]("MachineMasterData");
[Link](1, 1).InsertTable(dt9);

[Link]();
[Link] = true;
[Link]("content-disposition", "attachment;
filename=[Link]");
[Link] = "application/[Link]-
[Link]";

using (MemoryStream memoryStream = new MemoryStream())

{
[Link](memoryStream);
[Link]([Link]);
[Link]();
}

[Link]();
}

return RedirectToAction("MachineJWList");
}
SAVE ERRORS IN FILE AND DATABASE

using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace StandardMetals
{
public class handler
{
public static void AppendTextToFile(string text)
{
string outputPath = @"D:\[Link]";
using (StreamWriter writer = new StreamWriter(outputPath,
true))
{
[Link]("--------------------------------------
new log start ------------------------------------------------------------
--------------");
[Link]($"Timestamp: {[Link]}");
[Link](text);
[Link]("----------------------------------------
-------------------------------- log end ---------------------------------
--------------");
[Link]();
}
string str = "data source =PRASAD;initial
catalog=Project;integrated security=true";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("AddLogTable", con);
[Link] = [Link];
[Link]();

[Link]("@logName", text);
[Link]("@logDate", [Link]);

[Link]();
[Link]();
}

}
}