public JsonResult LEDSearch(string liftpartNumber, string liftDocNumber, string liftPartType, string liftdesc, string Compwhereused, string liftpartStatus, string Productwhere,
string hasCertification, string hasInsDoc, string tare, string wll, string tarevalue, string wllvalue, string SearchBy)
{
/*if (Convert.ToString(Session["username"]) != "")
* {*/
liftpartNumber = liftpartNumber != "undefined" ? liftpartNumber : "";
liftpartNumber = liftpartNumber != "null" ? liftpartNumber.Replace("_", "[_]") : "";
liftDocNumber = liftDocNumber != "undefined" ? liftDocNumber.Replace("_", "[_]") : "";
liftPartType = liftPartType != "undefined" ? liftPartType : "";
liftdesc = liftdesc != "undefined" ? liftdesc : "";
liftpartStatus = liftpartStatus != "undefined" ? liftpartStatus : "";
Compwhereused = Compwhereused != "undefined" ? Compwhereused.Replace("_", "[_]") : "";
Productwhere = Productwhere != "undefined" ? Productwhere.Replace("_", "[_]") : "";
hasInsDoc = hasInsDoc != "undefined" ? hasInsDoc : "";
hasCertification = hasCertification != "undefined" ? hasCertification : "";
tare = tare != "undefined" ? tare : "";
wll = wll != "undefined" ? wll : "";
wllvalue = wllvalue != "undefined" ? wllvalue : "0.0";
tarevalue = tarevalue != "undefined" ? tarevalue : "0.0";
SearchBy = SearchBy != "undefined" ? SearchBy : "";
var data = Mainclass.Display("exec [sp_LEDSearch] @liftpartNumber = '" + liftpartNumber + "', @liftDocNumber = '" + liftDocNumber + "', @liftPartType = '" + liftPartType + "', @liftdesc = '" + liftdesc + "', @Compwhereused = '" + Compwhereused + "', @liftpartStatus = '" + liftpartStatus + "', @Productwhere = '" + Productwhere + "', @hasCertification = '" + hasCertification + "', @hasInsDoc = '" + hasInsDoc + "', @tare = '" + tare + "', @wll = '" + wll + "', @tarevalue = '" + tarevalue + "', @wllvalue = '" + wllvalue + "', @SearchBy = '" + SearchBy + "', @count = " + count + "");
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
/*}
* else
* return Json("1", JsonRequestBehavior.AllowGet);*/
}
public ActionResult AddUser(string userEmail, string usrRole, string firstName, string lastName, string userId, string appPwd, string userTitle, string companyName, string userPhone, string userFax)
{
userEmail = userEmail != "undefined" ? userEmail : "";
usrRole = usrRole != "undefined" ? usrRole : "";
firstName = firstName != "undefined" ? firstName : "";
lastName = lastName != "undefined" ? lastName : "";
appPwd = appPwd != "undefined" ? appPwd : "";
//byte[] array = System.Text.Encoding.ASCII.GetBytes(appPwd);
//appPwd = Mainclass.ByteArrayToString(array);
userTitle = userTitle != "undefined" ? userTitle : "";
companyName = companyName != "undefined" ? companyName : "";
userPhone = userPhone != "undefined" ? userPhone : "";
userFax = userFax != "undefined" ? userFax : "";
userId = userId != "undefined" ? userId.Replace("_", "[_]") : "";
string query = "exec [sp_adduserapp] '" + userEmail + "','" + usrRole + "','" + firstName + "','" + lastName + "','" + userId + "','" + appPwd + "','" + userTitle + "','" + companyName + "','" + userPhone + "','" + userFax + "'";
var data = Mainclass.Display("exec [sp_adduserapp] '" + userEmail + "','" + usrRole + "','" + firstName + "','" + lastName + "','" + userId + "','" + appPwd + "','" + userTitle + "','" + companyName + "','" + userPhone + "','" + userFax + "'");
/*model.sp_partsearch(Partnumber, LegPartNumer, prtstatus, dconum, LegDocNumber, parttyp).ToList();*/
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
//}
//else
// return Json("1", JsonRequestBehavior.AllowGet);
}
public JsonResult Getledsearchdetail(int id)
{
var data = Mainclass.Display("DECLARE @document NVARCHAR(max) DECLARE @certification NVARCHAR(max) DECLARE @partwhere NVARCHAR(max) DECLARE @productwhere NVARCHAR(max) exec sp_ledsearchdetail " + id + ", @document OUTPUT, @certification OUTPUT, @partwhere OUTPUT, @productwhere OUTPUT select @document as document, @certification as certification, @partwhere as partwhere, @productwhere as productwhere");
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public ActionResult Getetodetail(int id)
{
var data = Mainclass.Display("DECLARE @document NVARCHAR(max) DECLARE @gadrawing NVARCHAR(max) DECLARE @routing NVARCHAR(max) DECLARE @order NVARCHAR(max) DECLARE @reference NVARCHAR(max) exec [sp_etodetail] " + id + ", @document OUTPUT, @gadrawing OUTPUT, @routing OUTPUT , @order OUTPUT , @reference OUTPUT select @document as document, @gadrawing as ga, @routing as routing , @order as [order] , @reference as reference");
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public ActionResult GetLedPartdetail(long id)
{
var data = Mainclass.Display("exec sp_ledsearchdetail " + id + "");
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public ActionResult ChangePassword(string email, string password, string newpassword)
{
password = password != "undefined" ? password : "";
byte[] array = Encoding.ASCII.GetBytes(password);
var data = Mainclass.Display("exec sp_validateUser @Email = '" + email + "'");
if ((data != null) && (data.Count > 0))
{
string username = data[0]["email"].ToString();
string role = data[0]["userRole"].ToString();
Session["username"] = username;
Session["role"] = role;
int status = Convert.ToInt32(data[0]["status"]);
if (status != 1)
{
return(Json(new { mode = 4, username }, JsonRequestBehavior.AllowGet));
}
byte[] pwd;
if ((data[0]["password"] == DBNull.Value) && (password == ""))
{
pwd = Encoding.ASCII.GetBytes(password);
}
else
{
pwd = (byte[])data[0]["password"];
}
if (System.Collections.StructuralComparisons.StructuralEqualityComparer.Equals(array, pwd))
{
var data1 = Mainclass.Display("exec sp_changepwd @email = '" + email + "', @newpassword = '******'");
if ((data1 != null) && (data1.Count > 0))
{
string errorno = data1[0]["ErrorNumber"].ToString();
string errmsg = data1[0]["ErrorMessage"].ToString();
if (errorno == "0")
{
return(Json(new { mode = 1 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { mode = 2, errormessage = errmsg }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { mode = 6 }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { mode = 3 }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { mode = 5 }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Getpcndetail(int id)
{
var data = Mainclass.Display("DECLARE @problem NVARCHAR(max) DECLARE @solution NVARCHAR(max) DECLARE @impacted NVARCHAR(max) exec[sp_pcndetail] " + id + ",@problem OUTPUT , @solution OUTPUT, @impacted OUTPUT select @problem as problem,@solution as solution, @impacted as impacted");
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public ActionResult AMRSearch(string amrType, string amrEmail, string amrStatus, string amrItemNo, string amrRequestNo, string amrNewMaterialCode, string amrPartDescription)
{
//if (Convert.ToString(Session["username"]) != "")
//{
amrEmail = amrEmail != "undefined" ? amrEmail : "";
amrItemNo = amrItemNo != "undefined" ? amrItemNo.Replace("_", "[_]") : "";
amrRequestNo = amrRequestNo != "undefined" ? amrRequestNo.Replace("_", "[_]") : "";
amrNewMaterialCode = amrNewMaterialCode != "undefined" ? amrNewMaterialCode : "";
amrPartDescription = amrPartDescription != "undefined" ? amrPartDescription.Replace("_", "[_]") : "";
string query = "exec [sp_displayamrrequest] '" + amrType + "','" + amrEmail + "','" + amrStatus + "','" + amrItemNo + "','" + amrRequestNo + "','" + amrNewMaterialCode + "','" + amrPartDescription + "'";
var data = Mainclass.Display("exec [sp_displayamrrequest] '" + amrType + "','" + amrEmail + "','" + amrStatus + "','" + amrItemNo + "','" + amrRequestNo + "','" + amrNewMaterialCode + "','" + amrPartDescription + "'");
/*model.sp_partsearch(Partnumber, LegPartNumer, prtstatus, dconum, LegDocNumber, parttyp).ToList();*/
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
//}
//else
// return Json("1", JsonRequestBehavior.AllowGet);
}
public ActionResult UserSearch(string userID, string email, string userName, string userRole)
{
//if (Convert.ToString(Session["username"]) != "")
//{
userID = userID != "undefined" ? userID : "";
userID = userID != "null" ? userID.Replace("_", "[_]") : "";
email = email != "undefined" ? email.Replace("_", "[_]") : "";
userName = userName != "undefined" ? userName : "";
userRole = userRole != "undefined" ? userRole.Replace("_", "[_]") : "";
var data = Mainclass.Display("exec [sp_displayuser] '" + userID + "','" + email + "','" + userName + "','" + userRole + "'");
/*model.sp_partsearch(Partnumber, LegPartNumer, prtstatus, dconum, LegDocNumber, parttyp).ToList();*/
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
//}
//else
// return Json("1", JsonRequestBehavior.AllowGet);
}
public ActionResult PartSearch(string Partnumber, string LegPartNumer, string partStatus, string DocNumber, string LegDocNumber, string PartType, string PartDescription)
{
//if (Convert.ToString(Session["username"]) != "")
//{
Partnumber = Partnumber != "undefined" ? Partnumber : "";
Partnumber = Partnumber != "null" ? Partnumber.Replace("_", "[_]") : "";
LegPartNumer = LegPartNumer != "undefined" ? LegPartNumer.Replace("_", "[_]") : "";
partStatus = partStatus != "undefined" ? partStatus : "";
DocNumber = DocNumber != "undefined" ? DocNumber.Replace("_", "[_]") : "";
LegDocNumber = LegDocNumber != "undefined" ? LegDocNumber.Replace("_", "[_]") : "";
PartType = PartType != "undefined" ? PartType : "";
PartDescription = PartDescription != "undefined" ? PartDescription.Replace("_", "[_]") : "";
var data = Mainclass.Display("exec sp_partsearch '" + Partnumber + "','" + LegPartNumer + "','" + partStatus + "','" + DocNumber + "','" + LegDocNumber + "','" + PartType + "','" + PartDescription + "','" + count + "'");
/*model.sp_partsearch(Partnumber, LegPartNumer, prtstatus, dconum, LegDocNumber, parttyp).ToList();*/
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
//}
//else
// return Json("1", JsonRequestBehavior.AllowGet);
}
public ActionResult CreateAMRRequest(string amrType, string amrTypeName, string userEmail, string amrPartStatus, string amrPartNo, string amrPartDescription, string amrNewMaterialCode, string amrExistingMaterial, string amrRequestNumber, string amrDrawingNumber, string amrDrawingRevNo, string amrSite, string amrPriority, string amrDCO, string amrDueDate, string amrCastingRequest, string productId, string remarks, string productName, string file_data)
{
try
{
if (Request.Files.Count > 0)
{
file_data = UploadFile();
}
else
{
file_data = "";
}
amrType = amrType != "undefined" ? amrType : "0";
userEmail = userEmail != "undefined" ? userEmail : "";
amrPartStatus = amrPartStatus != "undefined" ? amrPartStatus : "0";
amrPartNo = amrPartNo != "undefined" ? amrPartNo : "";
amrPartDescription = amrPartDescription != "undefined" ? amrPartDescription : "";
amrNewMaterialCode = amrNewMaterialCode != "undefined" ? amrNewMaterialCode : "";
amrExistingMaterial = amrExistingMaterial != "undefined" ? amrExistingMaterial : "";
amrRequestNumber = amrRequestNumber != "undefined" ? amrRequestNumber : "";
amrDrawingNumber = amrDrawingNumber != "undefined" ? amrDrawingNumber : "";
amrDrawingRevNo = amrDrawingRevNo != "undefined" ? amrDrawingRevNo : "";
amrSite = amrSite != "undefined" ? amrSite : "";
amrPriority = amrPriority != "undefined" ? amrPriority : "";
amrDCO = amrDCO != "undefined" ? amrDCO : "";
amrDueDate = amrDueDate != "undefined" ? amrDueDate : "";
amrCastingRequest = amrCastingRequest != "undefined" ? amrCastingRequest : "";
productId = productId != "undefined" ? productId : "";
productName = productName != "undefined" ? productName : "";
file_data = file_data != "undefined" ? file_data : "";
remarks = remarks != "undefined" ? remarks : "";
remarks = remarks.Replace("\n", "\\n");
//var data = Mainclass.Display(@"exec [sp_createamrrequest] '" + amrType + "','" + userEmail + "','" + amrPartStatus + "','" + amrPartNo + "','" + amrPartDescription + "','" + amrNewMaterialCode + "','" + amrExistingMaterial + "','" + amrRequestNumber + "','" + amrDrawingNumber + "','" + amrDrawingRevNo + "','" + amrSite + "','" + amrPriority + "','" + amrDCO + "','" + amrDueDate + "','" + amrCastingRequest + "','" + productId + "','" + file_data + "','" + remarks + "'");
var data = Mainclass.Display("exec [sp_createamrrequest] @amr_type_id = '" + amrType + "', @requested_by = '" + userEmail + "', @status = '" + amrPartStatus + "', @item_no = '" + amrPartNo + "', @part_description = '" + amrPartDescription + "', @new_material_code = '" + amrNewMaterialCode + "', @existing_material_code = '" + amrExistingMaterial + "', @request_no = '" + amrRequestNumber + "', @drawing_no = '" + amrDrawingNumber + "', @drawing_rev_no = '" + amrDrawingRevNo + "', @site = '" + amrSite + "', @priority = '" + amrPriority + "', @dco = '" + amrDCO + "', @due_date = '" + amrDueDate + "', @casting_requested = '" + amrCastingRequest + "', @productid = '" + productId + "', @file_path = '" + file_data + "', @remarks = '" + remarks + "'");
if (data != null && data.Count > 0)
{
if (data[0]["ErrorNumber"].ToString() == "0")
{
try
{
SendAMRMail(userEmail, productId, amrPartNo, amrTypeName, file_data, productName, amrPartDescription, remarks);
}
catch (Exception ex)
{
return(Json(new { ErrorNumber = 2, ErrorMessage = "AMR Record saved. Email failed :" + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
string errorno = data[0]["ErrorNumber"].ToString();
string errmsg = data[0]["ErrorMessage"].ToString();
return(Json(new { ErrorNumber = errorno, ErrorMessage = errmsg }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ErrorNumber = 1, ErrorMessage = "Unexpected Error in Database Procedure" }, JsonRequestBehavior.AllowGet));
}
/*model.sp_partsearch(Partnumber, LegPartNumer, prtstatus, dconum, LegDocNumber, parttyp).ToList();*/
}
catch (Exception ex)
{
return(Json(new { ErrorNumber = 1, ErrorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Login1(string email, string password, string context = "") //KAMLESH-ROLE
{
// var remember = fc["rememberme"] != null ? true : false;
// string email = Convert.ToString(fc["Email"]);
// string pass = Convert.ToString(fc["Password"]);
// HttpCookie emailCookie = new HttpCookie("Email");
// HttpCookie passCookie = new HttpCookie("Password");
// if (remember == true)
// {
// //Set the Cookie value.
// emailCookie.Values["Name"] = email;
// passCookie.Values["Password"] = pass;
// //Set the Expiry date.
// }
// else
// {
// emailCookie.Values["Name"] = null;
// passCookie.Values["Password"] = null;
// }
// emailCookie.Expires = DateTime.Now.AddDays(15);
// passCookie.Expires = DateTime.Now.AddDays(15);
// Response.Cookies.Add(emailCookie);
// Response.Cookies.Add(passCookie);
byte[] array = Encoding.ASCII.GetBytes(password);
var data = Mainclass.Display("exec sp_validateUser @Email = '" + email + "'");
//var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
//jsonResult.MaxJsonLength = int.MaxValue;
//var dta = model.users.Where(a => a.email == email && a.password == array).FirstOrDefault();
if ((data != null) && (data.Count > 0))
{
string username = data[0]["email"].ToString();
string role = data[0]["userRole"].ToString();
Session["username"] = username;
Session["role"] = role;
int status = Convert.ToInt32(data[0]["status"]);
if (data[0]["password"] == DBNull.Value)
{
return(Json(new { mode = 5, username }, JsonRequestBehavior.AllowGet));
}
byte[] pwd = (byte[])data[0]["password"];
if (status != 1)
{
return(Json(new { mode = 4, username }, JsonRequestBehavior.AllowGet));
}
if ((role == "Admin") && (context != "ADM"))
{
return(Json(new { mode = 2 }, JsonRequestBehavior.AllowGet));
}
if ((role == "RegularUser") && (context != "APP"))
{
return(Json(new { mode = 2 }, JsonRequestBehavior.AllowGet));
}
if (System.Collections.StructuralComparisons.StructuralEqualityComparer.Equals(array, pwd))
{
return(Json(new { mode = 1, username, role }, JsonRequestBehavior.AllowGet));
}
return(Json(new { mode = 3 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { mode = 2 }, JsonRequestBehavior.AllowGet));
}
}