/// <summary>
/// to fetch details and assign to textbox
/// </summary>
private void Getdatarow()
{
GraveBLL gravesaveBLLobj = new GraveBLL();
int Pap_graveid = 0;
if (ViewState["PAP_GRAVEID"] != null)
{
Pap_graveid = Convert.ToInt32(ViewState["PAP_GRAVEID"]);
}
GraveBO GraveBOobj = new GraveBO();
GraveBOobj = gravesaveBLLobj.Getdatarow(Pap_graveid);
gravefinishDropDownList.ClearSelection();
if (gravefinishDropDownList.Items.FindByValue(GraveBOobj.Grv_finishid.ToString()) != null)
{
gravefinishDropDownList.Items.FindByValue(GraveBOobj.Grv_finishid.ToString()).Selected = true;
}
lengthTextBox.Text = Convert.ToString(GraveBOobj.Grv_dimen_length);
widthTextBox.Text = Convert.ToString(GraveBOobj.Grv_dimen_width);
surfaceareaTextBox.Text = (GraveBOobj.Grv_dimen_length * GraveBOobj.Grv_dimen_width).ToString();
depreciatedvalueTextBox.Text = GraveBOobj.Depreciatedvalue.ToString();
otherfinishTextBox.Text = GraveBOobj.Othergravefinish.ToString();
}
/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid()
{
GraveBLL gravesaveBLLobj = new GraveBLL();
grdGrave.DataSource = gravesaveBLLobj.GetGravedata(Convert.ToInt32(Session["HH_ID"]));
grdGrave.DataBind();
}
/// <summary>
/// fetch values and assign to dropdownlist
/// </summary>
private void GetGraveFinish()
{
GraveBLL GraveBLLobj = new GraveBLL();
gravefinishDropDownList.DataSource = GraveBLLobj.GetGraveFinish();
gravefinishDropDownList.DataTextField = "Grv_finishtype";
gravefinishDropDownList.DataValueField = "Grv_finishid";
gravefinishDropDownList.DataBind();
gravefinishDropDownList.Items.Insert(0, "--Select--");
}
/// <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 grdUsers_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["PAP_GRAVEID"] = e.CommandArgument;
popupData();
//lnkViewPhoto.Visible = true;
Getdatarow();
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
int Pap_graveid = Convert.ToInt32(e.CommandArgument);
GraveBLL gravesaveBLLobj = new GraveBLL();
gravesaveBLLobj.Delete(Pap_graveid);
BindGrid();
SetUpdateMode(false);
clearfields();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data deleted successfully');", true);
}
}
/// <summary>
/// to save data to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
GraveBLL gravesaveBLLobj = new GraveBLL();
GraveBO GraveBOobj = null;
if (Convert.ToInt32(ViewState["PAP_GRAVEID"]) > 0)
{
// update
try
{
// string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
GraveBOobj = new GraveBO();
GraveBOobj.Pap_graveid = Convert.ToInt32(ViewState["PAP_GRAVEID"]);
GraveBOobj.Grv_finishid = Convert.ToInt32(gravefinishDropDownList.SelectedValue);
if (otherfinishTextBox.Text != string.Empty)
{
GraveBOobj.Othergravefinish = otherfinishTextBox.Text;
}
else
{
GraveBOobj.Othergravefinish = "";
}
if (lengthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(0);
}
if (widthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(widthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
GraveBOobj.Depreciatedvalue = 0;
}
// GraveBOobj.Othergravefinish = otherfinishTextBox.Text.ToString().Trim();
// GraveBOobj.Grv_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// GraveBOobj.Grv_dimen_width = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
SetUpdateMode(false);
// GraveBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
GraveBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
GraveBOobj.HouseholdID = Convert.ToInt32(hhid);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
GraveBOobj.Photo = fileBytes;
}
GraveBLL gravesaveBLL = new GraveBLL();
count = gravesaveBLLobj.EditGRAVE(GraveBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
gravesaveBLLobj = null;
}
}
else
{
// insert
try
{
// string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
GraveBOobj = new GraveBO();
GraveBOobj.Grv_finishid = Convert.ToInt32(gravefinishDropDownList.SelectedValue);
// GraveBOobj.Othergravefinish = otherfinishTextBox.Text.ToString().Trim();
if (otherfinishTextBox.Text != string.Empty)
{
GraveBOobj.Othergravefinish = otherfinishTextBox.Text;
}
else
{
GraveBOobj.Othergravefinish = "";
}
if (lengthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(0);
}
if (widthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(widthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
GraveBOobj.Depreciatedvalue = 0;
}
//GraveBOobj.Grv_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// GraveBOobj.Grv_dimen_width = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
// GraveBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
GraveBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
GraveBOobj.HouseholdID = Convert.ToInt32(hhid);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
GraveBOobj.Photo = fileBytes;
}
GraveBLL graveBLLobj = new GraveBLL();
count = graveBLLobj.Insert(GraveBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
gravesaveBLLobj = null;
}
}
ChangeRequestStatusGrave();
projectFrozen();
}
