/// <summary>
/// Update Database Make data as Obsoluted
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void IsObsolete_CheckedChanged(Object sender, EventArgs e)
{
string message = string.Empty;
try
{
CheckBox chk = (CheckBox)sender;
GridViewRow gr = (GridViewRow)chk.Parent.Parent;
string CONCERNID = ((Literal)gr.FindControl("litCONCERNID")).Text;
ConcernBLL ConcernBLLobj = new ConcernBLL();
message = ConcernBLLobj.ObsoleteConcern(Convert.ToInt32(CONCERNID), Convert.ToString(chk.Checked));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
BindGrid(false, true);
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// to get the concern details
/// </summary>
/// <param name="lastItemSelected"></param>
private void GetConcer(bool lastItemSelected)
{
ConcernBLL objConcer = new ConcernBLL();
ConcernList ConcernList = new ConcernList();
ConcernList = objConcer.GetConcern();
PAPConcernsDropDownList.Items.Clear();
PAPConcernsDropDownList.DataSource = ConcernList;
PAPConcernsDropDownList.DataTextField = "ConcernName";
PAPConcernsDropDownList.DataValueField = "ConcernID";
PAPConcernsDropDownList.DataBind();
PAPConcernsDropDownList.Items.Insert(0, new ListItem("-- Select --", "0"));
PAPConcernsDropDownList.SelectedIndex = 0;
if (PAPConcernsDropDownList.Items.FindByText("Other") != null)
{
ListItem LastListItem = new ListItem(PAPConcernsDropDownList.Items.FindByText("Other").Text, PAPConcernsDropDownList.Items.FindByText("Other").Value);
PAPConcernsDropDownList.Items.Remove(PAPConcernsDropDownList.Items.FindByText("Other"));
PAPConcernsDropDownList.Items.Add(LastListItem);
if (lastItemSelected)
{
PAPConcernsDropDownList.Items[PAPConcernsDropDownList.Items.Count - 1].Selected = true;
}
else
{
PAPConcernsDropDownList.SelectedIndex = 0;
}
}
}
/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>
private void BindGrid(bool addRow, bool deleteRow)
{
ConcernBLL ConcernBLLobj = new ConcernBLL();
grdConcern.DataSource = ConcernBLLobj.GETALLCONCERN();
grdConcern.DataBind();
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdConcern_RowCommand(object sender, GridViewCommandEventArgs e)
{
string message = string.Empty;
if (e.CommandName == "EditRow")
{
ViewState["ConcernID"] = e.CommandArgument;
int concrnID = Convert.ToInt32(ViewState["ConcernID"]);
GetConcernDetails(concrnID);
SetUpdateMode(true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true);
}
else if (e.CommandName == "DeleteRow")
{
ConcernBLL ConcernBLLobj = new ConcernBLL();
message = ConcernBLLobj.DeleteConcern(Convert.ToInt32(e.CommandArgument));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data Deleted successfully";
}
clear();
SetUpdateMode(false);
BindGrid(false, true);
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
/// <summary>
/// get the Grid value into textBox
/// </summary>
private void GetConcernDetails(int ConcernID)
{
ConcernBLL ConcernBLLobj = new ConcernBLL();
//int ConcernID = 0;
//if (ViewState["CONCERNID"] != null)
// ConcernID = Convert.ToInt32(ViewState["CONCERNID"]);
ConcernBO ConcernObj = new ConcernBO();
ConcernObj = ConcernBLLobj.GetConcernById(ConcernID);
ConcernTextBox.Text = ConcernObj.ConcernName;
ConcernIDTextBox.Text = ConcernObj.ConcernID.ToString();
//int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID);
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
//int count = 0;
string AlertMessage = string.Empty;
string message = string.Empty;
if (MainOccupationTextBox.Text.ToString().Trim() == string.Empty)
{
//errMsgMainOccupationLabel.Text = "Enter the Concern";
}
else if (MainOccupationIDTextBox.Text.ToString().Trim() == string.Empty)
{
OccupationBLL OccupationBLLOBJ = new OccupationBLL();
try
{
string uID = Session["USER_ID"].ToString();
OccupationBO objOccupation = new OccupationBO();
objOccupation.OCCUPATIONNAME = MainOccupationTextBox.Text.ToString().Trim();
objOccupation.UserID = Convert.ToInt32(uID);
OccupationBLL OccupationBLLobj = new OccupationBLL();
message = OccupationBLLobj.Insert(objOccupation);
//if (count == -1)
//{
// msgSaveLabel.Text = "Data saved successfully"; //messageSaveLable
// BindGrid(true, true);
//}
//else
//{
// msgSaveLabel.Text = "Data not saved successfully";
//}
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
AllClear();
// ClearDetails();
BindGrid(true, true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
OccupationBLLOBJ = null;
}
}
//edit the data in the textbox exiting in the Grid
else if (MainOccupationIDTextBox.Text.ToString().Trim() != string.Empty)
{
ConcernBLL concernBLLOBJ = new ConcernBLL();
try
{
string uID = Session["USER_ID"].ToString();
OccupationBO objOccupation = new OccupationBO();
objOccupation.OCCUPATIONNAME = MainOccupationTextBox.Text.ToString().Trim();
objOccupation.OCCUPATIONID = Convert.ToInt32(MainOccupationIDTextBox.Text.ToString().Trim());
objOccupation.UserID = Convert.ToInt32(uID);
OccupationBLL OccupationBLLobj = new OccupationBLL();
message = OccupationBLLobj.EDITOccupation(objOccupation);
//if (count == -1)
//{
// msgSaveLabel.Text = "Data saved successfully"; //messageSaveLable
// BindGrid(true, true);
//}
//else
//{
// msgSaveLabel.Text = "Data not saved successfully";
//}
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
// ClearDetails();
AllClear();
BindGrid(true, true);
SetUpdateMode(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
concernBLLOBJ = null;
}
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
/// <summary>
/// save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
string message = "";
int count = 0;
if (ViewState["CROPAGEID"].ToString() == "0")
{
CropAgeBLL CropAgeBLLOBJ = new CropAgeBLL();
try
{
string uID = Session["USER_ID"].ToString();
CropAgeBO objCropAge = new CropAgeBO();
objCropAge.CROPAGE = CropAgeTextBox.Text.ToString().Trim();
objCropAge.UserID = Convert.ToInt32(uID);
CropAgeBLL CropAgeBLLLobj = new CropAgeBLL();
message = CropAgeBLLLobj.InsertCropAge(objCropAge);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
CropAgeIDTextBox.Text = "0";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
CropAgeBLLOBJ = null;
}
}
else if (Convert.ToInt32(ViewState["CROPAGEID"].ToString()) > 0)
{
ConcernBLL concernBLLOBJ = new ConcernBLL();
try
{
string uID = Session["USER_ID"].ToString();
CropAgeBO objCropAge = new CropAgeBO();
objCropAge.CROPAGE = CropAgeTextBox.Text.ToString().Trim();
objCropAge.CROPAGEID = Convert.ToInt32(ViewState["CROPAGEID"].ToString());
objCropAge.UserID = Convert.ToInt32(uID);
CropAgeBLL CropAgeBLLobj = new CropAgeBLL();
message = CropAgeBLLobj.EDITCROPAGE(objCropAge);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
concernBLLOBJ = null;
}
}
SetUpdateMode(false);
ClearData();
BindGrid(true, true);
}
/// <summary>
/// save data to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
// int count = 0;
string AlertMessage = string.Empty;
string message = string.Empty;
if (ConcernIDTextBox.Text.ToString().Trim() == string.Empty)
{
ConcernBLL concernBLLOBJ = new ConcernBLL();
try
{
string uID = Session["USER_ID"].ToString();
ConcernBO objConcern = new ConcernBO();
objConcern.ConcernName = ConcernTextBox.Text.ToString().Trim();;
objConcern.UserID = Convert.ToInt32(uID);
ConcernBLL ConcernBLLobj = new ConcernBLL();
message = ConcernBLLobj.Insert(objConcern);
AlertMessage = "alert('" + message + "');";
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
clear();
// ClearDetails();
BindGrid(true, true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
concernBLLOBJ = null;
}
}
//edit the data in the textbox exiting in the Grid
else if (ConcernIDTextBox.Text.ToString().Trim() != string.Empty)
{
ConcernBLL concernBLLOBJ = new ConcernBLL();
try
{
string uID = Session["USER_ID"].ToString();
ConcernBO objConcern = new ConcernBO();
objConcern.ConcernName = ConcernTextBox.Text.ToString().Trim();
objConcern.ConcernID = Convert.ToInt32(ConcernIDTextBox.Text.ToString().Trim());
objConcern.UserID = Convert.ToInt32(uID);
ConcernBLL ConcernBLLobj = new ConcernBLL();
message = ConcernBLLobj.EDITCONCERN(objConcern);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
// ClearDetails();
clear();
SetUpdateMode(false);
BindGrid(true, true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
concernBLLOBJ = null;
}
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
/// <summary>
/// To save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
string message = "";
int count = 0;
if (CropDiameterIDTextBox.Text.ToString().Trim() == "0" || CropDiameterIDTextBox.Text.ToString().Trim() == string.Empty)
{
CropDiameterBLL CropDiameterBLLOBJ = new CropDiameterBLL();
try
{
string uID = Session["USER_ID"].ToString();
CropDiameterBO objCropDiameter = new CropDiameterBO();
objCropDiameter.CROPDIAMETER = CropDiameterTextBox.Text.ToString().Trim();
objCropDiameter.UserID = Convert.ToInt32(uID);
CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL();
message = CropDiameterBLLobj.InsertCropDiameter(objCropDiameter);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
CropDiameterIDTextBox.Text = "0";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
CropDiameterBLLOBJ = null;
}
BindGrid();
}
//edit the data in the textbox exiting in the Grid
else if (CropDiameterIDTextBox.Text.ToString().Trim() != string.Empty)
{
ConcernBLL concernBLLOBJ = new ConcernBLL();
try
{
string uID = Session["USER_ID"].ToString();
CropDiameterBO objCropDiameter = new CropDiameterBO();
objCropDiameter.CROPDIAMETER = CropDiameterTextBox.Text.ToString().Trim();
objCropDiameter.CROPDIAMETERID = Convert.ToInt32(CropDiameterIDTextBox.Text.ToString().Trim());
objCropDiameter.UserID = Convert.ToInt32(uID);
CropDiameterBLL CropDiameterBLLobj = new CropDiameterBLL();
message = CropDiameterBLLobj.EDITCropDiameter(objCropDiameter);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
BindGrid();
SetUpdateMode(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
concernBLLOBJ = null;
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearData();
}