private void BindGrid(bool addRow, bool deleteRow)
{
CropsBLL CropsBLLobj = new CropsBLL();
grdCrops.DataSource = CropsBLLobj.GetCrops(Convert.ToInt32(Session["HH_ID"]));
grdCrops.DataBind();
}
private void DeleteData(string cropid)
{
CropsBLL CropsBLLobj = new CropsBLL();
int Result = 0;
if (cropid != null)
{
Result = CropsBLLobj.DeleteData(cropid);
}
}
private void GetData()
{
CropsBLL BLLobj = new CropsBLL();
int CropId = 0;
if (ViewState["PAP_CROPID"] != null)
{
CropId = Convert.ToInt32(ViewState["PAP_CROPID"]);
}
CropsBO BOobj = new CropsBO();
BOobj = BLLobj.GetData(CropId);
txtbxPAP_CROPID.Text = BOobj.PAP_CROPID.ToString();
ddlCropName.ClearSelection();
if (ddlCropName.Items.FindByValue(BOobj.CROPID.ToString()) != null)
{
ddlCropName.Items.FindByValue(BOobj.CROPID.ToString()).Selected = true;
}
ddlCropType.ClearSelection();
if (ddlCropType.Items.FindByValue(BOobj.CROPTYPEID.ToString()) != null)
{
ddlCropType.Items.FindByValue(BOobj.CROPTYPEID.ToString()).Selected = true;
}
ddlCropDescription.ClearSelection();
if (ddlCropDescription.Items.FindByValue(BOobj.CROPDESCRIPTIONID.ToString()) != null)
{
ddlCropDescription.Items.FindByValue(BOobj.CROPDESCRIPTIONID.ToString()).Selected = true;
}
lblUnitMeasure.Text = GetUnitName(ddlCropName.SelectedValue + "|" + ddlCropDescription.SelectedValue)[0];
txtbxQuantity.Text = UtilBO.CurrencyFormat(BOobj.QUANTITY);
txtbxCropRate.Text = UtilBO.CurrencyFormat(BOobj.CROPRATE);
txtbxCropvaluation.Text = UtilBO.CurrencyFormat(BOobj.QUANTITY * BOobj.CROPRATE);
CommentsTextBox.Text = BOobj.COMMENTS;
}
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
if (txtbxPAP_CROPID.Text.ToString().Trim() == string.Empty)
{
CropsBLL BLLobj = new CropsBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
CropsBO Cropsobj = new CropsBO();
Cropsobj.HHID = Convert.ToInt32(hhid);
Cropsobj.CROPID = Convert.ToInt32(ddlCropName.SelectedValue);
Cropsobj.CROPTYPEID = Convert.ToInt32(ddlCropType.SelectedValue);
Cropsobj.CROPDESCRIPTIONID = Convert.ToInt32(ddlCropDescription.SelectedValue);
Cropsobj.QUANTITY = Convert.ToDecimal(txtbxQuantity.Text);
Cropsobj.CROPRATE = Convert.ToDecimal(txtbxCropRate.Text);
if (CommentsTextBox.Text.Length > 1000)
{
Cropsobj.COMMENTS = CommentsTextBox.Text.Substring(0, 1000);
}
else
{
Cropsobj.COMMENTS = CommentsTextBox.Text;
}
Cropsobj.ISDELETED = "False";
Cropsobj.CREATEDBY = Convert.ToInt32(uID);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
if (fileBytes != null)
{
Cropsobj.Photo = fileBytes;
}
}
CropsBLL CropsBLLobj1 = new CropsBLL();
count = CropsBLLobj1.Insert(Cropsobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
BindGrid(true, true);
ClearData();
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
else if (txtbxPAP_CROPID.Text.ToString() != string.Empty)
{
CropsBLL BLLobj = new CropsBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
CropsBO Cropsobj = new CropsBO();
Cropsobj.HHID = Convert.ToInt32(hhid);
Cropsobj.PAP_CROPID = Convert.ToInt32(txtbxPAP_CROPID.Text);
Cropsobj.CROPID = Convert.ToInt32(ddlCropName.SelectedValue);
Cropsobj.CROPTYPEID = Convert.ToInt32(ddlCropType.SelectedValue);
Cropsobj.CROPDESCRIPTIONID = Convert.ToInt32(ddlCropDescription.SelectedValue);
Cropsobj.QUANTITY = Convert.ToDecimal(txtbxQuantity.Text);
Cropsobj.CROPRATE = Convert.ToDecimal(txtbxCropRate.Text);
Cropsobj.CROPVALUATION = Cropsobj.QUANTITY * Cropsobj.CROPRATE;
if (CommentsTextBox.Text.Length > 1000)
{
Cropsobj.COMMENTS = CommentsTextBox.Text.Substring(0, 1000);
}
else
{
Cropsobj.COMMENTS = CommentsTextBox.Text;
}
Cropsobj.ISDELETED = "False";
Cropsobj.CREATEDBY = Convert.ToInt32(uID);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
Cropsobj.Photo = fileBytes;
}
CropsBLL CropsBLLobj1 = new CropsBLL();
count = CropsBLLobj1.UpdateData(Cropsobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
BindGrid(true, true);
ClearData();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
ChangeRequestStatusValuationCrop();
projectFrozen();
}
