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