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");
}
}
