private bool RestoreTagNumber() { int id = sol_Agency.AgencyID; if (id < 1) { return(false); } if (sol_AutoNumber_Sp == null) { sol_AutoNumber_Sp = new Sol_AutoNumber_Sp(Properties.Settings.Default.WsirDbConnectionString); } Sol_AutoNumber sol_AutoNumber = sol_AutoNumber_Sp.Select(id, 1); int tagNumber = 0; int.TryParse(sol_Stage.TagNumber, out tagNumber); if (sol_AutoNumber.TagNumber == tagNumber) { sol_AutoNumber.TagNumber--; sol_AutoNumber_Sp.Update(sol_AutoNumber); } return(true); }
/// <summary> /// Creates a new instance of the Sol_AutoNumbers class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_AutoNumber MakeSol_AutoNumber(SqlDataReader dataReader) { Sol_AutoNumber sol_AutoNumber = new Sol_AutoNumber(); sol_AutoNumber.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0); sol_AutoNumber.FolioID = SqlClientUtility.GetInt32(dataReader, "FolioID", 0); sol_AutoNumber.TagNumber = SqlClientUtility.GetInt32(dataReader, "TagNumber", 0); sol_AutoNumber.RBillNumber = SqlClientUtility.GetInt32(dataReader, "RBillNumber", 0); return(sol_AutoNumber); }
/// <summary> /// Updates a record in the Sol_AutoNumbers table. /// </summary> public virtual void Update(Sol_AutoNumber sol_AutoNumber) { ValidationUtility.ValidateArgument("sol_AutoNumber", sol_AutoNumber); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@AgencyID", sol_AutoNumber.AgencyID), new SqlParameter("@FolioID", sol_AutoNumber.FolioID), new SqlParameter("@TagNumber", sol_AutoNumber.TagNumber), new SqlParameter("@RBillNumber", sol_AutoNumber.RBillNumber) }; SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_AutoNumbers_Update", parameters); }
/// <summary> /// Selects all records from the Sol_AutoNumbers table. /// </summary> public virtual List <Sol_AutoNumber> SelectAll() { using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_AutoNumbers_SelectAll")) { List <Sol_AutoNumber> sol_AutoNumberList = new List <Sol_AutoNumber>(); while (dataReader.Read()) { Sol_AutoNumber sol_AutoNumber = MakeSol_AutoNumber(dataReader); sol_AutoNumberList.Add(sol_AutoNumber); } return(sol_AutoNumberList); } }
private void ReadAutoGeneratedNumbers() { intValue = 0; int.TryParse(agencyIDTextBox.Text, out intValue); sol_AutoNumber_Sp = new Sol_AutoNumber_Sp(Properties.Settings.Default.WsirDbConnectionString); sol_AutoNumber = sol_AutoNumber_Sp.Select(intValue, 1); if (sol_AutoNumber == null) { sol_AutoNumber = new Sol_AutoNumber(); sol_AutoNumber.AgencyID = intValue; sol_AutoNumber.FolioID = 1; sol_AutoNumber.TagNumber = 0; sol_AutoNumber.RBillNumber = 0; sol_AutoNumber_Sp.Insert(sol_AutoNumber); } //checkBoxAutoTagNumber.Checked = Main.Sol_ControlInfo.AutoGenerateTagNumber; textBoxTagNumber.Text = sol_AutoNumber.TagNumber.ToString(); //checkBoxAutoRBillNumber.Checked = Main.Sol_ControlInfo.AutoGenerateRBillNumber; textBoxRBillNumber.Text = sol_AutoNumber.RBillNumber.ToString(); }
private void OK_Click(object sender, EventArgs e) { if (b_Add) { if (!Main.CheckUserPermission(Properties.Settings.Default.WsirConnectionString, Properties.Settings.Default.UsuarioNombre, "SolAddCatalogues", true)) { return; } } else { if (!Main.CheckUserPermission(Properties.Settings.Default.WsirConnectionString, Properties.Settings.Default.UsuarioNombre, "SolEditCatalogues", true)) { return; } } //bool flag = panelDetails.Visible; /*if (flag) * { * if (!ValidateForm()) * return; * * cambiarVista(); * }*/ ////hay cambios? //if (dataSetProducts.HasChanges()) //{ this.Validate(); this.sol_AgenciesBindingSource.EndEdit(); this.tableAdapterManager.UpdateAll(this.dataSetAgencies); try { //if (Convert.ToInt32(productIDTextBox.Text) < 0) if (b_Add) { b_Add = false; this.sol_AgenciesTableAdapter.Fill(this.dataSetAgencies.sol_Agencies); this.sol_AgenciesBindingSource.MoveLast(); } else { intValue = 0; int.TryParse(agencyIDTextBox.Text, out intValue); if (sol_AutoNumber_Sp == null) { sol_AutoNumber_Sp = new Sol_AutoNumber_Sp(Properties.Settings.Default.WsirDbConnectionString); } if (sol_AutoNumber == null) { sol_AutoNumber = new Sol_AutoNumber(); sol_AutoNumber.AgencyID = intValue; sol_AutoNumber.FolioID = 1; sol_AutoNumber.TagNumber = 0; sol_AutoNumber.RBillNumber = 0; sol_AutoNumber_Sp.Insert(sol_AutoNumber); } intValue = 0; int.TryParse(textBoxTagNumber.Text, out intValue); sol_AutoNumber.TagNumber = intValue; intValue = 0; int.TryParse(textBoxRBillNumber.Text, out intValue); sol_AutoNumber.RBillNumber = intValue; sol_AutoNumber_Sp.Update(sol_AutoNumber); //Main.Sol_ControlInfo.AutoGenerateTagNumber = checkBoxAutoTagNumber.Checked; //Main.Sol_ControlInfo.AutoGenerateRBillNumber = checkBoxAutoRBillNumber.Checked; } } catch { // } //} //if (!flag) Close(); }