protected void InsertRecord(object sender, GridRecordEventArgs e) { var db = new SerializationDataContext(); var username = User.Identity.Name; // int tId = Convert.ToInt32(e.Record["ID"]); bool smartCodeBool = false; bool noSerialBool = false; string noSerial = e.Record["NOSERIALIZATION"].ToString(); string smartCode = e.Record["SMARTCODEONLY"].ToString(); if (noSerial == "true" || noSerial == "True") { noSerialBool = true; } if (smartCode == "true" || smartCode == "True") { smartCodeBool = true; } //Add new record. var product = new MPI() { PRODUCTID = e.Record["PRODUCTID"].ToString(), ITEMCODE = e.Record["ITEMCODE"].ToString().ToUpper(), COLOR = e.Record["COLOR"].ToString().ToUpper(), NOSERIALIZATION = noSerialBool, SMARTCODEONLY = smartCodeBool }; var productHistoryInsert = new MPI_History(); productHistoryInsert.DATE = DateTime.Now; productHistoryInsert.PRODUCTID = product.PRODUCTID; productHistoryInsert.ITEMCODE = product.ITEMCODE; productHistoryInsert.COLOR = product.COLOR; productHistoryInsert.NOSERIALIZATION = product.NOSERIALIZATION; productHistoryInsert.SMARTCODEONLY = product.SMARTCODEONLY; productHistoryInsert.TYPE = "INSERT"; productHistoryInsert.USERNAME = username; //Insert new record on MPI DB. db.MPIs.InsertOnSubmit(product); //Insert new Insert record on MPI_Histories DB. db.MPI_Histories.InsertOnSubmit(productHistoryInsert); db.SubmitChanges(); }
protected void CreateGrid() { var db = new SerializationDataContext(); var query = from p in db.MPI_Histories select new { p.DATE, p.TYPE, p.PRODUCTID, p.ITEMCODE, p.COLOR, p.SMARTCODEONLY, p.NOSERIALIZATION, p.USERNAME, }; PIHGrid.DataSource = query; PIHGrid.DataBind(); }
protected void DeleteRecord(object sender, GridRecordEventArgs e) { var db = new SerializationDataContext(); var username = User.Identity.Name; int tId = Convert.ToInt32(e.Record["ID"]); bool smartCodeBool = false; bool noSerialBool = false; string noSerial = e.Record["NOSERIALIZATION"].ToString(); string smartCode = e.Record["SMARTCODEONLY"].ToString(); if (noSerial == "true" || noSerial == "True") { noSerialBool = true; } if (smartCode == "true" || smartCode == "True") { smartCodeBool = true; } var productDelete = (from p in db.MPIs where p.ID == tId select p).First(); var productHistory = new MPI_History(); productHistory.DATE = DateTime.Now; productHistory.PRODUCTID = productDelete.PRODUCTID; productHistory.ITEMCODE = productDelete.ITEMCODE; productHistory.COLOR = productDelete.COLOR; productHistory.NOSERIALIZATION = productDelete.NOSERIALIZATION; productHistory.SMARTCODEONLY = productDelete.SMARTCODEONLY; productHistory.TYPE = "DELETE"; productHistory.USERNAME = username; //Delete Product from MPI database. db.MPIs.DeleteOnSubmit(productDelete); //Insert Deletion History into MPI History DB. db.MPI_Histories.InsertOnSubmit(productHistory); db.SubmitChanges(); }
protected void UpdateRecord(object sender, GridRecordEventArgs e) { var db = new SerializationDataContext(); var username = User.Identity.Name; int tId = Convert.ToInt32(e.Record["ID"]); bool smartCodeBool = false; bool noSerialBool = false; string noSerial = e.Record["NOSERIALIZATION"].ToString(); string smartCode = e.Record["SMARTCODEONLY"].ToString(); if (noSerial == "true" || noSerial == "True") { noSerialBool = true; } if (smartCode == "true" || smartCode == "True") { smartCodeBool = true; } //Pull up record prior to updating. var productBeforeUpdate = (from p in db.MPIs where p.ID == tId select p).First(); //Make a Record in the MaintainProductID_History table prior to updating. var productBeforeUpdateHistory = new MPI_History(); productBeforeUpdateHistory.DATE = DateTime.Now; productBeforeUpdateHistory.PRODUCTID = productBeforeUpdate.PRODUCTID; productBeforeUpdateHistory.ITEMCODE = productBeforeUpdate.ITEMCODE; productBeforeUpdateHistory.COLOR = productBeforeUpdate.COLOR; productBeforeUpdateHistory.NOSERIALIZATION = productBeforeUpdate.NOSERIALIZATION; productBeforeUpdateHistory.SMARTCODEONLY = productBeforeUpdate.SMARTCODEONLY; productBeforeUpdateHistory.TYPE = "UPDATE-BEFORE"; productBeforeUpdateHistory.USERNAME = username; db.MPI_Histories.InsertOnSubmit(productBeforeUpdateHistory); //Update MaintainProductID to update the product. var productUpdate = (from p in db.MPIs where p.ID == tId select p).First(); productUpdate.ID = tId; productUpdate.PRODUCTID = e.Record["PRODUCTID"].ToString(); productUpdate.ITEMCODE = e.Record["ITEMCODE"].ToString(); productUpdate.COLOR = e.Record["COLOR"].ToString().ToUpper(); productUpdate.NOSERIALIZATION = noSerialBool; productUpdate.SMARTCODEONLY = smartCodeBool; //Make a Record in the MaintainProductID_History table after updating. MPI_History productAfterUpdateHistory = new MPI_History(); productAfterUpdateHistory.DATE = DateTime.Now; productAfterUpdateHistory.PRODUCTID = productUpdate.PRODUCTID; productAfterUpdateHistory.ITEMCODE = productUpdate.ITEMCODE; productAfterUpdateHistory.COLOR = productUpdate.COLOR; productAfterUpdateHistory.NOSERIALIZATION = productUpdate.NOSERIALIZATION; productAfterUpdateHistory.SMARTCODEONLY = productUpdate.SMARTCODEONLY; productAfterUpdateHistory.TYPE = "UPDATE-AFTER"; productAfterUpdateHistory.USERNAME = username; db.MPI_Histories.InsertOnSubmit(productAfterUpdateHistory); db.SubmitChanges(); }