// Fill JobCardHardwareForm Card private void FillHardwareFormCard() { laJobID.Text = ""; JobCardHardwareModel m = new JobCardHardwareModel(); cmbUnit.Text = m.Unit; cmbCashDrawer.Text = m.CashDrawer; cmbTPrinter.Text = m.ThermalPrinter; cmbScanner.Text = m.Scanner; cbCustomerDisplay.Checked = m.CustomerDisplay; cmbLPrinter.Text = m.LaserPrinter; cbBO_Computer.Checked = m.BackOffice_Computer; cbBO_Scanner.Checked = m.BackOffice_Scanner; cbDualDisplay.Checked = m.DualDisplay; cbScaler.Checked = m.Scaler; cbCardReciver.Checked = m.CardReciver; cbCamerBoxLink.Checked = m.CameraBoxLink; cbPiccolinkSet.Checked = m.PiccolinkSet; cbKitchenPrinter.Checked = m.KitchenPrinter; cbHardDisk.Checked = m.HardDisk; cbNetworkCable.Checked = m.NetworkCable; }
// 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"); } } }
// FillModel JobCardHardwareDetails private JobCardHardwareModel JobCardHardwareFillModel() { JobCardHardwareModel m = new JobCardHardwareModel(); m.JobId = Convert.ToInt32(laJobID.Text); m.Customer_No = txtCustomer_No.Text.Trim(); m.Unit = cmbUnit.Text.Trim(); m.CashDrawer = cmbCashDrawer.Text.Trim(); m.ThermalPrinter = cmbTPrinter.Text.Trim(); m.Scanner = cmbScanner.Text.Trim(); m.CustomerDisplay = cbCustomerDisplay.Checked; m.LaserPrinter = cmbLPrinter.Text.Trim(); m.BackOffice_Computer = cbBO_Computer.Checked; m.BackOffice_Scanner = cbBO_Scanner.Checked; m.DualDisplay = cbDualDisplay.Checked; m.Scaler = cbScaler.Checked; m.CardReciver = cbCardReciver.Checked; m.CameraBoxLink = cbCamerBoxLink.Checked; m.PiccolinkSet = cbPiccolinkSet.Checked; m.KitchenPrinter = cbKitchenPrinter.Checked; m.HardDisk = cbHardDisk.Checked; m.NetworkCable = cbNetworkCable.Checked; return(m); }
public static int UpdateHardwareDetails(string Connection, JobCardHardwareModel m) { int affectedRows = 0; string sql = ""; #region SQL sql += "UPDATE VBRAsia_JobCard_HardwareDetails "; sql += "SET Customer_No =@Customer_No , Unit =@Unit, CashDrawer =@CashDrawer, ThermalPrinter = @ThermalPrinter, "; sql += "Scanner =@Scanner, CustomerDisplay =@CustomerDisplay, LaserPrinter =@LaserPrinter, BackOffice_Computer =@BackOffice_Computer, "; sql += "BackOffice_Scanner =@BackOffice_Scanner, DualDisplay =@DualDisplay, Scaler =@Scaler, CardReciver =@CardReciver, "; sql += "CameraBoxLink =@CameraBoxLink,PiccolinkSet =@PiccolinkSet, KitchenPrinter =@KitchenPrinter, HardDisk =@HardDisk, NetworkCable = @NetworkCable "; sql += "WHERE [JobID] =@JobID "; #endregion SQL using (SqlConnection conn = new SqlConnection(Connection)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { #region Parameter Declare SqlParameter param = new SqlParameter(); param.ParameterName = "@Customer_No"; param.Value = m.Customer_No; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Unit"; param.Value = m.Unit; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CashDrawer"; param.Value = m.CashDrawer; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@ThermalPrinter"; param.Value = m.ThermalPrinter; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Scanner"; param.Value = m.Scanner; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CustomerDisplay"; param.Value = m.CustomerDisplay; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@LaserPrinter"; param.Value = m.LaserPrinter; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BackOffice_Computer"; param.Value = m.BackOffice_Computer; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BackOffice_Scanner"; param.Value = m.BackOffice_Scanner; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@DualDisplay"; param.Value = m.DualDisplay; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Scaler"; param.Value = m.Scaler; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CardReciver"; param.Value = m.CardReciver; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CameraBoxLink"; param.Value = m.CameraBoxLink; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@PiccolinkSet"; param.Value = m.PiccolinkSet; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@KitchenPrinter"; param.Value = m.KitchenPrinter; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@HardDisk"; param.Value = m.HardDisk; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@NetworkCable"; param.Value = m.NetworkCable; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion Parameter Declare affectedRows = command.ExecuteNonQuery(); } } return(affectedRows); }
public static int InsertHardwareDetails(string Connection, JobCardHardwareModel m) { int affectedRows = 0; string sql = ""; #region SQL sql += "INSERT INTO [VBRAsia_JobCard_HardwareDetails] "; sql += "(Customer_No, JobId, Unit, CashDrawer, ThermalPrinter, Scanner, CustomerDisplay, LaserPrinter, BackOffice_Computer, "; sql += "BackOffice_Scanner, DualDisplay, Scaler, CardReciver, CameraBoxLink, PiccolinkSet, KitchenPrinter, HardDisk, NetworkCable) "; sql += "VALUES (@Customer_No, @JobId, @Unit, @CashDrawer, @ThermalPrinter, @Scanner, @CustomerDisplay, @LaserPrinter, @BackOffice_Computer, "; sql += "@BackOffice_Scanner, @DualDisplay, @Scaler, @CardReciver, @CameraBoxLink, @PiccolinkSet, @KitchenPrinter, @HardDisk, @NetworkCable) "; #endregion SQL using (SqlConnection conn = new SqlConnection(Connection)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { #region Parameter Declare SqlParameter param = new SqlParameter(); param.ParameterName = "@Customer_No"; param.Value = m.Customer_No; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@JobId"; param.Value = m.JobId; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Unit"; param.Value = m.Unit; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CashDrawer"; param.Value = m.CashDrawer; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@ThermalPrinter"; param.Value = m.ThermalPrinter; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Scanner"; param.Value = m.Scanner; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CustomerDisplay"; param.Value = m.CustomerDisplay; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@LaserPrinter"; param.Value = m.LaserPrinter; param.DbType = DbType.String; param.Size = 50; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BackOffice_Computer"; param.Value = m.BackOffice_Computer; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BackOffice_Scanner"; param.Value = m.BackOffice_Scanner; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@DualDisplay"; param.Value = m.DualDisplay; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Scaler"; param.Value = m.Scaler; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CardReciver"; param.Value = m.CardReciver; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CameraBoxLink"; param.Value = m.CameraBoxLink; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@PiccolinkSet"; param.Value = m.PiccolinkSet; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@KitchenPrinter"; param.Value = m.KitchenPrinter; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@HardDisk"; param.Value = m.HardDisk; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@NetworkCable"; param.Value = m.NetworkCable; param.DbType = DbType.Boolean; command.Parameters.Add(param); #endregion Parameter Declare affectedRows = command.ExecuteNonQuery(); } } return(affectedRows); }
public static List <JobCardHardwareModel> GetHardwareDetails(string Connection, string Customer_No) { List <JobCardHardwareModel> lm = new List <JobCardHardwareModel>(); string sql = ""; #region SQL sql += "SELECT ID, Customer_No, JobId, CashDrawer, ThermalPrinter, Scanner, CustomerDisplay, LaserPrinter, "; sql += "BackOffice_Computer, BackOffice_Scanner, DualDisplay, Scaler, CardReciver, CameraBoxLink, "; sql += "PiccolinkSet, KitchenPrinter, HardDisk, NetworkCable FROM VBRAsia_JobCard_HardwareDetails "; sql += "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 = Customer_No; param.DbType = DbType.String; param.Size = 20; command.Parameters.Add(param); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { JobCardHardwareModel m = new JobCardHardwareModel(); #region Fill Model for (int i = 0; i < reader.FieldCount; i++) { if (i == 0) { try { m.ID = reader.GetInt32(i); } catch { } } else if (i == 1) { try { m.Customer_No = reader.GetString(i); } catch { } } else if (i == 2) { try { m.JobId = reader.GetInt32(i); } catch { } } else if (i == 3) { try { m.Unit = reader.GetString(i); } catch { } } else if (i == 4) { try { m.CashDrawer = reader.GetString(i); } catch { } } else if (i == 5) { try { m.ThermalPrinter = reader.GetString(i); } catch { } } else if (i == 6) { try { m.Scanner = reader.GetString(i); } catch { } } else if (i == 7) { try { m.CustomerDisplay = reader.GetBoolean(i); } catch { } } else if (i == 8) { try { m.LaserPrinter = reader.GetString(i); } catch { } } else if (i == 9) { try { m.BackOffice_Computer = reader.GetBoolean(i); } catch { } } else if (i == 10) { try { m.BackOffice_Scanner = reader.GetBoolean(i); } catch { } } else if (i == 11) { try { m.DualDisplay = reader.GetBoolean(i); } catch { } } else if (i == 12) { try { m.Scaler = reader.GetBoolean(i); } catch { } } else if (i == 13) { try { m.CardReciver = reader.GetBoolean(i); } catch { } } else if (i == 14) { try { m.CameraBoxLink = reader.GetBoolean(i); } catch { } } else if (i == 15) { try { m.PiccolinkSet = reader.GetBoolean(i); } catch { } } else if (i == 16) { try { m.KitchenPrinter = reader.GetBoolean(i); } catch { } } else if (i == 17) { try { m.HardDisk = reader.GetBoolean(i); } catch { } } else if (i == 18) { try { m.NetworkCable = reader.GetBoolean(i); } catch { } } } #endregion Fill Model lm.Add(m); } } } } return(lm); }