/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid()
{
CulturePropertiesBLL CulturePropertiesBLLobj = new CulturePropertiesBLL();
grdCultureProperties.DataSource = CulturePropertiesBLLobj.GetCultureProp(Convert.ToInt32(Session["HH_ID"]));
grdCultureProperties.DataBind();
}
/// <summary>
/// GetCulturalPropertyType
/// </summary>
private void GetCulturalPropertyType()
{
CulturePropertiesBLL BLLobj = new CulturePropertiesBLL();
ddlCulturePropertyType.DataSource = BLLobj.GetCulturalPropertyType();
ddlCulturePropertyType.DataTextField = "CULTUREPROPTYP";
ddlCulturePropertyType.DataValueField = "CULTUREPROPTYPEID";
ddlCulturePropertyType.DataBind();
}
/// <summary>
/// To fetch data and assign to textbox
/// </summary>
private void GetData()
{
CulturePropertiesBLL BLLobj = new CulturePropertiesBLL();
int culTURALPROPID = 0;
if (ViewState["CULTURALPROPID"] != null)
{
culTURALPROPID = Convert.ToInt32(ViewState["CULTURALPROPID"]);
}
CulturPropertiesBO BOobj = new CulturPropertiesBO();
BOobj = BLLobj.GetData(culTURALPROPID);
CULTURALPROPIDtxtbx.Text = BOobj.CULTURALPROPID.ToString();
ddlCulturePropertyType.ClearSelection();
if (ddlCulturePropertyType.Items.FindByValue(BOobj.CULTUREPROPTYPEID.ToString()) != null)
{
ddlCulturePropertyType.Items.FindByValue(BOobj.CULTUREPROPTYPEID.ToString()).Selected = true;
}
txtbxDescription.Text = BOobj.CULTUREPROPDESCRIPTION;
if (BOobj.CULT_DIMEN_LENGTH.ToString() == "0")
{
txtbxlength.Text = "";
}
else
{
txtbxlength.Text = BOobj.CULT_DIMEN_LENGTH.ToString();
}
if (BOobj.CULT_DIMEN_WIDTH.ToString() == "0")
{
txtbxwidth.Text = "";
}
else
{
txtbxwidth.Text = BOobj.CULT_DIMEN_WIDTH.ToString();
}
if (BOobj.CULT_DEPRECIATEDVALUE.ToString() == "0")
{
txtbxwidth.Text = "";
}
else
{
txtbxDepreciatedValue.Text = BOobj.CULT_DEPRECIATEDVALUE.ToString();
}
if (BOobj.CULT_DEPRECIATEDVALUE.ToString() == "0")
{
txtbxwidth.Text = "";
}
else
{
txtbxDepreciatedValue.Text = BOobj.CULT_DEPRECIATEDVALUE.ToString();
}
if (BOobj.CULT_VALUATIONAMOUNT.ToString() == "0")
{
txtbxValuationAmount.Text = "";
}
else
{
txtbxValuationAmount.Text = BOobj.CULT_VALUATIONAMOUNT.ToString();
}
}
/// <summary>
/// to save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
if (CULTURALPROPIDtxtbx.Text == string.Empty)
{
CulturePropertiesBLL BLLobj = new CulturePropertiesBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
CulturPropertiesBO CulturPropertiesobj = new CulturPropertiesBO();
CulturPropertiesobj.HHID = Convert.ToInt32(hhid);
CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(ddlCulturePropertyType.SelectedValue);
if (txtbxDescription.Text != string.Empty)
{
if (txtbxDescription.Text.Length > 250)
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text.Substring(0, 250);
}
else
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text;
}
}
else
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = "";
}
if (txtbxlength.Text.Trim() != "")
{
CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(txtbxlength.Text);
}
if (txtbxwidth.Text.Trim() != "")
{
CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(txtbxwidth.Text);
}
if (txtbxDepreciatedValue.Text.Trim() != "")
{
CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(txtbxDepreciatedValue.Text);
}
if (txtbxValuationAmount.Text.Trim() != "")
{
CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(txtbxValuationAmount.Text);
}
CulturPropertiesobj.ISDELETED = "False";
CulturPropertiesobj.CREATEDBY = Convert.ToInt32(uID);
//if (photoFileUpload.HasFile)
//{
// byte[] fileBytes = photoFileUpload.FileBytes;
// CulturPropertiesobj.Photo = fileBytes;
//}
CulturePropertiesBLL CulturePropertiesBLLobj = new CulturePropertiesBLL();
count = CulturePropertiesBLLobj.Insert(CulturPropertiesobj);
ChangeRequestStatusCulturProperties();
projectFrozen();
ClearData();
BindGrid();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
else if (CULTURALPROPIDtxtbx.Text != string.Empty)
{
CulturePropertiesBLL BLLobj = new CulturePropertiesBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
CulturPropertiesBO CulturPropertiesobj = new CulturPropertiesBO();
CulturPropertiesobj.HHID = Convert.ToInt32(hhid);
CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(CULTURALPROPIDtxtbx.Text);
CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(ddlCulturePropertyType.SelectedValue);
if (txtbxDescription.Text.Length > 250)
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text.Substring(0, 250);
}
else
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text;
}
if (txtbxlength.Text.Trim() != "")
{
CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(txtbxlength.Text);
}
if (txtbxwidth.Text.Trim() != "")
{
CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(txtbxwidth.Text);
}
if (txtbxDepreciatedValue.Text.Trim() != "")
{
CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(txtbxDepreciatedValue.Text);
}
if (txtbxValuationAmount.Text.Trim() != "")
{
CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(txtbxValuationAmount.Text);
}
CulturPropertiesobj.ISDELETED = "False";
CulturPropertiesobj.CREATEDBY = Convert.ToInt32(uID);
//if (photoFileUpload.HasFile)
//{
// byte[] fileBytes = photoFileUpload.FileBytes;
// CulturPropertiesobj.Photo = fileBytes;
//}
CulturePropertiesBLL CulturePropertiesBLLobj = new CulturePropertiesBLL();
count = CulturePropertiesBLLobj.Update(CulturPropertiesobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
ClearData();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
}
