/// <summary>
/// to get Image File for DataBase
/// </summary>
/// <param name="householdID"></param>
/// <param name="PermanentStructureID"></param>
/// <returns></returns>
public DamagedCropsBO ShowDAMAGEDCROPSImage(int householdID, int PermanentStructureID)
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_GET_DAMAGED_CROP_PHOTO", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("HHID_", householdID);
myCommand.Parameters.Add("PermanentStructureID_", PermanentStructureID);
myCommand.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
myCommand.Connection.Open();
object img = myCommand.ExecuteScalar();
try
{
byte[] papPhotoBytes = (byte[])img;
DamagedCropsBO objDAMAGEDCROPSImage = new DamagedCropsBO();
objDAMAGEDCROPSImage.Photo = papPhotoBytes;
return(objDAMAGEDCROPSImage);
}
catch (Exception ex)
{
return(null);
}
finally
{
myConnection.Close();
}
}
/// <summary>
/// to save data to database
/// </summary>
/// <param name="DamagedCropsobj"></param>
/// <returns></returns>
public int Insert(DamagedCropsBO DamagedCropsobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand(" USP_TRN_INS_DAMAGE_CROPS", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID", DamagedCropsobj.HHID);
dcmd.Parameters.Add("DMGCRPFORMREFNO", DamagedCropsobj.DMGCRPFORMREFNO);
dcmd.Parameters.Add("CROPID", DamagedCropsobj.CROPID);
dcmd.Parameters.Add("CROPTYPEID", DamagedCropsobj.CROPTYPEID);
dcmd.Parameters.Add("CROPDESCRIPTIONID", DamagedCropsobj.CROPDESCRIPTIONID);
dcmd.Parameters.Add("DATEDAMAGED", DamagedCropsobj.DATEDAMAGED);
dcmd.Parameters.Add("CROPDAMAGEDBYID", DamagedCropsobj.CROPDAMAGEDBYID);
dcmd.Parameters.Add("CROPDAMAGEDBYOTHER", DamagedCropsobj.CROPDAMAGEDBYOTHER);
dcmd.Parameters.Add("QUANTITY", DamagedCropsobj.QUANTITY);
dcmd.Parameters.Add("CROPRATE", DamagedCropsobj.CROPRATE);
dcmd.Parameters.Add("AMOUNTPAID", DamagedCropsobj.AMOUNTPAID);
if (DamagedCropsobj.COMMENTS.Length > 1500)
{
dcmd.Parameters.Add("COMMENTS", DamagedCropsobj.COMMENTS.Substring(0, 1500));
}
else
{
dcmd.Parameters.Add("COMMENTS", DamagedCropsobj.COMMENTS);
}
dcmd.Parameters.Add("ISDELETED", DamagedCropsobj.ISDELETED);
dcmd.Parameters.Add("CREATEDBY", DamagedCropsobj.CREATEDBY);
if (DamagedCropsobj.Photo != null)
{
dcmd.Parameters.Add("DAMGEDCROPPHOTO_", OracleDbType.Blob).Value = DamagedCropsobj.Photo;
}
else
{
dcmd.Parameters.Add("DAMGEDCROPPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null);
}
return(dcmd.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// to fetch details from database
/// </summary>
/// <returns></returns>
public DamagedCropsList GetDamagedBy()
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_DAMAGE_DCROP";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DamagedCropsBO BOobj = null;
DamagedCropsList Listobj = new DamagedCropsList();
while (dr.Read())
{
BOobj = new DamagedCropsBO();
BOobj.CROPDAMAGEDBYID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDAMAGEDBYID"))));
BOobj.CROPDAMAGEDBYOTHER = dr.GetValue(dr.GetOrdinal("CROPDAMAGEDBY")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// to fetch details and assign to textbox
/// </summary>
private void GetData()
{
DamagedCropsBLL DamagedCropsBLLobj = new DamagedCropsBLL();
int damageCropId = 0;
if (ViewState["DAMAGED_CROPID"] != null)
{
damageCropId = Convert.ToInt32(ViewState["DAMAGED_CROPID"]);
}
DamagedCropsBO BOobj = new DamagedCropsBO();
BOobj = DamagedCropsBLLobj.GetData(damageCropId);
DAMAGED_CROPIDTextBox.Text = BOobj.DAMAGED_CROPID.ToString();
txtbxDamagedCropFormRefNo.Text = BOobj.DMGCRPFORMREFNO;
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;
}
DateDamaged.Text = BOobj.DATEDAMAGED.ToString(UtilBO.DateFormat);
ddlDamagedBy.ClearSelection();
if (ddlDamagedBy.Items.FindByValue(BOobj.CROPDAMAGEDBYID.ToString()) != null)
{
ddlDamagedBy.Items.FindByValue(BOobj.CROPDAMAGEDBYID.ToString()).Selected = true;
}
DamagedByTextBox.Text = BOobj.CROPDAMAGEDBYOTHER;
updDamagedBy.Update();
txtbxQuantity.Text = UtilBO.CurrencyFormat(BOobj.QUANTITY);
txtbxCropRate.Text = UtilBO.CurrencyFormat(BOobj.CROPRATE);
txtbxAmountPaid.Text = UtilBO.CurrencyFormat(BOobj.AMOUNTPAID);
CommentsTextBox.Text = BOobj.COMMENTS;
}
/// <summary>
/// To Insert
/// </summary>
/// <param name="DamagedCropsobj"></param>
/// <returns></returns>
public int Insert(DamagedCropsBO DamagedCropsobj)
{
DamagedCropsDAL DALobj = new DamagedCropsDAL(); //Data pass -to Database Layer
try
{
return(DALobj.Insert(DamagedCropsobj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DALobj = null;
}
}
public System.IO.MemoryStream ShowDAMAGEDCROPSImage(int householdID, int PermanentStructureID)
{
try
{
DamagedCropsBO objDAMAGEDCROPSImage = (new DamagedCropsBLL()).ShowDAMAGEDCROPSImage(householdID, PermanentStructureID);
if (objDAMAGEDCROPSImage.Photo != null)
{
return(new System.IO.MemoryStream(objDAMAGEDCROPSImage.Photo));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//throw ex;
return(null);
}
}
/// <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 (DAMAGED_CROPIDTextBox.Text.ToString().Trim() == string.Empty)
{
DamagedCropsBLL BLLobj = new DamagedCropsBLL();
DamagedCropsBO DamagedCropsobj = new DamagedCropsBO();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
DamagedCropsobj.HHID = Convert.ToInt32(hhid);
DamagedCropsobj.DMGCRPFORMREFNO = txtbxDamagedCropFormRefNo.Text;
DamagedCropsobj.CROPID = Convert.ToInt32(ddlCropName.SelectedValue);
DamagedCropsobj.CROPTYPEID = Convert.ToInt32(ddlCropType.SelectedValue);
DamagedCropsobj.CROPDESCRIPTIONID = Convert.ToInt32(ddlCropDescription.SelectedValue);
DamagedCropsobj.DATEDAMAGED = Convert.ToDateTime(DateDamaged.Text.ToString());
DamagedCropsobj.CROPDAMAGEDBYID = Convert.ToInt32(ddlDamagedBy.SelectedValue);
if (DamagedByTextBox.Text != string.Empty)
{
DamagedCropsobj.CROPDAMAGEDBYOTHER = DamagedByTextBox.Text;
}
else
{
DamagedCropsobj.CROPDAMAGEDBYOTHER = "";
}
DamagedCropsobj.QUANTITY = Convert.ToDecimal(txtbxQuantity.Text);
DamagedCropsobj.CROPRATE = Convert.ToDecimal(txtbxCropRate.Text);
DamagedCropsobj.AMOUNTPAID = DamagedCropsobj.QUANTITY * DamagedCropsobj.CROPRATE;
if (CommentsTextBox.Text.Length > 1000)
{
DamagedCropsobj.COMMENTS = CommentsTextBox.Text.Substring(0, 1000);
}
else
{
DamagedCropsobj.COMMENTS = CommentsTextBox.Text;
}
DamagedCropsobj.ISDELETED = "False";
DamagedCropsobj.CREATEDBY = Convert.ToInt32(uID);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
if (fileBytes != null)
{
DamagedCropsobj.Photo = fileBytes;
}
}
DamagedCropsBLL DamagedCropsBLLobj = new DamagedCropsBLL();
count = DamagedCropsBLLobj.Insert(DamagedCropsobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
BindGrid();
ClearData();
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
else if (DAMAGED_CROPIDTextBox.Text.ToString().Trim() != string.Empty)
{
DamagedCropsBLL BLLobj = new DamagedCropsBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
DamagedCropsBO DamagedCropsobj = new DamagedCropsBO();
DamagedCropsobj.HHID = Convert.ToInt32(hhid);
DamagedCropsobj.DAMAGED_CROPID = Convert.ToInt32(DAMAGED_CROPIDTextBox.Text);
DamagedCropsobj.DMGCRPFORMREFNO = txtbxDamagedCropFormRefNo.Text;
DamagedCropsobj.CROPID = Convert.ToInt32(ddlCropName.SelectedValue);
DamagedCropsobj.CROPTYPEID = Convert.ToInt32(ddlCropType.SelectedValue);
DamagedCropsobj.CROPDESCRIPTIONID = Convert.ToInt32(ddlCropDescription.SelectedValue);
DamagedCropsobj.DATEDAMAGED = Convert.ToDateTime(DateDamaged.Text.ToString());
DamagedCropsobj.CROPDAMAGEDBYID = Convert.ToInt32(ddlDamagedBy.SelectedValue);
DamagedCropsobj.CROPDAMAGEDBYOTHER = DamagedByTextBox.Text;
DamagedCropsobj.QUANTITY = Convert.ToDecimal(txtbxQuantity.Text);
DamagedCropsobj.CROPRATE = Convert.ToDecimal(txtbxCropRate.Text);
DamagedCropsobj.AMOUNTPAID = DamagedCropsobj.QUANTITY * DamagedCropsobj.CROPRATE;
if (CommentsTextBox.Text.Length > 1000)
{
DamagedCropsobj.COMMENTS = CommentsTextBox.Text.Substring(0, 1000);
}
else
{
DamagedCropsobj.COMMENTS = CommentsTextBox.Text;
}
DamagedCropsobj.ISDELETED = "False";
DamagedCropsobj.CREATEDBY = Convert.ToInt32(uID);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
if (fileBytes != null)
{
DamagedCropsobj.Photo = fileBytes;
}
}
DamagedCropsBLL DamagedCropsBLLobj = new DamagedCropsBLL();
count = BLLobj.Update(DamagedCropsobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
BindGrid();
ClearData();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
ChangeRequestStatusDamageCrops();
projectFrozen();
}
/// <summary>
/// to fetch details from database
/// </summary>
/// <param name="damageCropId"></param>
/// <returns></returns>
public DamagedCropsBO GetData(int damageCropId)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_DAMAGE_CROPS";//"USP_TRN_GET_DAMAGE_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("D_DAMAGED_CROPID", damageCropId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DamagedCropsBO DamagedCropsobj = null;
DamagedCropsList Listobj = new DamagedCropsList();
DamagedCropsobj = new DamagedCropsBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("DAMAGED_CROPID")))
{
DamagedCropsobj.DAMAGED_CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("DAMAGED_CROPID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("DMGCRPFORMREFNO")))
{
DamagedCropsobj.DMGCRPFORMREFNO = dr.GetString(dr.GetOrdinal("DMGCRPFORMREFNO"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPID")))
{
DamagedCropsobj.CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPTYPEID")))
{
DamagedCropsobj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPDESCRIPTIONID")))
{
DamagedCropsobj.CROPDESCRIPTIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTIONID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("DATEDAMAGED")))
{
DamagedCropsobj.DATEDAMAGED = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("DATEDAMAGED")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPDAMAGEDBYID")))
{
DamagedCropsobj.CROPDAMAGEDBYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDAMAGEDBYID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPDAMAGEDBYOTHER")))
{
DamagedCropsobj.CROPDAMAGEDBYOTHER = dr.GetString(dr.GetOrdinal("CROPDAMAGEDBYOTHER"));
}
if (!dr.IsDBNull(dr.GetOrdinal("QUANTITY")))
{
DamagedCropsobj.QUANTITY = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("QUANTITY")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPRATE")))
{
DamagedCropsobj.CROPRATE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CROPRATE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("AMOUNTPAID")))
{
DamagedCropsobj.AMOUNTPAID = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("AMOUNTPAID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("COMMENTS")))
{
DamagedCropsobj.COMMENTS = dr.GetString(dr.GetOrdinal("COMMENTS"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
DamagedCropsobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(DamagedCropsobj);
}
/// <summary>
/// to fetch details from database
/// </summary>
/// <param name="hhid"></param>
/// <returns></returns>
public DamagedCropsList GetDamagedCrops(string hhid)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_DAMAG_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("D_HHID", hhid);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DamagedCropsBO DamagedCropsobj = null;
DamagedCropsList Listobj = new DamagedCropsList();
while (dr.Read())
{
DamagedCropsobj = new DamagedCropsBO();
DamagedCropsobj.DAMAGED_CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("damaged_cropid")));
if (!dr.IsDBNull(dr.GetOrdinal("dmgcrpformrefno")))
{
DamagedCropsobj.DMGCRPFORMREFNO = dr.GetString(dr.GetOrdinal("dmgcrpformrefno"));
}
else
{
DamagedCropsobj.DMGCRPFORMREFNO = "";
}
if (!dr.IsDBNull(dr.GetOrdinal("cropname")))
{
DamagedCropsobj.Cropname = dr.GetString(dr.GetOrdinal("cropname"));
}
else
{
DamagedCropsobj.Cropname = "";
}
if (!dr.IsDBNull(dr.GetOrdinal("croptype")))
{
DamagedCropsobj.Croptype = dr.GetString(dr.GetOrdinal("croptype"));
}
else
{
DamagedCropsobj.Croptype = "";
}
if (!dr.IsDBNull(dr.GetOrdinal("cropdescription")))
{
DamagedCropsobj.Description = dr.GetString(dr.GetOrdinal("cropdescription"));
}
else
{
DamagedCropsobj.Description = "";
}
if (!dr.IsDBNull(dr.GetOrdinal("datedamaged")))
{
DamagedCropsobj.DATEDAMAGED = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("datedamaged")));
}
else
{
DamagedCropsobj.DATEDAMAGED = Convert.ToDateTime("");
}
if (!dr.IsDBNull(dr.GetOrdinal("quantity")))
{
DamagedCropsobj.QUANTITY = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("quantity")));
}
else
{
DamagedCropsobj.QUANTITY = 0;
}
if (!dr.IsDBNull(dr.GetOrdinal("croprate")))
{
DamagedCropsobj.CROPRATE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("croprate")));
}
else
{
DamagedCropsobj.CROPRATE = 0;
}
if (!dr.IsDBNull(dr.GetOrdinal("amountpaid")))
{
DamagedCropsobj.AMOUNTPAID = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("amountpaid")));
}
else
{
DamagedCropsobj.AMOUNTPAID = 0;
}
// PermanentStructureobj.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
Listobj.Add(DamagedCropsobj);
}
dr.Close();
return(Listobj);
}
