public static int CheckExistsOrgItems(ATTInvOrgItems objInvOItems)
{
try
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
string sql = "SELECT CHECK_EXISTS_INV_ORG_ITEM(" + objInvOItems.OrgID + ","
+ objInvOItems.ItemsCategoryID + ","
+ objInvOItems.ItemsSubCategoryID + ",'"
+ objInvOItems.ItemsID + "')" +
"FROM DUAL";
DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.Text, sql);
DataTable tbl = new DataTable();
tbl = (DataTable)ds.Tables[0];
int existsOrgItems = int.Parse(tbl.Rows[0][0].ToString());
return(existsOrgItems);
}
catch (Exception ex)
{
throw (ex);
}
}
public static bool SaveOrgItems(ATTInvOrgItems obj, OracleTransaction Tran)
{
try
{
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":p_org_id", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_items_category_id", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_items_id", obj.ItemsID, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":p_quantity", obj.Quantity, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_p_ji_kha_pa_no", obj.PanNo, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_active", obj.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_entry_by", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
if (obj.Action == "A") //New Add
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "sp_inv_add_org_items", paramArray.ToArray());
}
paramArray.Clear();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected void ddlItems_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int count = 0;
ATTInvOrgItems objInvOItems = new ATTInvOrgItems();
objInvOItems.OrgID = orgID;
objInvOItems.ItemsCategoryID = int.Parse(ddlCategory_rqd.SelectedValue.ToString());
objInvOItems.ItemsSubCategoryID = int.Parse(ddlSubCategory_rqd.SelectedValue.ToString());
objInvOItems.ItemsID = int.Parse(ddlItems_rqd.SelectedValue.ToString());
count = BLLInvOrgItems.CheckExistsOrgItems(objInvOItems);
if (count > 0)
{
lblJelaaKhataNo.Visible = false;
txtJelaaKhataNo_rqd.Visible = false;
}
else
{
lblJelaaKhataNo.Visible = true;
txtJelaaKhataNo_rqd.Visible = true;
}
}
catch (Exception ex)
{
throw(ex);
}
}
public static List <ATTInvOrgItems> GetOrgInvItems(int orgID, string active)
{
List <ATTInvOrgItems> lstitems = new List <ATTInvOrgItems>();
try
{
foreach (DataRow row in DLLInvOrgItems.GetOrgInvItems(orgID, active).Rows)
{
ATTInvOrgItems objitems = new ATTInvOrgItems();
objitems.OrgID = int.Parse(row["ORG_ID"].ToString());
objitems.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString());
objitems.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString());
objitems.ItemsID = int.Parse(row["ITEMS_ID"].ToString());
objitems.Quantity = int.Parse(row["QUANTITY"].ToString());
objitems.PanNo = row["JI_KHA_PA_NO"].ToString();
objitems.Active = row["ACTIVE"].ToString();
//objitems.EntryBy = row["ENTRY_BY"].ToString();
lstitems.Add(objitems);
}
return(lstitems);
}
catch (Exception ex)
{
throw ex;
}
}
public static int CheckExistsOrgItems(ATTInvOrgItems objInvOItems)
{
try
{
return(DLLInvOrgItems.CheckExistsOrgItems(objInvOItems));
}
catch (Exception ex)
{
throw(ex);
}
}
public static bool SaveDakhila(List <ATTInvDakhila> lst)
{
string sp;
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
OracleParameter[] paramArray = new OracleParameter[11];
try
{
foreach (ATTInvDakhila objDak in lst)
{
sp = "";
if (objDak.JelaaKhataNo.Trim() != "")
{
ATTInvOrgItems objOItms = new ATTInvOrgItems();
objOItms.OrgID = int.Parse(objDak.OrgID.ToString());
objOItms.ItemsCategoryID = int.Parse(objDak.ItemsCategoryID.ToString());
objOItms.ItemsSubCategoryID = int.Parse(objDak.ItemsSubCategoryID.ToString());
objOItms.ItemsID = objDak.ItemsID;
objOItms.PanNo = objDak.JelaaKhataNo;
objOItms.Active = "Y";
objOItms.Action = "A";
objOItms.EntryBy = objDak.EntryBy;
DLLInvOrgItems.SaveOrgItems(objOItms, Tran);
}
if (objDak.Action == "A")
{
sp = "sp_inv_add_direct_entry";
}
else if (objDak.Action == "E")
{
sp = "sp_inv_edit_direct_entry";
}
if (sp != "")
{
paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objDak.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_items_category_id", objDak.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_items_sub_category_id", objDak.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":p_items_id", objDak.ItemsID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":p_seq_no", objDak.DirectEntrySeq, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[5] = Utilities.GetOraParam(":p_dir_entry_date", objDak.DirectEntryDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_dir_entry_type", objDak.DirectEntryType, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":p_don_organization", objDak.DonationOrg, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":p_items_unit_price", objDak.UnitPrice, OracleDbType.Int64, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":p_total_quantity", objDak.Quantity, OracleDbType.Int64, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":p_entry_by", objDak.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray);
}
if (objDak.ItemsTypeID == 2 && objDak.LstKNJ.Count > 0)
{
DLLInvOrgItemsKNJ.SaveOrgItemsKNJ(objDak.LstKNJ, Tran);
}
else if (objDak.ItemsTypeID == 2)
{
int i = 0;
List <ATTInvOrgItemsKNJ> lstKNJ = new List <ATTInvOrgItemsKNJ>();
while (i < objDak.Quantity)
{
ATTInvOrgItemsKNJ objOKnj = new ATTInvOrgItemsKNJ();
objOKnj.OrgID = objDak.OrgID;
objOKnj.ItemsCategoryID = objDak.ItemsCategoryID;
objOKnj.ItemsSubCategoryID = objDak.ItemsSubCategoryID;
objOKnj.ItemsID = objDak.ItemsID;
objOKnj.ItemsStatus = "S";
objOKnj.Action = "A";
objOKnj.EntryBy = objDak.EntryBy;
lstKNJ.Add(objOKnj);
i++;
}
if (lstKNJ.Count > 0)
{
DLLInvOrgItemsKNJ.SaveOrgItemsKNJ(lstKNJ, Tran);
}
}
}
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw (ex);
}
finally
{
GetConn.CloseDbConn();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <ATTInvOrgItems> LST = (List <ATTInvOrgItems>)Session["OrgItems"];
List <ATTInvOrgItems> saveLst = new List <ATTInvOrgItems>();
foreach (GridViewRow grow in grdInvOrgItems.Rows)
{
ATTInvOrgItems obj = new ATTInvOrgItems();
string check = ((CheckBox)grow.FindControl("chkItems")).Checked.ToString();
string previous = grow.Cells[9].Text;
string PreviousJikhaPaNo = grow.Cells[11].Text;
string NewJiKhaPaNo = ((TextBox)grow.FindControl("txtJiKhaPaNo")).Text;
if (check == "True" && previous == "N")
{
if (NewJiKhaPaNo == "")
{
lblStatusMessage.Text = "जि.ख.पा.नं छुट्यो";
programmaticModalPopup.Show();
return;
}
obj.OrgID = orgID;
obj.ItemsCategoryID = int.Parse(grow.Cells[1].Text);
obj.ItemsSubCategoryID = int.Parse(grow.Cells[2].Text);
obj.ItemsID = int.Parse(grow.Cells[3].Text);
obj.PanNo = NewJiKhaPaNo;
obj.Quantity = 0;
obj.Active = "Y";
obj.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
ATTInvOrgItems data = LST.Find(
delegate(ATTInvOrgItems ob)
{
return(obj.OrgID == ob.OrgID &&
obj.ItemsCategoryID == ob.ItemsCategoryID &&
obj.ItemsSubCategoryID == ob.ItemsSubCategoryID &&
obj.ItemsID == ob.ItemsID);
}
);
if (data != null)
{
obj.Action = "E";
obj.Quantity = data.Quantity;
}
else
{
obj.Action = "A";
obj.Quantity = 0;
}
saveLst.Add(obj);
}
else if (check == "False" && previous == "Y")
{
if (NewJiKhaPaNo == "")
{
lblStatusMessage.Text = "जि.ख.पा.नं छुट्यो";
programmaticModalPopup.Show();
return;
}
obj.OrgID = orgID;
obj.ItemsCategoryID = int.Parse(grow.Cells[1].Text);
obj.ItemsSubCategoryID = int.Parse(grow.Cells[2].Text);
obj.ItemsID = int.Parse(grow.Cells[3].Text);
obj.PanNo = PreviousJikhaPaNo;
//obj.Quantity = 0;
obj.Active = "N";
obj.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
obj.Action = "E";
ATTInvOrgItems item = LST.Find(
delegate(ATTInvOrgItems ob)
{
return(obj.OrgID == obj.OrgID &&
obj.ItemsCategoryID == obj.ItemsCategoryID &&
obj.ItemsSubCategoryID == obj.ItemsSubCategoryID &&
obj.ItemsID == obj.ItemsID);
}
);
obj.Quantity = item.Quantity;
saveLst.Add(obj);
}
else if (check == "True" && previous == "Y" && PreviousJikhaPaNo != NewJiKhaPaNo)
{
obj.OrgID = orgID;
obj.ItemsCategoryID = int.Parse(grow.Cells[1].Text);
obj.ItemsSubCategoryID = int.Parse(grow.Cells[2].Text);
obj.ItemsID = int.Parse(grow.Cells[3].Text);
obj.PanNo = NewJiKhaPaNo;
obj.Active = "Y";
obj.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
obj.Action = "E";
ATTInvOrgItems data = LST.Find(
delegate(ATTInvOrgItems ob)
{
return(obj.OrgID == ob.OrgID &&
obj.ItemsCategoryID == ob.ItemsCategoryID &&
obj.ItemsSubCategoryID == ob.ItemsSubCategoryID &&
obj.ItemsID == ob.ItemsID);
}
);
obj.Quantity = data.Quantity;
saveLst.Add(obj);
}
}
if (BLLInvOrgItems.SaveOrgItems(saveLst))
{
lblStatusMessage.Text = "Saved Successfully";
programmaticModalPopup.Show();
}
else
{
lblStatusMessage.Text = "Data Could Not be Saved";
programmaticModalPopup.Show();
}
DDLItemCategory.SelectedIndex = -1;
ddlSubCategory.DataSource = "";
ddlSubCategory.DataBind();
ddlSubCategory.SelectedIndex = -1;
grdInvOrgItems.DataSource = null;
grdInvOrgItems.DataBind();
GetOrgItems();
}
catch (Exception)
{
throw;
}
}
