void Update_SolutionsDB() { try { SolutionsDBDAL = new DAL.SolutionsDBDAL(); clsActionStatus = new clsActionStatus(); SolutionsDBDAL.ID = this.txtID.Text == CommonVariables.New_IntialValue ? 0 : int.Parse(this.txtID.Text); SolutionsDBDAL.SolutionID = int.Parse(this.txtSolutionID.Text); SolutionsDBDAL.DBType = this.cmbDBType.Text; SolutionsDBDAL.ServerName = this.txtServerNamer.Text; SolutionsDBDAL.UserName = this.txtUserName.Text; SolutionsDBDAL.DBName = this.txtDBName.Text; SolutionsDBDAL.DPassword = this.txtDPassword.Text; SolutionsDBDAL.SQLType = this.cmbSqlType.Text; SolutionsDBDAL.SPFormat = this.txtSPFormat.Text; SolutionsDBDAL.UserId = CommonClasses.Security.UserID; SolutionsDBDAL.isActive = this.cbkisActive.Checked; if (isNew_SolutionsDB == false && isNew_SolutionsDB == false) { Messages.Edit_New_error("Solutions DB"); return; } if (SolutionsDBDAL.ID > 0) { clsActionStatus = SolutionsDBDAL.Update(); } else { clsActionStatus = SolutionsDBDAL.Insert(); } if (clsActionStatus.is_Error == false) { isNew_SolutionsDB = isEdit_SolutionsDB = false; Messages.SuccessMessage(clsActionStatus.Action_SuccessStatus, "Solutions DB"); this.txtID.Text = clsActionStatus.Return_Id; this.Solutions_bindingSource.EndEdit(); if (SolutionsDBDAL.ID <= 0) { if (Messages.myAddMore("Solutions DB") == System.Windows.Forms.DialogResult.Yes) { this.txtID.Focus(); this.New_SolutionsDB(); } } } else { Messages.GeneralError(clsActionStatus.Action_FailureStatus, "Solutions DB"); } } catch (Exception ex) { CommonClasses.Messages.GeneralError(ex.Message, " Solutions DB"); } }