// PAYMENT SAVE BUTTON // PAYMENT SAVE BUTTON
private void buPaymentSave_Click_1(object sender, EventArgs e)
{
if (IsValidData())
{
VBRAsiaCusModel c = FillModel();
List <VBRAsiaCusModel> lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, c.Customer_No);
if (lc.Count > 0)
{
if (IsValidPaymentData())
{
PaymentsModel m = PaymentFillModel();
int i = PaymentDetailsDA.UpdatePaymentDetails(Config.VBR4000Connection, m);
i = PaymentDetailsDA.InsertPaymentDetails(Config.VBR4000Connection, m);
if (i == 1)
{
MessageBox.Show("Saved");
lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, m.Customer_No);
if (lc.Count > 0)
{
FillForm(lc[0]);
}
}
}
}
}
else
{
MessageBox.Show("Please First save the customer");
}
}
//SUPPORT BUTTON---SUPPORT BUTTON---SUPPORT BUTTON---SUPPORT BUTTON---SUPPORT BUTTON
private void btnSaveSupport_Click(object sender, EventArgs e)
{
if (IsValidData())
{
VBRAsiaCusModel c = FillModel();
List <VBRAsiaCusModel> lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, c.Customer_No);
if (lc.Count > 0)
{
if (IsSupportValidData())
{
SupportDetailsModel m = SupportFillModel();
int i = SupportDetailsDA.UpdateSupportDetail(Config.VBR4000Connection, m);
i = SupportDetailsDA.InsertSupportDetails(Config.VBR4000Connection, m);
if (i == 1)
{
MessageBox.Show("Saved");
lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, m.CutomerNo);
if (lc.Count > 0)
{
FillForm(lc[0]);
}
}
}
}
else
{
MessageBox.Show("Please save the customer");
}
}
}
private void FillForm(VBRAsiaCusModel m)
{
#region CustomerForm
txtCustomer_No.Text = m.Customer_No;
txtNamee.Text = m.Name;
txtStreet.Text = m.Street;
txtPost_Code.Text = m.Post_Code;
txtTelephone1.Text = m.Telephone1;
txtTelephone2.Text = m.Telephone2;
txtAddress_1.Text = m.Address_1;
txtAddress_2.Text = m.Address_2;
txtE_Mail.Text = m.E_Mail;
txtNo_Of_Shops.Text = m.No_Of_Shops.ToString();
dtpSupport_End_Date.Value = m.Support_End_Date;
dtpDue_Date.Value = m.Due_Date;
dtpAdded_Date.Value = m.Added_Date;
cbIsPaid.Checked = m.IsPaid;
tbInvoiceTotal.Text = m.InvoiceTotal.ToString();
tbTotalPaid.Text = m.TotalPaid.ToString();
#endregion CustomerForm
#region SupportDetail
List <SupportDetailsModel> lsm = SupportDetailsDA.GetSupportDetail(Config.VBR4000Connection, m.Customer_No);
BindSupportDetailsList(lsm);
#endregion SupportDetail
#region PaymentDetails
List <PaymentsModel> lm = PaymentDetailsDA.GetPaymentDetails(Config.VBR4000Connection, m.Customer_No);
NoOfPayments = lm.Count;
paymentsList = lm;
CurrentIndex = 0;
FillPaymentHeaderCard();
#endregion PaymentDetails
#region PaymentInstallment
List <PaymentInstallmentModel> plm = PaymentInstallmentDA.GetPaymentInstallmentDetails(Config.VBR4000Connection, m.Customer_No);
BindPaymentInstallmentList(plm);
#endregion PaymentInstallment
#region HarwdareDetails
List <JobCardHardwareModel> hlm = JobCardHardwareDA.GetHardwareDetails(Config.VBR4000Connection, m.Customer_No);
FillHardwareFormCard();
#endregion HardwareDetails
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsValidData())
{
VBRAsiaCusModel m = FillModel();
int i = VBRAsia_CustomersDA.UpdateVBRAsiaCustomer(Config.VBR4000Connection, m);
if (i == 0)
{
i = VBRAsia_CustomersDA.InsertVBRAsiaCustomer(Config.VBR4000Connection, m);
if (i == 1)
{
MessageBox.Show("Saved");
}
}
else
{
MessageBox.Show("UPDATED");
}
}
}
private VBRAsiaCusModel FillModel()
{
VBRAsiaCusModel m = new VBRAsiaCusModel();
m.Customer_No = txtCustomer_No.Text.Trim();
m.Name = txtNamee.Text.Trim();
m.Street = txtStreet.Text.Trim();
m.Post_Code = txtPost_Code.Text.Trim();
m.Telephone1 = txtTelephone1.Text.Trim();
m.Telephone2 = txtTelephone2.Text.Trim();
m.Address_1 = txtAddress_1.Text.Trim();
m.Address_2 = txtAddress_2.Text.Trim();
m.E_Mail = txtE_Mail.Text.Trim();
m.No_Of_Shops = Convert.ToInt32(txtNo_Of_Shops.Text.Trim());
m.Support_End_Date = dtpSupport_End_Date.Value;
m.Due_Date = dtpDue_Date.Value;
m.Added_Date = dtpAdded_Date.Value;
m.IsPaid = cbIsPaid.Checked;
return(m);
}
// END PAYMNET TAB CONTROLS
private void buHardwareSave_Click(object sender, EventArgs e)
{
if (IsValidHardwareData())
{
VBRAsiaCusModel c = FillModel();
List <VBRAsiaCusModel> lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, c.Customer_No);
if (lc.Count > 0)
{
int jobid;
if (int.TryParse(laJobID.Text, out jobid))
{
JobCardHardwareModel m = JobCardHardwareFillModel();
int i = JobCardHardwareDA.InsertHardwareDetails(Config.VBR4000Connection, m);
if (i == 1)
{
MessageBox.Show("Saved");
}
{
lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, m.Customer_No);
if (lc.Count > 0)
{
FillForm(lc[0]);
}
}
}
else
{
MessageBox.Show("NO JOBIB SELECT!!");
}
}
else
{
MessageBox.Show("Please First save the customer");
}
}
}
// PAYMNET INSTALLEMENT SAVE BUTTON
private void buInstallmentSave_Click_1(object sender, EventArgs e)
{
if (IsValidPaymentData())
{
VBRAsiaCusModel c = FillModel();
List <VBRAsiaCusModel> lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, c.Customer_No);
if (lc.Count > 0)
{
int jobid;
if (int.TryParse(laJobID.Text, out jobid))
{
PaymentInstallmentModel m = PaymentInstallmentFillModel();
int i = PaymentInstallmentDA.InsertPaymentInstallment(Config.VBR4000Connection, m);
if (i == 1)
{
MessageBox.Show("Saved");
}
{
lc = VBRAsia_CustomersDA.GetVBRAsiaCustomer(Config.VBR4000Connection, m.Customer_No);
if (lc.Count > 0)
{
FillForm(lc[0]);
}
}
}
else
{
MessageBox.Show("NO PAYMENT HEADER");
}
}
else
{
MessageBox.Show("Please First save the customer");
}
}
}
public static List <VBRAsiaCusModel> GetVBRAsiaCustomer(string Connection, string CustomerNo)
{
List <VBRAsiaCusModel> lm = new List <VBRAsiaCusModel>();
string sql = "";
#region SQL
sql += "SELECT [Customer_No],[Name],[Street],[Post_Code],[Telephone1]";
sql += ",[Telephone2],[Address_1],[Address_2],[E_Mail]";
sql += ",[No_Of_Shops],[Support_End_Date],[Due_Date],[Added_Date]";
sql += ",[IsPaid] FROM VBRAsia_Customers where [Customer_No]=@Customer_No";
#endregion SQL
using (SqlConnection conn = new SqlConnection(Connection))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@Customer_No";
param.Value = CustomerNo;
param.DbType = DbType.String;
param.Size = 10;
command.Parameters.Add(param);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
VBRAsiaCusModel m = new VBRAsiaCusModel();
#region Fill Model
for (int i = 0; i < reader.FieldCount; i++)
{
if (i == 0)
{
try { m.Customer_No = reader.GetString(i); }
catch { }
}
else if (i == 1)
{
try { m.Name = reader.GetString(i); }
catch { }
}
else if (i == 2)
{
try { m.Street = reader.GetString(i); }
catch { }
}
else if (i == 3)
{
try { m.Post_Code = reader.GetString(i); }
catch { }
}
else if (i == 4)
{
try { m.Telephone1 = reader.GetString(i); }
catch { }
}
else if (i == 5)
{
try { m.Telephone2 = reader.GetString(i); }
catch { }
}
else if (i == 6)
{
try { m.Address_1 = reader.GetString(i); }
catch { }
}
else if (i == 7)
{
try { m.Address_2 = reader.GetString(i); }
catch { }
}
else if (i == 8)
{
try { m.E_Mail = reader.GetString(i); }
catch { }
}
else if (i == 9)
{
try { m.No_Of_Shops = reader.GetInt32(i); }
catch { }
}
else if (i == 10)
{
try { m.Support_End_Date = reader.GetDateTime(i); }
catch { }
}
else if (i == 11)
{
try { m.Due_Date = reader.GetDateTime(i); }
catch { }
}
else if (i == 12)
{
try { m.Added_Date = reader.GetDateTime(i); }
catch { }
}
else if (i == 13)
{
try { m.IsPaid = reader.GetBoolean(i); }
catch { }
}
}
#endregion Fill Model
lm.Add(m);
}
}
}
}
return(lm);
}
public static int InsertVBRAsiaCustomer(string Connection, VBRAsiaCusModel m)
{
int affectedRows = 0;
string sql = "";
#region SQL
sql += "INSERT INTO [VBRAsia_Customers] ";
sql += "([Customer_No],[Name],[Street],[Post_Code],[Telephone1], ";
sql += "[Telephone2],[Address_1],[Address_2],[E_Mail],[No_Of_Shops] ";
sql += ",[Support_End_Date],[Due_Date],[Added_Date],[IsPaid]) ";
sql += "VALUES(@Customer_No,@Name,@Street,@Post_Code,@Telephone1,@Telephone2,@Address_1, ";
sql += "@Address_2,@E_Mail,@No_Of_Shops,@Support_End_Date,@Due_Date,@Added_Date,@IsPaid)";
#endregion SQL
using (SqlConnection conn = new SqlConnection(Connection))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
#region Params
//@Customer_No,@Name,@Street,@Post_Code,@Telephone1,@Telephone2,@Address_1,
#region Line 1
#region @Customer_No
SqlParameter param = new SqlParameter();
param.ParameterName = "@Customer_No";
param.Value = m.Customer_No;
param.DbType = DbType.String;
param.Size = 10;
command.Parameters.Add(param);
#endregion @Customer_No
#region @Name
param = new SqlParameter();
param.ParameterName = "@Name";
param.Value = m.Name;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Name
#region @Street
param = new SqlParameter();
param.ParameterName = "@Street";
param.Value = m.Street;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Street
#region @Post_Code
param = new SqlParameter();
param.ParameterName = "@Post_Code";
param.Value = m.Post_Code;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Post_Code
#region @Telephone1
param = new SqlParameter();
param.ParameterName = "@Telephone1";
param.Value = m.Telephone1;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Telephone1
#region @Telephone2
param = new SqlParameter();
param.ParameterName = "@Telephone2";
param.Value = m.Telephone2;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Telephone2
#region @Address_1
param = new SqlParameter();
param.ParameterName = "@Address_1";
param.Value = m.Address_1;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Address_1
#endregion Line 1
#region Line 2
//@Address_2,@E_Mail,@No_Of_Shops,@Support_End_Date,@Due_Date,@Added_Date,@IsPaid
#region @Address_2
param = new SqlParameter();
param.ParameterName = "@Address_2";
param.Value = m.Address_2;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Address_2
#region @E_Mail
param = new SqlParameter();
param.ParameterName = "@E_Mail";
param.Value = m.E_Mail;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @E_Mail
#region @No_Of_Shops
param = new SqlParameter();
param.ParameterName = "@No_Of_Shops";
param.Value = m.No_Of_Shops;
param.DbType = DbType.Int32;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @No_Of_Shops
#region @Support_End_Date
param = new SqlParameter();
param.ParameterName = "@Support_End_Date";
param.Value = m.Support_End_Date;
param.DbType = DbType.DateTime;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @Support_End_Date
#region @Due_Date
param = new SqlParameter();
param.ParameterName = "@Due_Date";
param.Value = m.Due_Date;
param.DbType = DbType.DateTime;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @Due_Date
#region @Added_Date
param = new SqlParameter();
param.ParameterName = "@Added_Date";
param.Value = m.Added_Date;
param.DbType = DbType.DateTime;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @Added_Date
#region @IsPaid
param = new SqlParameter();
param.ParameterName = "@IsPaid";
param.Value = m.IsPaid;
param.DbType = DbType.Boolean;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @IsPaid
#endregion Line 2
#endregion Params
affectedRows = command.ExecuteNonQuery();
}
}
return(affectedRows);
}
public static int UpdateVBRAsiaCustomer(string Connection, VBRAsiaCusModel m)
{
int affectedRows = 0;
string sql = "";
#region SQL
sql += "UPDATE VBRAsia_Customers ";
sql += "SET [Name]=@Name,[Street]=@Street,[Post_Code]=@Post_Code ";
sql += ",[Telephone1]=@Telephone1,[Telephone2]=@Telephone2,[Address_1]=@Address_1, ";
sql += "[Address_2]=@Address_2,[E_Mail]=@E_Mail,[No_Of_Shops]=@No_Of_Shops, ";
sql += "[Support_End_Date]=@Support_End_Date ,[Due_Date]=@Due_Date, ";
sql += "[Added_Date]=@Added_Date,[IsPaid]=@IsPaid where [Customer_No]=@Customer_No";
#endregion SQL
using (SqlConnection conn = new SqlConnection(Connection))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
#region Params
#region LINE1
//[Name]=@Name,[Street]=@Street,[Post_Code]=@Post_Code
#region @Name
SqlParameter param = new SqlParameter();
param = new SqlParameter();
param.ParameterName = "@Name";
param.Value = m.Name;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Name
#region @Street
param = new SqlParameter();
param.ParameterName = "@Street";
param.Value = m.Street;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Street
#region @Post_Code
param = new SqlParameter();
param.ParameterName = "@Post_Code";
param.Value = m.Post_Code;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Post_Code
#endregion LINE1
#region LINE2
//[Telephone1]=@Telephone1,[Telephone2]=@Telephone2,[Address_1]=@Address_1
#region @Telephone1
param = new SqlParameter();
param.ParameterName = "@Telephone1";
param.Value = m.Telephone1;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Telephone1
#region @Telephone2
param = new SqlParameter();
param.ParameterName = "@Telephone2";
param.Value = m.Telephone2;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Telephone2
#region @Address_1
param = new SqlParameter();
param.ParameterName = "@Address_1";
param.Value = m.Address_1;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Address_1
#endregion LINE2
#region LINE3
//[Address_2]=@Address_2,[E_Mail]=@E_Mail,[No_Of_Shops]=@No_Of_Shops,
#region @Address_2
param = new SqlParameter();
param.ParameterName = "@Address_2";
param.Value = m.Address_2;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @Address_2
#region @E_Mail
param = new SqlParameter();
param.ParameterName = "@E_Mail";
param.Value = m.E_Mail;
param.DbType = DbType.String;
param.Size = 50;
command.Parameters.Add(param);
#endregion @E_Mail
#region @No_Of_Shops
param = new SqlParameter();
param.ParameterName = "@No_Of_Shops";
param.Value = m.No_Of_Shops;
param.DbType = DbType.Int32;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @No_Of_Shops
#endregion LINE3
#region LINE4
//[Support_End_Date]=@Support_End_Date ,[Due_Date]=@Due_Date
#region @Support_End_Date
param = new SqlParameter();
param.ParameterName = "@Support_End_Date";
param.Value = m.Support_End_Date;
param.DbType = DbType.DateTime;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @Support_End_Date
#region @Due_Date
param = new SqlParameter();
param.ParameterName = "@Due_Date";
param.Value = m.Due_Date;
param.DbType = DbType.DateTime;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @Due_Date
#endregion LINE4
#region LINE5
//[Added_Date]=@Added_Date,[IsPaid]=@IsPaid where [Customer_No]=@Customer_No
#region @Added_Date
param = new SqlParameter();
param.ParameterName = "@Added_Date";
param.Value = m.Added_Date;
param.DbType = DbType.DateTime;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @Added_Date
#region @IsPaid
param = new SqlParameter();
param.ParameterName = "@IsPaid";
param.Value = m.IsPaid;
param.DbType = DbType.Boolean;
//param.Size = 50;
command.Parameters.Add(param);
#endregion @IsPaid
#region @Customer_No
param = new SqlParameter();
param.ParameterName = "@Customer_No";
param.Value = m.Customer_No;
param.DbType = DbType.String;
param.Size = 10;
command.Parameters.Add(param);
#endregion @Customer_No
#endregion LINE5
#endregion Params
affectedRows = command.ExecuteNonQuery();
}
}
return(affectedRows);
}
