public async Task <JsonResult> UpdateHangJob() { try { HangJob hj = new HangJob(); hj.jobordernumber = Request.Form["data[123][job_order_no]"].FirstOrDefault(); hj.lastname = Request.Form["data[123][emp_ln_hang]"].FirstOrDefault(); hj.sequence_number = Request.Form["data[123][sequence_no]"].FirstOrDefault(); hj.part_number = Request.Form["data[123][part_no]"].FirstOrDefault(); hj.nmr_number = Request.Form["data[123][nmr_no]"].FirstOrDefault(); hj.paint_color = Request.Form["data[123][paint_color]"].FirstOrDefault(); hj.value_stream = Request.Form["data[123][value_stream_id]"].FirstOrDefault(); hj.qty_hung = "1"; string query = String.Empty; query = "UPDATE paint_tracker SET "; query += "job_order_no = '" + NJS_Helper.FormatStringforDB(hj.jobordernumber) + "', "; query += "nmr_no = '" + NJS_Helper.FormatStringforDB(hj.nmr_number) + "', "; query += "sequence_no = '" + NJS_Helper.FormatStringforDB(hj.sequence_number) + "', "; query += "part_no = '" + NJS_Helper.FormatStringforDB(hj.part_number) + "', "; query += "value_stream_id = '" + NJS_Helper.FormatStringforDB(hj.value_stream) + "', "; query += "paint_color = '" + App_Helper.GetPaintCode() + NJS_Helper.FormatStringforDB(hj.paint_color) + "', "; query += "qty_hung = " + NJS_Helper.FormatStringforDB(hj.qty_hung) + ", "; //if (reworkCB.Checked == true) //{ // query += "rework= 'Y' "; //} //else //{ query += "rework= 'N' "; //} // query += "WHERE (auto_id = " + auto_id + ")"; using (MySqlConnection con = new MySqlConnection(DB.connection_string)) { MySqlCommand cmd = new MySqlCommand(query, con); cmd.Connection.Open(); int rows = cmd.ExecuteNonQuery(); cmd.Connection.Close(); // to be implemented to store data in tables return(Json(new { data = "Not Implemented" })); } } catch (Exception ex) { return(Json(new { data = ex.Message })); } }
public User Authenticate(string username, string password) { if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { return(null); } var user = context.Users.FirstOrDefault(x => x.UserName == username); if (user == null) { return(null); } if (!App_Helper.VerifyPasswordHash(password, user.PasswordHash, user.PasswordSalt)) { return(null); } return(user); }
public User CreateUser(User user, string password) { if (string.IsNullOrWhiteSpace(password)) { throw new Exception("Password is required"); } if (context.Users.Any(x => x.UserName == user.UserName)) { throw new Exception("Username \"" + user.UserName + "\" is already taken"); } byte[] passwordHash, passwordSalt; App_Helper.CreatePasswordHash(password, out passwordHash, out passwordSalt); user.PasswordHash = passwordHash; user.PasswordSalt = passwordSalt; context.Users.Add(user); context.SaveChanges(); return(user); }
public async Task <JsonResult> InsertHangJob(string trackerType) { try { HangJob hj = new HangJob(); hj.jobordernumber = Request.Form["data[0][job_order_no]"].FirstOrDefault(); hj.lastname = Request.Form["data[0][emp_ln_hang]"].FirstOrDefault(); hj.sequence_number = Request.Form["data[0][sequence_no]"].FirstOrDefault(); hj.part_number = Request.Form["data[0][part_no]"].FirstOrDefault(); hj.nmr_number = Request.Form["data[0][nmr_no]"].FirstOrDefault(); hj.paint_color = Request.Form["data[0][paint_color]"].FirstOrDefault(); hj.value_stream = Request.Form["data[0][value_stream_id]"].FirstOrDefault(); hj.qty_hung = "1"; string query = String.Empty; query = "INSERT INTO paint_tracker (auto_id, emp_no_hang, job_order_no, nmr_no, sequence_no, "; query += "part_no, value_stream_id, paint_color, qty_hung, dt_hang, rework, from_app) VALUES ("; query += "NULL, "; query += "" + hj.hangjob_id + ", "; query += "'" + NJS_Helper.FormatStringforDB(hj.jobordernumber) + "', "; query += "'" + NJS_Helper.FormatStringforDB(hj.nmr_number) + "', "; query += "'" + NJS_Helper.FormatStringforDB(hj.sequence_number) + "', "; query += "'" + NJS_Helper.FormatStringforDB(hj.part_number) + "', "; query += "'" + NJS_Helper.FormatStringforDB(hj.value_stream) + "', "; query += "'" + App_Helper.GetPaintCode() + NJS_Helper.FormatStringforDB(hj.paint_color) + "', "; query += "" + NJS_Helper.FormatStringforDB(hj.qty_hung) + ", "; query += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', "; //if (reworkCB.Checked == true) //{ // query += "'Y' "; //} //else //{ query += "'N' "; //} query += ", 'Paint " + trackerType + "'"; query += ")"; using (MySqlConnection con = new MySqlConnection(DB.connection_string)) { MySqlCommand myCommand = new MySqlCommand(query, con); myCommand.Connection.Open(); myCommand.ExecuteNonQuery(); con.Close(); } // to be implemented to store data in tables return(Json(new { data = "Record Inserted" })); } catch (Exception ex) { string x = ex.Message; return(Json(new { data = ex.Message })); } }