void ViewAll_SolutionsDB()
{
try
{
if (this.cmbSolutions.DataSource == null)
return;
this.cmbSolutionsDB.DataSource = null;
this.cmbSolutionsDB.Items.Clear();
DataTable myDataTable_SolutionsDB = new DataTable();// = new JobStatusHeadDAL().getList(1000, 1, "Id", "asc");
myDataTable_SolutionsDB = new SolutionsDBDAL().getList_Search(1000, 1, " SolutionID =" + this.cmbSolutions.SelectedValue.ToString(), "DBType");
this.SolutionsDB_bindingSource.DataSource = myDataTable_SolutionsDB;
this.cmbSolutionsDB.DataSource = this.SolutionsDB_bindingSource;
if (this.SolutionsDB_bindingSource != null && this.SolutionsDB_bindingSource.Count > 0)
{
this.cmbSolutionsDB.DisplayMember = "DBInfo";
this.cmbSolutionsDB.ValueMember = "ID";
}
this.cmbSolutionsDB.Refresh();
this.cmbSolutionsDB.Update();
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions DB");
}
}
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");
}
}
void ViewAll_SolutionsDB(Boolean isSearch = false, string SearchText = "")
{
try
{
DataTable myDataTable_SolutionsDB = new DataTable();// = new JobStatusHeadDAL().getList(1000, 1, "Id", "asc");
if (isSearch == true)
{
myDataTable_SolutionsDB = new SolutionsDBDAL().getList_Search(1000, 1, " SolutionID=" + this.txtSolutionID.Text + " and (ServerName like '" + SearchText + "%' or DBType like '" + SearchText + "%')", "ID", "asc");
}
else
{
myDataTable_SolutionsDB = new SolutionsDBDAL().getList_Search(1000, 1, " SolutionID=" + this.txtSolutionID.Text, "DBType");
}
this.SolutionsDB_bindingSource.DataSource = myDataTable_SolutionsDB;
this.bnMain.BindingSource = this.SolutionsDB_bindingSource;
if (this.isMapped_SolutionsDB == false)
{
this.Binding_SolutionsDB();
this.isMapped_SolutionsDB = true;
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions DB");
}
}
void Delete_SolutionsDB()
{
try
{
if (Messages.myDeleteMsgBox("Solutions DB", this.txtServerNamer.Text) == System.Windows.Forms.DialogResult.Yes)
{
SolutionsDBDAL = new DAL.SolutionsDBDAL();
clsActionStatus = new clsActionStatus();
SolutionsDBDAL.ID = int.Parse(this.txtID.Text);
clsActionStatus = SolutionsDBDAL.Delete();
if (clsActionStatus.is_Error == false)
{
isNew_SolutionsDB = false;
isEdit_SolutionsDB = false;
Messages.DeletionMessage(clsActionStatus.Action_SuccessStatus, "Solutions DB");
this.SolutionsDB_bindingSource.RemoveCurrent();
}
else
{
Messages.DeletionMessage(clsActionStatus.Action_FailureStatus, "Solutions DB");
}
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " Solutions DB");
}
}
