public static List <ATTInvOrgItemsKNJ> SearchItemsKNJ(int?itmCatID, int?itmSubCatID)
{
try
{
List <ATTInvOrgItemsKNJ> LSTItemsKNJ = new List <ATTInvOrgItemsKNJ>();
foreach (DataRow row in DLLInvOrgItemsKNJ.SearchItemsKNJ(itmCatID, itmSubCatID).Rows)
{
ATTInvOrgItemsKNJ obj = new ATTInvOrgItemsKNJ();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.OrgName = row["ORG_NAME"].ToString();
obj.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString());
obj.ItemsCategoryName = row["ITEMS_CATEGORY_NAME"].ToString();
obj.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString());
obj.ItemsSubCategoryName = row["ITEMS_SUB_CATEGORY_NAME"].ToString();
obj.ItemsID = int.Parse(row["ITEMS_ID"].ToString());
obj.ItemsName = row["ITEMS_NAME"].ToString();
obj.KNJSeq = int.Parse(row["SEQ_NO"].ToString());
obj.ItemsAttrib = row["ITEMS_ATTRIBUTES"].ToString();
obj.VehRegNo = row["VEHICLE_REG_NO"].ToString();
obj.ItemsTypeID = int.Parse(row["ITEMS_TYPE_ID"].ToString());
obj.ItemsTypeName = row["ITEMS_TYPE_NAME"].ToString();
obj.ItemsUnitID = int.Parse(row["ITEMS_UNIT_ID"].ToString());
obj.ItemsUnitName = row["ITEMS_UNIT_NAME"].ToString();
obj.JI_KHA_PA_NO = row["JI_KHA_PA_NO"].ToString();
LSTItemsKNJ.Add(obj);
}
return(LSTItemsKNJ);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SearchItemsKNJ(ATTInvOrgItemsKNJ obj)
{
try
{
string strSelect = "";
strSelect = "SELECT * FROM VW_INV_ORG_ITEMS_KNJ WHERE ITEMS_STATUS='S' ";
List <OracleParameter> ParamList = new List <OracleParameter>();
if (obj.OrgID > 0)
{
strSelect += " AND ORG_ID = :itmOrgID";
ParamList.Add(Utilities.GetOraParam(":itmOrgID", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input));
}
if (obj.ItemsCategoryID > 0)
{
strSelect += " AND ITEMS_CATEGORY_ID = :itmCatID";
ParamList.Add(Utilities.GetOraParam(":itmCatID", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input));
}
if (obj.ItemsSubCategoryID > 0)
{
strSelect += " AND ITEMS_SUB_CATEGORY_ID = :itmSubCatID";
ParamList.Add(Utilities.GetOraParam(":itmSubCatID", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input));
}
if (obj.ItemsID > 0)
{
strSelect += " AND ITEMS_ID = :itmID";
ParamList.Add(Utilities.GetOraParam(":itmID", obj.ItemsID, OracleDbType.Int64, ParameterDirection.Input));
}
//if (obj.ItemsTypeID > 0)
//{
// strSelect += " AND ITEMS_TYPE_ID = :itmTypeID";
// ParamList.Add(Utilities.GetOraParam(":itmTypeID", obj.ItemsTypeID, OracleDbType.Int64, ParameterDirection.Input));
//}
GetConnection conn = new GetConnection();
OracleConnection con = conn.GetDbConn(Module.OAS);
DataSet ds = SqlHelper.ExecuteDataset(con, CommandType.Text, strSelect, ParamList.ToArray());
return((DataTable)ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
protected void ddlItemsKNJ_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlItemsKNJ.SelectedIndex > 0)
{
int itemType = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID;
if (itemType == 2)
{
ATTInvOrgItemsKNJ obj = new ATTInvOrgItemsKNJ();
obj.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID;
obj.ItemsCategoryID = int.Parse(ddlCategory.SelectedValue);
obj.ItemsSubCategoryID = int.Parse(ddlSubCategory.SelectedValue);
obj.ItemsID = int.Parse(ddlItemsKNJ.SelectedValue);
List <ATTInvOrgItemsKNJ> lstKNJItems = BLLInvOrgItemsKNJ.SearchItemsKNJ(obj);
this.grdKNJItems.DataSource = lstKNJItems;
this.grdKNJItems.DataBind();
Session["KNJItems"] = lstKNJItems;
txtQuantiy.ReadOnly = true;
Panel1.Visible = true;
}
else
{
txtQuantiy.ReadOnly = false;
}
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
txtQuantiy.Text = "";
}
protected void grdItemsTrans_SelectedIndexChanged(object sender, EventArgs e)
{
List <ATTInvItemsTransfered> lstItemsTrans = ((List <ATTInvItemsTransfered>)Session["GrdData"]);
int itemType = lstItemsTrans[grdItemsTrans.SelectedIndex].ItemsTypeID;
this.ddlCategory.SelectedValue = lstItemsTrans[grdItemsTrans.SelectedIndex].ItemsCategoryID.ToString();
List <ATTInvItemSubCategory> lst = GetItemSubCategory(int.Parse(ddlCategory.SelectedValue.ToString()));
Session["SubCat"] = lst;
ddlSubCategory.DataSource = lst;
ddlSubCategory.DataTextField = "ItemsSubCategoryName";
ddlSubCategory.DataValueField = "ItemsSubCategoryID";
ddlSubCategory.DataBind();
this.ddlSubCategory.SelectedValue = lstItemsTrans[grdItemsTrans.SelectedIndex].ItemsSubCategoryID.ToString();
LoadDDLItems();
this.ddlItemsKNJ.SelectedValue = grdItemsTrans.SelectedRow.Cells[5].Text;
if (itemType == 1)
{
this.txtQuantiy.Text = lstItemsTrans[grdItemsTrans.SelectedIndex].Quantity.ToString();
txtQuantiy.ReadOnly = false;
}
else if (itemType == 2)
{
Panel1.Visible = true;
this.txtQuantiy.Text = "";
txtQuantiy.ReadOnly = true;
ATTInvOrgItemsKNJ obj = new ATTInvOrgItemsKNJ();
obj.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID;
obj.ItemsCategoryID = int.Parse(ddlCategory.SelectedValue);
obj.ItemsSubCategoryID = int.Parse(ddlSubCategory.SelectedValue);
obj.ItemsID = int.Parse(grdItemsTrans.SelectedRow.Cells[5].Text);
//obj.ItemsTypeID = 2;
List <ATTInvOrgItemsKNJ> lstKNJItems = BLLInvOrgItemsKNJ.SearchItemsKNJ(obj);
this.grdKNJItems.DataSource = lstKNJItems;
this.grdKNJItems.DataBind();
Session["KNJItems"] = lstKNJItems;
txtQuantiy.ReadOnly = true;
//getmatching items checked code goes here
foreach (GridViewRow var in grdKNJItems.Rows)
{
int orgid = int.Parse(var.Cells[1].Text);
int catid = int.Parse(var.Cells[2].Text);
int subcatid = int.Parse(var.Cells[3].Text);
int itemid = int.Parse(var.Cells[4].Text);
int itemtypeid = int.Parse(var.Cells[5].Text);
int seqno = int.Parse(var.Cells[9].Text);
List <ATTInvItemsTransfered> lstData = (List <ATTInvItemsTransfered>)Session["ItemsTransfered"];
bool exists = lstData.Exists(delegate(ATTInvItemsTransfered objkvn)
{
return(objkvn.OrgID == orgid &&
objkvn.ItemsCategoryID == catid &&
objkvn.ItemsSubCategoryID == subcatid &&
objkvn.ItemsID == itemid &&
objkvn.ItemsTypeID == itemtypeid &&
objkvn.SeqNo == seqno
);
}
);
((CheckBox)var.FindControl("chkItems")).Checked = exists;
}
}
}
protected void btnKNJ_Click(object sender, EventArgs e)
{
try
{
int rowIndex = -1;
List <ATTInvOrgItemsKNJ> lstKNJ = new List <ATTInvOrgItemsKNJ>();
List <ATTInvDakhila> lst = new List <ATTInvDakhila>();
if (Session["grdKnjRow"] != null)
{
GridViewRow gvRow = (GridViewRow)Session["grdKnjRow"];
rowIndex = gvRow.RowIndex;
foreach (GridViewRow row in grdNonExpendible.Rows)
{
ATTInvOrgItemsKNJ objOKnj = new ATTInvOrgItemsKNJ();
objOKnj.OrgID = int.Parse(gvRow.Cells[1].Text);
objOKnj.ItemsCategoryID = int.Parse(gvRow.Cells[2].Text);
objOKnj.ItemsSubCategoryID = int.Parse(gvRow.Cells[3].Text);
objOKnj.ItemsID = int.Parse(gvRow.Cells[4].Text);
objOKnj.ItemsStatus = "S";
objOKnj.Action = "A";
objOKnj.EntryBy = entryBy;
TextBox txtBox1 = (TextBox)row.FindControl("txtBox1");
TextBox txtBox2 = (TextBox)row.FindControl("txtBox2");
objOKnj.ItemsAttrib = txtBox1.Text;
objOKnj.VehRegNo = txtBox2.Text;
lstKNJ.Add(objOKnj);
}
if (Session["lstDak"] != null)
{
lst = (List <ATTInvDakhila>)Session["lstDak"];
}
if (rowIndex != -1)
{
lst[rowIndex].LstKNJ = lstKNJ;
Session["grdKnjRow"] = null;
rowIndex = -1;
}
}
this.programmaticCommentModalPopup.Hide();
}
catch (Exception ex)
{
this.lblStatusMessageTitle.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
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();
}
}
