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
}));
}
}
