protected void RBtnCheckConstr_Click(object sender, EventArgs e)
{
bool ConnectionResult = false;
string constr = string.Empty;
constr = Convert.ToString(RtxtDatabaseConnection.Text);
ConnectionResult = DataAccessManager.CheckConnectionstring(constr);
if (ConnectionResult == false)
{
RLChkconstr.ForeColor = System.Drawing.Color.Red;
RLChkconstr.Text = "TEST NOT COMPLETED!";
}
else
{
RLChkconstr.ForeColor = System.Drawing.Color.Green;
RLChkconstr.Text = "TEST COMPLETED SUCCESSFULLY!";
}
}
protected void RPbtnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
bool ConnectionResult = false;
string constr = string.Empty;
constr = Convert.ToString(RtxtDatabaseConnection.Text);
ConnectionResult = DataAccessManager.CheckConnectionstring(constr);
LRRlblCreateCampusResult.Visible = true;
try
{
string CampusCode = string.Empty, CampusName = string.Empty, DatabaseConnection = string.Empty;
CampusCode = RtxtCampusCode.Text;
CampusName = RtxtCampusName.Text;
DatabaseConnection = RtxtDatabaseConnection.Text;
string campusstatus = string.Empty;
if (RbtnCamousStatus.Checked == true)
{
campusstatus = "1";
}
else
{
campusstatus = "0";
}
if (RPbtnSave.Text == "Save")
{
Boolean result = DataAccessManager.InsertCampusMaster(CampusCode, CampusName, DatabaseConnection, string.Empty, campusstatus);
if (result == true)
{
RlblCreateCampusResult.ForeColor = System.Drawing.Color.Green;
RlblCreateCampusResult.Text = "Campus added successfully!";
Reset();
if (ConnectionResult == false)
{
RLChkconstr.ForeColor = System.Drawing.Color.Red;
RLChkconstr.Text = "Invalid connection string!";
}
}
else
{
RlblCreateCampusResult.ForeColor = System.Drawing.Color.Red;
RlblCreateCampusResult.Text = "Operation Failed,Please try again!";
if (ConnectionResult == false)
{
RLChkconstr.ForeColor = System.Drawing.Color.Red;
RLChkconstr.Text = "Invalid connection string!";
}
}
}
else if (RPbtnSave.Text == "Update")
{
Boolean Result = false;
string CampusID = string.Empty;
CampusID = Convert.ToString(ViewState["lbCampusID"]);
Result = DataAccessManager.UpdateCampusMaster(CampusID, CampusCode, CampusName, DatabaseConnection, string.Empty, campusstatus);
if (Result == true)
{
RlblCreateCampusResult.ForeColor = System.Drawing.Color.Green;
RlblCreateCampusResult.Text = "Campus update successfully!";
RPbtnSave.Text = "Save";
Reset();
if (ConnectionResult == false)
{
RLChkconstr.ForeColor = System.Drawing.Color.Red;
RLChkconstr.Text = "Invalid connection string!";
}
}
else
{
RlblCreateCampusResult.ForeColor = System.Drawing.Color.Red;
RlblCreateCampusResult.Text = "Operation Failed,Try Again!";
if (ConnectionResult == false)
{
RLChkconstr.ForeColor = System.Drawing.Color.Red;
RLChkconstr.Text = "Invalid connection string!";
}
}
}
}
catch (Exception ex)
{
RlblCreateCampusResult.ForeColor = System.Drawing.Color.Red;
RlblCreateCampusResult.Text = "Error:" + ex.ToString();
}
}
}