public frmMaintainClient(string client, string x) { ID = x; ClientID = Convert.ToInt32(client); InitializeComponent(); SPEntities db = new SPEntities(); Credit_Approval NewCA = new Credit_Approval(); Credit_Return NewReturn = new Credit_Return(); Province NewProv = new Province(); Client newClient = new Client(); byte[] FileData; string FName; }
private void button3_Click(object sender, EventArgs e) { // var q = db.Clients.Where(x => x.Client_Name == txtName.Text).ToList(); Client NewCllient = new Client(); Credit_Approval NewCA = new Credit_Approval(); Credit_Approval Credit_Approval_Form = new Credit_Approval(); City newCity = new City(); Credit_Status crStatus = new Credit_Status(); Client_Account_Status cAS = new Client_Account_Status(); Province NewProv = new Province(); if (txtName.Text == "" || txtVatRegNum.Text == "" || txtTelephone.Text == "" || txtFaxNumber.Text == "" || txtEmailAdd.Text == "" || txtPhysicalAdd.Text == "") { MessageBox.Show("Please enter all fields!"); } else if (db.Load_Client().Where(x => x.VAT_Registration_No_ == txtVatRegNum.Text).ToList() == null) { try { // NewCA.Credit_Approval_Form = Convert.ToString(txtFilePath.Text); // txtFilePath.Text = Convert.ToBase64String(NewCA.Credit_Approval_Form); // NewCA.Credit_Approval_Form = Encoding.ASCII.GetBytes(txtFilePath.Text); NewCA.Credit_Approval_Amount = Convert.ToInt32(txtCreditAmount.Text); NewCA.Date_Of_Commencement = txtDateTimeDateOfCommencement.Value.Date; db.Credit_Approval.Add(NewCA); NewCllient.Client_Name = txtName.Text; NewCllient.Client_VAT_Reg_Number = txtVatRegNum.Text; NewCllient.Client_Telephone = "+27" + txtTelephone.Text; NewCllient.Client_Fax_Number = txtFaxNumber.Text; NewCllient.Client_Email_Address = txtEmailAdd.Text; NewCllient.Physical_Address = txtPhysicalAdd.Text; NewCllient.Province_Id = Convert.ToInt32(cbxProvince.SelectedValue.ToString()); NewCllient.City_Id = Convert.ToInt32(cbxCity.SelectedValue); NewCllient.Account_Status_ID = Convert.ToInt32(cbxAccountStatus.SelectedValue); NewCllient.Credit_Approval_ID = NewCA.Credit_Approval_ID; db.Clients.Add(NewCllient); db.SaveChanges(); MessageBox.Show("Client Has been Added succesfully"); //Audit Log int Client_Id = NewCllient.Client_ID; string client_Value = Convert.ToString(NewCllient); Audit_Log Current_Audit3 = new Audit_Log(); Current_Audit3.Table_Name = "Client"; // Current_Audit3.Users_Id = Globals.Users_Id; Current_Audit3.Date_Time = DateTime.Now; db.Audit_Log.Add(Current_Audit3); db.SaveChanges(); int Log_ID3 = Current_Audit3.Audit_Log_Id; Audit_Create_Delete Current_Create3 = new Audit_Create_Delete(); Current_Create3.Audit_Log_Id = Log_ID3; Current_Create3.Created = true; Current_Create3.PK_Row_Effected = Client_Id; Current_Create3.Value = client_Value; db.Audit_Create_Delete.Add(Current_Create3); db.SaveChanges(); this.Close(); this.Hide(); //MessageBox.Show("Are you sure you want to add this client ?", "confirmation", MessageBoxButtons.YesNo); //MessageBox.Show("Client details have been added successfully"); //MessageBox.Show("Client already exists on the system"); //MessageBox.Show("Please fill in all required fields"); //MessageBox.Show("Please select a client"); } catch (Exception) { } } else { MessageBox.Show("The Client with the VAT Registration Number: " + txtVatRegNum.Text + " already exists in the database"); } }
private void frmMaintainClient_Load(object sender, EventArgs e) { toolTip1.SetToolTip(this.txtName, "Enter Client Name "); toolTip1.SetToolTip(this.txtVatRegNum, "Enter 10 digit Vat Registration number"); toolTip1.SetToolTip(this.txtTelephone, "Enter 10 digit telephone number"); toolTip1.SetToolTip(this.txtFaxNumber, "Enter 10 digit fax number number"); toolTip1.SetToolTip(this.txtEmailAdd, "Enter a valid email containing @"); toolTip1.SetToolTip(this.txtPhysicalAdd, "Enter address"); toolTip1.SetToolTip(this.cbxProvince, "Select South African Province"); toolTip1.SetToolTip(this.cbxCity, "Select South African City"); toolTip1.SetToolTip(this.txtCreditAmount, "Enter credit amount"); toolTip1.SetToolTip(this.cbxCreditStatus, "Select valid credit status"); toolTip1.SetToolTip(this.txtDateTimeDateOfCommencement, "Select date"); toolTip1.SetToolTip(this.cbxCreditStatus, "Select valid credit status"); toolTip1.SetToolTip(this.btnBrowse, "Browse to upload credit approval"); toolTip1.SetToolTip(this.btnDeleteClient, "Click to remove client"); toolTip1.SetToolTip(this.btnUpdateClient, "Click to edit client"); toolTip1.SetToolTip(this.btnDownload, "Click to obtain credit approval"); Credit_Approval NewCA = new Credit_Approval(); try { NewCA = db.Credit_Approval.Find(Convert.ToInt32(ClientID)); int Approvalid; Approvalid = Convert.ToInt32(NewCA.Credit_Approval_ID); Credit_Approval ret = db.Credit_Approval.Find(Approvalid); txtFilePath.Text = Convert.ToString(ret.Credit_Approval_Form); var query = db.Clients.Where(co => co.Client_ID == ClientID).FirstOrDefault(); var query1 = db.Provinces.Where(co => co.Province_Id == query.Province_Id).FirstOrDefault(); var query2 = db.Cities.Where(co => co.City_Id == query.City_Id).FirstOrDefault(); var query3 = db.Credit_Approval.Where(co => co.Credit_Approval_ID == query.Credit_Approval_ID).FirstOrDefault(); var query4 = db.Credit_Status.Where(co => co.Credit_Status_ID == query3.Credit_Status_ID).FirstOrDefault(); var query5 = db.Client_Account_Status.Where(co => co.Account_Status_ID == query.Account_Status_ID).FirstOrDefault(); //var qu = db.Provinces.Select(x => x.Province_Name).ToList(); //txtProvince.DataSource = qu; //txtProvince.DropDownStyle = ComboBoxStyle.DropDownList; //var qu1 = db.Cities.Select(x => x.City_Name).ToList(); //txtCity.DataSource = qu1; //txtCity.DropDownStyle = ComboBoxStyle.DropDownList; //var qu2 = db.Credit_Status.Select(x => x.Credit_Status_Description).ToList(); //txtCreditSta.DataSource = qu2; //txtCreditSta.DropDownStyle = ComboBoxStyle.DropDownList; //var qu3 = db.Client_Account_Status.Select(x => x.Account_Status_Description).ToList(); //txtAccountStatus.DataSource = qu3; //txtAccountStatus.DropDownStyle = ComboBoxStyle.DropDownList; txtName.Text = query.Client_Name; txtVatRegNum.Text = query.Client_VAT_Reg_Number; txtTelephone.Text = query.Client_Telephone; txtFaxNumber.Text = query.Client_Fax_Number; txtEmailAdd.Text = query.Client_Email_Address; txtPhysicalAdd.Text = query.Physical_Address; cbxProvince.Text = query1.Province_Name; cbxCity.Text = query2.City_Name; if (query3.Credit_Status_ID == null) { cbxCreditStatus.SelectedIndex = -1; } else { cbxCreditStatus.Text = query4.Credit_Status_Description; } if (query3.Credit_Approval_Form == null) { txtFilePath.Text = ""; btnDownload.Visible = false; } else { txtFilePath.Text = Convert.ToBase64String(query3.Credit_Approval_Form); btnDownload.Visible = true; } comboBox5.Text = query5.Account_Status_Description; txtCreditAmount.Text = Convert.ToString(query3.Credit_Approval_Amount); txtDateTimeDateOfCommencement.MinDate = Convert.ToDateTime(query3.Date_Of_Commencement); comboBox5.Text = Convert.ToString(query.Client_Account_Status); txtFilePath.Text = Convert.ToString(query3.Credit_Approval_Form); // NewCA = db.Credit_Approval.Find(Convert.ToInt32(CAid)); int CreditAppid; CreditAppid = Convert.ToInt32(NewCA.Credit_Approval_ID); //if (NewCA.Credit_Approval_Form == null) //{ // btnDownload.Visible = false; //} using (SPEntities db = new SPEntities()) { provinceBindingSource.DataSource = db.Provinces.ToList(); cityBindingSource.DataSource = db.Cities.ToList(); clientAccountStatusBindingSource.DataSource = db.Client_Account_Status.ToList(); creditStatusBindingSource.DataSource = db.Credit_Status.ToList(); } } catch { } }
private void button2_Click(object sender, EventArgs e) { correct = true; if (txtName.Text == "" || txtVatRegNum.Text == "" || txtTelephone.Text == "" || txtFaxNumber.Text == "" || txtEmailAdd.Text == "" || txtPhysicalAdd.Text == "") { MessageBox.Show("Please enter all fields!"); correct = false; } DialogResult dialogResult = MessageBox.Show("Would you like to update the client Information ?", "Update Template", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { if (correct == true) { try { if (correct == true) { var query = db.Clients.Where(co => co.Client_ID == ClientID).FirstOrDefault(); var query1 = db.Provinces.Where(co => co.Province_Id == query.Province_Id).FirstOrDefault(); var query2 = db.Cities.Where(co => co.City_Id == query.City_Id).FirstOrDefault(); var query3 = db.Credit_Approval.Where(co => co.Credit_Approval_ID == query.Credit_Approval_ID).FirstOrDefault(); var query4 = db.Credit_Status.Where(co => co.Credit_Status_ID == query3.Credit_Approval_ID).FirstOrDefault(); var query5 = db.Client_Account_Status.Where(co => co.Account_Status_ID == query3.Credit_Approval_ID).FirstOrDefault(); Client NewCllient = new Client(); Credit_Approval NewCA = new Credit_Approval(); City newCity = new City(); Credit_Status crStatus = new Credit_Status(); Client_Account_Status cAS = new Client_Account_Status(); Province NewProv = new Province(); NewCllient = db.Clients.Where(co => co.Client_ID == ClientID).FirstOrDefault(); NewCA = db.Credit_Approval.Where(co => co.Credit_Approval_ID == query3.Credit_Approval_ID).FirstOrDefault(); newCity = db.Cities.Where(co => co.City_Id == query.City_Id).FirstOrDefault(); crStatus = db.Credit_Status.Where(co => co.Credit_Status_ID == query.Credit_Approval_ID).FirstOrDefault(); cAS = db.Client_Account_Status.Where(co => co.Account_Status_ID == query.Credit_Approval_ID).FirstOrDefault(); query.Client_Name = txtName.Text; query.Client_VAT_Reg_Number = txtVatRegNum.Text; query.Client_Telephone = "+27" + txtTelephone.Text; query.Client_Fax_Number = txtFaxNumber.Text; query.Physical_Address = txtPhysicalAdd.Text; query.Client_Email_Address = txtEmailAdd.Text; query1.Province_Name = cbxProvince.Text; query2.City_Name = cbxCity.Text; query3.Credit_Approval_Amount = Convert.ToDecimal(txtCreditAmount.Text); if (query3.Credit_Status_ID == null) { cbxCreditStatus.SelectedIndex = -1; } else { query4.Credit_Status_Description = cbxCreditStatus.Text; } NewCA.Credit_Approval_ID = crStatus.Credit_Status_ID; query5.Account_Status_Description = comboBox5.Text; query3.Credit_Approval_Form = FileData; //query3.Credit_Approval_Form = Encoding.ASCII.GetBytes(txtFilePath.Text); db.SaveChanges(); MessageBox.Show("Client Has been updated succesfully"); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error has occured, and template was not updated successfully" + ex); } } } }