protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
clsPrograms objPrograms = new clsPrograms();
objPrograms.strName = txtName.Text;
objPrograms.strVersion = txtVersion.Text;
objPrograms.strPlatform = ddlPlatform.Text;
objPrograms.strCatName = ddlCategory.Text;
objPrograms.strAddress = txtAddress.Text;
objPrograms.strCrackType = ddlCrackType.Text;
objPrograms.strSerialNo = txtSerialNumber.Text;
clsProgramsManager.Insert(objPrograms);
dgridShowData.DataSource = clsProgramsManager.Select();
dgridShowData.DataBind();
txtName.Text = "";
txtVersion.Text = "";
ddlPlatform.SelectedIndex = 0;
ddlCategory.SelectedIndex = 0;
txtAddress.Text = "";
ddlCrackType.SelectedIndex = 0;
txtSerialNumber.Text = "";
lblProgramsCounter.Text = clsProgramsManager.Counter();
lblMessage.Text = "Program successfully registered in database.";
}
catch (Exception ex)
{
lblMessage.Text = ex.Message.ToString();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
clsPrograms objPrograms = new clsPrograms();
objPrograms.strID = lblID.Text;
clsProgramsManager.Delete(objPrograms);
dgridShowData.DataSource = clsProgramsManager.Select();
dgridShowData.DataBind();
lblID.Text = "";
txtName.Text = "";
txtVersion.Text = "";
ddlPlatform.SelectedIndex = 0;
ddlCategory.SelectedIndex = 0;
txtAddress.Text = "";
ddlCrackType.SelectedIndex = 0;
txtSerialNumber.Text = "";
lblProgramsCounter.Text = clsProgramsManager.Counter();
lblMessage.Text = "Program successfully deleted from database.";
}
catch (Exception ex)
{
lblMessage.Text = ex.Message.ToString();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
objPrograms = new clsPrograms();
objPrograms.ProgramCode = txtProgrammCode.Text.Trim();
objPrograms.Title = txtTile.Text;
objPrograms.Description = txtDescription.Text;
objPrograms.TargetPopulation = txtTarget.Text;
objPrograms.GeographicalLocation = txtGeoLocation.Text;
objPrograms.AgeGroup = txtAgeGroup.Text;
objPrograms.Objective = txtObjective.Text;
objPrograms.Approach = txtApproach.Text;
objPrograms.Achievement = txtAchievements.Text;
objPrograms.Assessment = txtAssesment.Text;
int i = objPrograms.InsertProgrammDetails();
if (i > 0)
{
Page.RegisterClientScriptBlock("Child", "<script>alert('Programm Inserted Successfully')</script>");
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Error Try Again!";
}
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
public static DataTable Search(clsPrograms objPrograms)
{
String strSQL = "EXEC dbo.xp_Search";
if ((objPrograms.strName == null) && (objPrograms.strPlatform == null))
{
strSQL = "EXEC dbo.xp_Search";
}
else if ((objPrograms.strName == null) && (objPrograms.strPlatform != null))
{
strSQL = "EXEC dbo.xp_Search NULL, '%" + objPrograms.strPlatform + "%'";
}
else if ((objPrograms.strName != null) && (objPrograms.strPlatform == null))
{
strSQL = "EXEC dbo.xp_Search '%" + objPrograms.strName + "%', NULL";
}
else if ((objPrograms.strName != null) && (objPrograms.strPlatform != null))
{
strSQL = "EXEC dbo.xp_Search '%" + objPrograms.strName + "%', '%" + objPrograms.strPlatform + "%'";
}
clsDBMS objDBMS = new clsDBMS();
return(objDBMS.ExecuteSelectSQL(strSQL));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["ProgramCode"] == null)
{
Response.Redirect("~/frmPrograms.aspx");
}
objPrograms = new clsPrograms();
DataSet ds = objPrograms.GetProgrammDetailsById(Request.QueryString["ProgramCode"].ToString());
if (ds.Tables[0].Rows.Count > 0)
{
lblTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblTitle1.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblTargetPopulation.Text = ds.Tables[0].Rows[0]["TargetPopulation"].ToString();
lblDescription.Text = ds.Tables[0].Rows[0]["Description"].ToString();
lblGeo.Text = ds.Tables[0].Rows[0]["GeographincalLocation"].ToString();
lblAgeGroup.Text = ds.Tables[0].Rows[0]["AgeGroup"].ToString();
lblObjective.Text = ds.Tables[0].Rows[0]["Objective"].ToString();
lblAssesment.Text = ds.Tables[0].Rows[0]["Assessment"].ToString();
lblStrategy.Text = ds.Tables[0].Rows[0]["Approach"].ToString();
lblAchievements.Text = ds.Tables[0].Rows[0]["Achievements"].ToString();
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Int64 intMinID, intMaxID;
clsPrograms objPrograms = new clsPrograms();
clsDBMS objDBMS = new clsDBMS();
intMinID = Convert.ToInt64(txtMinID.Text);
intMaxID = Convert.ToInt64(txtMaxID.Text);
objPrograms.strAddress = txtAddress.Text;
if (intMinID < intMaxID)
{
clsProgramsManager.PackAddress(objPrograms, txtMinID.Text, txtMaxID.Text);
dgridShowData.DataSource = clsProgramsManager.Select();
dgridShowData.DataBind();
txtMinID.Text = "";
txtMaxID.Text = "";
txtAddress.Text = "";
lblMessage.Text = "Programs address successfully updated in database.";
}
else
{
lblMessage.Text = "Min ID must be smaller than of Max ID.";
}
}
public static void PackAddress(clsPrograms objPrograms, String strMinID, String strMaxID)
{
String strSQL = "EXEC dbo.xp_PackAddress " + strMinID + ", " + strMaxID + ", '" + objPrograms.strAddress + "'";
clsDBMS objDBMS = new clsDBMS();
objDBMS.ExecuteSQL(strSQL);
}
public static void Delete(clsPrograms objPrograms)
{
String strSQL = "EXEC dbo.xp_Delete " + objPrograms.strID + "";
clsDBMS objDBMS = new clsDBMS();
objDBMS.ExecuteSQL(strSQL);
}
public static void Update(clsPrograms objPrograms)
{
String strSQL = "EXEC dbo.xp_Update " + objPrograms.strID + ", '" + objPrograms.strName + "', '" + objPrograms.strVersion + "', '" + objPrograms.strCatName + "', '" + objPrograms.strAddress + "', '" + objPrograms.strCrackType + "', '" + objPrograms.strSerialNo + "', '" + objPrograms.strPlatform + "'";
clsDBMS objDBMS = new clsDBMS();
objDBMS.ExecuteSQL(strSQL);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
clsPrograms objPrograms = new clsPrograms();
DataSet ds = objPrograms.GetProgrammWithDescription();
if (ds.Tables[0].Rows.Count > 0)
{
GRVPrograms.DataSource = ds.Tables[0];
GRVPrograms.DataBind();
ViewState["index"] = null;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
clsPrograms objProgram = new clsPrograms();
DataSet ds = objProgram.GetProgrammNames();
if (ds.Tables[0].Rows.Count > 0)
{
RBListPrograms.DataTextField = "Title";
RBListPrograms.DataValueField = "ProgramCode";
RBListPrograms.DataSource = ds.Tables[0];
RBListPrograms.DataBind();
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
clsPrograms objPrograms = new clsPrograms();
objPrograms.strName = txtName.Text;
dgridShowData.DataSource = clsProgramsManager.Search(objPrograms);
dgridShowData.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message.ToString();
}
}
protected void dgridShowData_SelectedIndexChanged(object sender, EventArgs e)
{
clsPrograms objPrograms = new clsPrograms();
objPrograms.strID = dgridShowData.SelectedRow.Cells[1].Text;
objPrograms.strName = dgridShowData.SelectedRow.Cells[2].Text;
objPrograms.strVersion = dgridShowData.SelectedRow.Cells[3].Text;
objPrograms.strPlatform = dgridShowData.SelectedRow.Cells[4].Text;
objPrograms.strCatName = dgridShowData.SelectedRow.Cells[5].Text;
objPrograms.strAddress = dgridShowData.SelectedRow.Cells[6].Text;
objPrograms.strCrackType = dgridShowData.SelectedRow.Cells[7].Text;
objPrograms.strSerialNo = dgridShowData.SelectedRow.Cells[8].Text;
if (objPrograms.strName == " ")
{
objPrograms.strName = "";
}
if (objPrograms.strVersion == " ")
{
objPrograms.strVersion = "";
}
if (objPrograms.strAddress == " ")
{
objPrograms.strAddress = "";
}
if (objPrograms.strSerialNo == " ")
{
objPrograms.strSerialNo = "";
}
lblID.Text = objPrograms.strID;
txtName.Text = objPrograms.strName;
txtVersion.Text = objPrograms.strVersion;
ddlPlatform.Text = objPrograms.strPlatform;
ddlCategory.Text = objPrograms.strCatName;
txtAddress.Text = objPrograms.strAddress;
ddlCrackType.Text = objPrograms.strCrackType;
txtSerialNumber.Text = objPrograms.strSerialNo;
lblProgramsCounter.Text = clsProgramsManager.Counter();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
clsPrograms objPrograms = new clsPrograms();
if ((chkName.Checked == false) && (chkPlatform.Checked == false))
{
dgridShowData.DataSource = clsProgramsManager.Select();
dgridShowData.DataBind();
}
else if ((chkName.Checked == true) && (chkPlatform.Checked == false))
{
objPrograms.strName = txtName.Text;
//objPrograms.strPlatform = ddlPlatform.Text;
dgridShowData.DataSource = clsProgramsManager.Search(objPrograms);
dgridShowData.DataBind();
}
else if ((chkName.Checked == false) && (chkPlatform.Checked == true))
{
objPrograms.strPlatform = ddlPlatform.Text;
dgridShowData.DataSource = clsProgramsManager.Search(objPrograms);
dgridShowData.DataBind();
}
else if ((chkName.Checked == true) && (chkPlatform.Checked == true))
{
objPrograms.strName = txtName.Text;
objPrograms.strPlatform = ddlPlatform.Text;
dgridShowData.DataSource = clsProgramsManager.Search(objPrograms);
dgridShowData.DataBind();
}
//dgridShowData.DataSource = clsProgramsManager.Search(objPrograms);
//dgridShowData.DataBind();
}
