/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid()
{
OtherFixturesBLL fenceBLLobj = new OtherFixturesBLL();
grdFence.DataSource = fenceBLLobj.GetFencedata(Convert.ToInt32(Session["HH_ID"]));
grdFence.DataBind();
}
/// <summary>
/// used to fetch details and assign to textbox
/// </summary>
private void Getfencedatarow()
{
OtherFixturesBLL fenceBLLobj = new OtherFixturesBLL();
int Pap_fenceid = 0;
if (ViewState["PAP_FENCEID"] != null)
{
Pap_fenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
}
OtherFenceBO FenceBOobj = new OtherFenceBO();
FenceBOobj = fenceBLLobj.Getfencedatarow(Pap_fenceid);
//if( fixtureDescription.Text != "")
fixtureDescription.Text = FenceBOobj.Otherfencedescription.ToString();
lengthTextBox.Text = FenceBOobj.DIMEN_LENGTH.ToString();
heightTextBox.Text = FenceBOobj.DIMEN_WIDTH.ToString();
surfaceareaTextBox.Text = (FenceBOobj.DIMEN_LENGTH * FenceBOobj.DIMEN_WIDTH).ToString();
depreciatedvalueTextBox.Text = FenceBOobj.Depreciatedvalue.ToString();
}
/// <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_FENCEID"] = e.CommandArgument;
Getfencedatarow();
//popupData();
SetUpdateMode(true);
//lnkViewPhoto.Visible = true;
}
else if (e.CommandName == "DeleteRow")
{
int Pap_fenceid = Convert.ToInt32(e.CommandArgument);
OtherFixturesBLL fenceBLLobj = new OtherFixturesBLL();
fenceBLLobj.Delete(Pap_fenceid);
BindGrid();
SetUpdateMode(false);
clearfields();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data deleted successfully');", true);
}
}
/// <summary>
/// To save data into database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
OtherFixturesBLL fenceBLLobj = new OtherFixturesBLL();
OtherFenceBO FenceBOobj = null;
if (Convert.ToInt32(ViewState["PAP_FENCEID"]) > 0)
{
// update
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
FenceBOobj = new OtherFenceBO();
FenceBOobj.Pap_otherfenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
//FenceBOobj.Fenceid = Convert.ToInt32(fenceDropDownList.SelectedItem.Value);
if (fixtureDescription.Text.Trim() != null)
{
FenceBOobj.Otherfencedescription = fixtureDescription.Text;
}
if (lengthTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(0);
}
if (heightTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(heightTextBox.Text);
}
else
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
FenceBOobj.Depreciatedvalue = 0;
}
// FenceBOobj.Fen_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// FenceBOobj.Fen_dimen_height = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
// FenceBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
FenceBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
FenceBOobj.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
FenceBOobj.HouseholdID = Convert.ToInt32(hhid);
//if (photoFileUpload.HasFile)
//{
// byte[] fileBytes = photoFileUpload.FileBytes;
// FenceBOobj.Photo = fileBytes;
//}
OtherFixturesBLL fenceupdateBLLobj = new OtherFixturesBLL();
count = fenceupdateBLLobj.EditFence(FenceBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
fenceBLLobj = null;
}
}
else
{
// insert
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
FenceBOobj = new OtherFenceBO();
FenceBOobj.Pap_otherfenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
// FenceBOobj.Fenceid = Convert.ToInt32(fenceDropDownList.SelectedValue);
if (fixtureDescription.Text.Trim() != null)
{
FenceBOobj.Otherfencedescription = fixtureDescription.Text;
}
if (lengthTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(0);
}
if (heightTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(heightTextBox.Text);
}
else
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
FenceBOobj.Depreciatedvalue = 0;
}
// FenceBOobj.Fen_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// FenceBOobj.Fen_dimen_height = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
// FenceBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
FenceBOobj.CreatedBy = Convert.ToInt32(uID);
FenceBOobj.HouseholdID = Convert.ToInt32(hhid);
//if (photoFileUpload.HasFile)
//{
// byte[] fileBytes = photoFileUpload.FileBytes;
// FenceBOobj.Photo = fileBytes;
//}
OtherFixturesBLL fencesaveBLLobj = new OtherFixturesBLL();
count = fencesaveBLLobj.Insert(FenceBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
fenceBLLobj = null;
}
}
ChangeRequestStatusFence();
projectFrozen();
}
