protected void btnPrintPO_Click(object sender, EventArgs e) { POUpload(lblPONumber.Text, Convert.ToInt32(Session["idPOHeader"].ToString())); var objLogs = new Logs_Model(); objLogs.idUser = Users.GetUserIDByDomainLogin(oCon, Session["User_Domain"].ToString()); objLogs.Form = "POCreation"; objLogs.Description = "Download PO Number : " + lblPONumber.Text + ""; Logs.Save(oCon, objLogs); }
public static bool Save(SqlConnection connection, Logs_Model model) { bool returnValue = true; var GUID = SQL_Transact.GenerateGUID(); SQL_Transact.BeginTransaction(connection, GUID); StringBuilder sQuery = new StringBuilder(); sQuery.Append(@"INSERT INTO a_Logs (idUser ,Description ,Form) VALUES (@idUser ,@Description ,@Form) "); using (SqlCommand cmd = new SqlCommand()) { try { cmd.Connection = connection; cmd.CommandText = sQuery.ToString(); cmd.CommandType = CommandType.Text; SqlParameter parm1 = new SqlParameter { ParameterName = "@idUser", SqlDbType = SqlDbType.Int, Value = model.idUser }; cmd.Parameters.Add(parm1); SqlParameter parm2 = new SqlParameter { ParameterName = "@Description", SqlDbType = SqlDbType.NVarChar, Value = model.Description }; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter { ParameterName = "@Form", SqlDbType = SqlDbType.NVarChar, Value = model.Form }; cmd.Parameters.Add(parm3); if (cmd.ExecuteNonQuery() >= 1) { returnValue = true; cmd.Dispose(); cmd.Parameters.Clear(); SQL_Transact.CommitTransaction(connection, GUID); } } catch { cmd.Dispose(); cmd.Parameters.Clear(); SQL_Transact.RollbackTransaction(connection, GUID); } } return(returnValue); }
protected void btnSave_Click(object sender, EventArgs e) { var objCustomerDetails = new Customer_Details_Model(); if (txtCompanyName.Text != "") { string CustCode = Customer_Details.GetLastCustomerCode(oCon); if (CustCode == null) { CustCode = "CC000000"; } CustCode = CustCode.Substring(2); int CustCode_ = int.Parse(CustCode) + 1; string Customer_Code = "CC" + CustCode_.ToString("000000"); objCustomerDetails.Customer_Name = txtCustomerName.Text; objCustomerDetails.Address1 = txtAddress1.Text; objCustomerDetails.Address2 = txtAddress2.Text; objCustomerDetails.Address3 = txtAddress3.Text; objCustomerDetails.Address4 = txtAddress4.Text; objCustomerDetails.credit_term = ddCreditTerm.SelectedItem.Text; objCustomerDetails.Company_Name = txtCompanyName.Text; objCustomerDetails.Status = ddStatus.SelectedItem.Text; objCustomerDetails.AddressShipping1 = txtShipAddress1.Text; objCustomerDetails.AddressShipping2 = txtShipAddress2.Text; objCustomerDetails.AddressShipping3 = txtShipAddress3.Text; objCustomerDetails.AddressShipping4 = txtShipAddress4.Text; objCustomerDetails.user_chg_by = Session["User_Domain"].ToString(); objCustomerDetails.Customer_Type = ddCustomerType.SelectedItem.Text; objCustomerDetails.Credit_Limit = txtCreditLimit.Text; objCustomerDetails.Position = txtPosition.Text; objCustomerDetails.Contact_Number = txtContactNo.Text; objCustomerDetails.TIN_Number = txtTINNo.Text; objCustomerDetails.Salesman = ddSalesman.SelectedItem.Text; objCustomerDetails.Email_Address = txtEmailAddress.Text; if (Session["Mode"].ToString() == "A") { objCustomerDetails.Customer_Code = Customer_Code; Customer_Details.Save(oCon, objCustomerDetails); } else if (Session["Mode"].ToString() == "E") { objCustomerDetails.idCustomer = Convert.ToInt32(Session["idCustomer"]); objCustomerDetails.Customer_Code = Session["CustomerCode"].ToString(); Customer_Details.Update(oCon, objCustomerDetails); } var objLogs = new Logs_Model(); objLogs.idUser = Users.GetUserIDByDomainLogin(oCon, Session["User_Domain"].ToString()); objLogs.Form = "Customer Maintenance"; if (Session["Mode"].ToString() == "A") { objLogs.Description = "Save Record: Customer_Code = " + Customer_Code + ""; } if (Session["Mode"].ToString() == "E") { objLogs.Description = "Update Record: Customer_Code = " + Session["CustomerCode"].ToString() + ""; } Logs.Save(oCon, objLogs); defaultSettings(); GetCustomerDetails(); if (Session["Mode"].ToString() == "A") { HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Customer record has been saved. Customer Code : " + Customer_Code + ControlChars.Quote + ");</script>"); } else if (Session["Mode"].ToString() == "E") { HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Update Successful. Customer Code : " + Session["CustomerCode"].ToString() + ControlChars.Quote + ");</script>"); } } }