public static List <ATTInvItemsTransfered> GetItemsTransfKNJList()
{
List <ATTInvItemsTransfered> lstItemsTransKNJLst = new List <ATTInvItemsTransfered>();
try
{
foreach (DataRow row in DLLInvItemsTransfered.getItemsTransfKNJ().Rows)
{
ATTInvItemsTransfered obj = new ATTInvItemsTransfered();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.TransSEQ = int.Parse(row["TRFD_SEQ"].ToString());
obj.TransORG = int.Parse(row["TRFD_ORG"].ToString());
obj.TransfOrgName = row["TRFD_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.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.Quantity = int.Parse(row["QUANTITY"].ToString());
obj.DecisionDate = row["DECISION_DATE"].ToString();
obj.TransDate = row["TRFD_DATE"].ToString();
obj.TransVia = int.Parse(row["TRFD_VIA"].ToString());
obj.TransOrgUnit = int.Parse(row["TRFD_ORG_UNIT"].ToString());
obj.TransTo = int.Parse(row["TRFD_TO"].ToString());
obj.SeqNo = int.Parse(row["SEQ_NO"].ToString());
if (row["TRFD_RCVD_BY"].ToString() != "")
{
obj.TransRecvBy = int.Parse(row["TRFD_RCVD_BY"].ToString());
}
else
{
obj.TransRecvBy = null;
}
obj.TransRecvDate = row["TRFD_RCVD_DATE"].ToString();
lstItemsTransKNJLst.Add(obj);
}
return(lstItemsTransKNJLst);
}
catch (Exception)
{
throw;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (ddlCategory.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "क्रिपया सामुह मा भाको समान छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (ddlSubCategory.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "क्रिपया उप-सामुह मा भाको समान छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (ddlItemsKNJ.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "क्रिपया हस्तान्तरण गर्न लागेको समान छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (Session["ItemsTransfered"] == null)
{
Session["ItemsTransfered"] = new List <ATTInvItemsTransfered>();
}
List <ATTInvItemsTransfered> LSTItemsTrans = (List <ATTInvItemsTransfered>)Session["ItemsTransfered"];
Panel1.Visible = false;
int count = 0;
int itemType = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID;
if (itemType == 2)
{
#region itemtype 2
if (this.grdItemsTrans.SelectedIndex == -1)
{
//if (ValidationControl() == true)
//{
foreach (GridViewRow rw in grdKNJItems.Rows)
{
if (((CheckBox)rw.FindControl("chkItems")).Checked == true)
{
count++;
ATTInvItemsTransfered objItemsTrans = new ATTInvItemsTransfered();
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
objItemsTrans.OrgID = user.OrgID;
objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue);
objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName;
objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue);
objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName;
objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue);
objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName;
objItemsTrans.ItemsTypeID = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID;
objItemsTrans.ItemsTypeName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeName;
objItemsTrans.Quantity = count;
objItemsTrans.SeqNo = int.Parse(rw.Cells[9].Text);
objItemsTrans.Action = "A";
LSTItemsTrans.Add(objItemsTrans);
}
}
//}
}
else if (this.grdItemsTrans.SelectedIndex > -1)
{
#region edit
int orgid = int.Parse(grdItemsTrans.SelectedRow.Cells[0].Text);
int catid = int.Parse(grdItemsTrans.SelectedRow.Cells[1].Text);
int subcatid = int.Parse(grdItemsTrans.SelectedRow.Cells[3].Text);
int itemid = int.Parse(grdItemsTrans.SelectedRow.Cells[5].Text);
int itemtypeid = int.Parse(grdItemsTrans.SelectedRow.Cells[7].Text);
/////////
int i = LSTItemsTrans.RemoveAll(delegate(ATTInvItemsTransfered objkvn)
{
return(objkvn.OrgID == orgid &&
objkvn.ItemsCategoryID == catid &&
objkvn.ItemsSubCategoryID == subcatid &&
objkvn.ItemsID == itemid &&
objkvn.ItemsTypeID == itemtypeid
);
}
);
////////////////
//if (ValidationControl() == true)
//{
foreach (GridViewRow rw in grdKNJItems.Rows)
{
if (((CheckBox)rw.FindControl("chkItems")).Checked == true)
{
count++;
ATTInvItemsTransfered objItemsTrans = new ATTInvItemsTransfered();
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
objItemsTrans.OrgID = user.OrgID;
objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue);
objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName;
objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue);
objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName;
objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue);
objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName;
objItemsTrans.ItemsTypeID = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID;
objItemsTrans.ItemsTypeName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeName;
objItemsTrans.Quantity = count;
objItemsTrans.SeqNo = int.Parse(rw.Cells[9].Text);
objItemsTrans.Action = "A";
LSTItemsTrans.Add(objItemsTrans);
}
}
//}
#endregion
}
Clearcontrols(false);
#endregion
}
else
{
#region itemtype1
if (this.grdItemsTrans.SelectedIndex == -1)
{
if (this.txtQuantiy.Text == "")
{
lblStatusMessage.Text = "quantity missing";
this.programmaticModalPopup.Show();
return;
}
else if (int.Parse(txtQuantiy.Text.Trim()) > ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlSubCategory.SelectedIndex - 1].Quantity)
{
lblStatusMessage.Text = "quantity transferred is greater than available";
this.programmaticModalPopup.Show();
return;
}
ATTInvItemsTransfered objItemsTrans = new ATTInvItemsTransfered();
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
objItemsTrans.OrgID = user.OrgID;
objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue);
objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName;
objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue);
objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName;
objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue);
objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName;
objItemsTrans.ItemsTypeID = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeID;
objItemsTrans.ItemsTypeName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemsTypeName;
objItemsTrans.Quantity = int.Parse(this.txtQuantiy.Text.Trim());
objItemsTrans.Action = "A";
objItemsTrans.EntryBy = user.UserName;
LSTItemsTrans.Add(objItemsTrans);
Session["ItemsTransfered"] = LSTItemsTrans;
}
else if (this.grdItemsTrans.SelectedIndex > -1)
{
ATTInvItemsTransfered objItemsTrans = LSTItemsTrans[this.grdItemsTrans.SelectedIndex];
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
objItemsTrans.ItemsCategoryID = int.Parse(this.ddlCategory.SelectedValue);
objItemsTrans.ItemsCategoryName = ((List <ATTInvItemsCategory>)Session["Cat"])[ddlCategory.SelectedIndex - 1].ItemsCategoryName;
objItemsTrans.ItemsSubCategoryID = int.Parse(this.ddlSubCategory.SelectedValue);
objItemsTrans.ItemsSubCategoryName = ((List <ATTInvItemSubCategory>)Session["SubCat"])[ddlSubCategory.SelectedIndex].ItemsSubCategoryName;
objItemsTrans.ItemsID = int.Parse(this.ddlItemsKNJ.SelectedValue);
objItemsTrans.ItemsName = ((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].ItemName;
if (this.txtQuantiy.Text != "")
{
objItemsTrans.Quantity = int.Parse(this.txtQuantiy.Text.Trim());
}
objItemsTrans.Action = (((List <ATTInvOrgItemsPrice>)Session["Items"])[ddlItemsKNJ.SelectedIndex - 1].Action == "A") ? "A" : "E";
Session["ItemsTransfered"] = LSTItemsTrans;
}
Clearcontrols(false);
#endregion
}
List <ATTInvItemsTransfered> lstNew = new List <ATTInvItemsTransfered>();
foreach (ATTInvItemsTransfered var in (List <ATTInvItemsTransfered>)Session["ItemsTransfered"])
{
if (var.ItemsTypeID == 1)
{
lstNew.Add(var);
}
else if (var.ItemsTypeID == 2)
{
int index = -1;
index = lstNew.FindIndex(
delegate(ATTInvItemsTransfered obj)
{
return(var.OrgID == obj.OrgID &&
var.ItemsCategoryID == obj.ItemsCategoryID &&
var.ItemsSubCategoryID == obj.ItemsSubCategoryID &&
var.ItemsID == obj.ItemsID &&
var.ItemsTypeID == obj.ItemsTypeID
);
}
);
if (index < 0)
{
lstNew.Add(var);
}
else
{
if (lstNew[index].Quantity < var.Quantity)
{
lstNew[index].Quantity = var.Quantity;
}
}
}
}
foreach (ATTInvItemsTransfered var in lstNew)
{
List <ATTInvItemsTransfered> objlst = LSTItemsTrans.FindAll(
delegate(ATTInvItemsTransfered obj)
{
return(var.OrgID == obj.OrgID &&
var.ItemsCategoryID == obj.ItemsCategoryID &&
var.ItemsSubCategoryID == obj.ItemsSubCategoryID &&
var.ItemsID == obj.ItemsID &&
var.ItemsTypeID == obj.ItemsTypeID
);
}
);
foreach (ATTInvItemsTransfered var1 in objlst)
{
var1.Quantity = var.Quantity;
}
}
Session["GrdData"] = lstNew;
Panel3.Visible = lstNew.Count > 0 ? true : false;
grdItemsTrans.DataSource = lstNew;
grdItemsTrans.DataBind();
grdItemsTrans.SelectedIndex = -1;
}
catch (Exception ex)
{
this.lblStatusMessage.Text = "Error:" + ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (ddlItemsType.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "समानको किसिम छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (this.txtReceivedDate.Text == "")
{
this.lblStatusMessage.Text = "बुझिलिएको मिति हाल्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
List <ATTInvItemsTransfered> lstNew = new List <ATTInvItemsTransfered>();
List <ATTInvItemsTransfered> lstItemsTransfKNJ = new List <ATTInvItemsTransfered>();
List <ATTInvItemsTransfered> lstItemsTransfKBJ = new List <ATTInvItemsTransfered>();
if (this.ddlItemsType.SelectedIndex == 2)
{
lstItemsTransfKNJ = (List <ATTInvItemsTransfered>)Session["ItemsTransfKNJ"];
}
else
{
lstItemsTransfKBJ = (List <ATTInvItemsTransfered>)Session["ItemsTransfKBJ"];
}
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
if (lstItemsTransfKNJ.Count > 0)
{
if (((CheckBox)grdItemsTransfRecv.HeaderRow.FindControl("chkAllItems")).Checked == true)
{
foreach (ATTInvItemsTransfered var in lstItemsTransfKNJ)
{
var.OrgID = var.OrgID;
var.ItemsCategoryID = var.ItemsCategoryID;
var.ItemsSubCategoryID = var.ItemsSubCategoryID;
var.ItemsID = var.ItemsID;
var.TransORG = var.TransORG;
var.TransSEQ = var.TransSEQ;
var.SeqNo = var.SeqNo;
// var.Quantity = var.Quantity;
var.DecisionDate = var.DecisionDate;
var.TransDate = var.TransDate;
var.TransVia = var.TransVia;
var.TransOrgUnit = var.TransOrgUnit;
var.TransTo = var.TransTo;
var.TransRecvDate = this.txtReceivedDate.Text.Trim();
var.TransRecvBy = user.OrgID;
var.ReturnBy = var.ReturnBy;
var.ReturnDate = var.ReturnDate;
var.ReturnVia = var.ReturnVia;
var.ReturnRecvBy = var.ReturnRecvBy;
var.ReturnRecvDate = var.ReturnRecvDate;
var.Action = "E";
}
if (BLLInvItemsTransfered.SaveItemsTransfer(lstItemsTransfKNJ, "receive"))
{
this.lblStatusMessage.Text = "Received Items Saved";
this.programmaticModalPopup.Show();
Session["ItemsTransfKNJ"] = null;
}
}
else
{
int count = 0;
foreach (GridViewRow row in grdItemsTransfRecv.Rows)
{
if (((CheckBox)row.FindControl("chkItems")).Checked == true)
{
ATTInvItemsTransfered obj = new ATTInvItemsTransfered();
obj.OrgID = int.Parse(row.Cells[1].Text);
obj.TransSEQ = int.Parse(row.Cells[2].Text);
obj.TransORG = int.Parse(row.Cells[3].Text);
obj.TransfOrgName = row.Cells[4].Text;
//obj.Quantity = int.Parse(row.Cells[5].Text);
obj.DecisionDate = row.Cells[6].Text;
obj.TransDate = row.Cells[7].Text;
obj.TransVia = int.Parse(row.Cells[8].Text);
obj.TransOrgUnit = int.Parse(row.Cells[9].Text);
obj.TransTo = int.Parse(row.Cells[10].Text);
obj.ItemsCategoryID = int.Parse(row.Cells[11].Text);
obj.ItemsCategoryName = row.Cells[12].Text;
obj.ItemsSubCategoryID = int.Parse(row.Cells[13].Text);
obj.ItemsSubCategoryName = row.Cells[14].Text;
obj.ItemsID = int.Parse(row.Cells[15].Text);
obj.ItemsName = row.Cells[16].Text;
obj.ItemsTypeID = int.Parse(row.Cells[17].Text);
obj.ItemsTypeName = row.Cells[18].Text;
obj.ItemsUnitID = int.Parse(row.Cells[19].Text);
obj.ItemsUnitName = row.Cells[20].Text;
obj.SeqNo = int.Parse(row.Cells[21].Text);
obj.TransRecvBy = user.OrgID;
obj.TransRecvDate = this.txtReceivedDate.Text.Trim();
obj.ReturnBy = null;
obj.ReturnDate = "";
obj.ReturnRecvDate = "";
obj.ReturnVia = null;
obj.Action = "E";
lstNew.Add(obj);
count++;
}
}
if (BLLInvItemsTransfered.SaveItemsTransfer(lstNew, "receive"))
{
this.lblStatusMessage.Text = "Received Items Saved";
this.programmaticModalPopup.Show();
Session["ItemsTransfKNJ"] = null;
}
}
}
else if (lstItemsTransfKBJ.Count > 0)
{
if (((CheckBox)grdItemsTransfRecv.HeaderRow.FindControl("chkAllItems")).Checked == true)
{
foreach (ATTInvItemsTransfered var in lstItemsTransfKBJ)
{
var.OrgID = var.OrgID;
var.ItemsCategoryID = var.ItemsCategoryID;
var.ItemsSubCategoryID = var.ItemsSubCategoryID;
var.ItemsID = var.ItemsID;
var.TransORG = var.TransORG;
var.TransSEQ = var.TransSEQ;
var.Quantity = var.Quantity;
var.DecisionDate = var.DecisionDate;
var.TransDate = var.TransDate;
var.TransVia = var.TransVia;
var.TransOrgUnit = var.TransOrgUnit;
var.TransTo = var.TransTo;
var.TransRecvDate = this.txtReceivedDate.Text.Trim();
var.TransRecvBy = user.OrgID;
var.ReturnBy = var.ReturnBy;
var.ReturnDate = var.ReturnDate;
var.ReturnVia = var.ReturnVia;
var.ReturnRecvBy = var.ReturnRecvBy;
var.ReturnRecvDate = var.ReturnRecvDate;
var.Action = "E";
}
if (BLLInvItemsTransfered.SaveItemsTransfer(lstItemsTransfKBJ, "receive"))
{
this.lblStatusMessage.Text = "Received Items Saved";
this.programmaticModalPopup.Show();
Session["ItemsTransfKBJ"] = null;
}
}
else
{
int count = 0;
foreach (GridViewRow row in grdItemsTransfRecv.Rows)
{
if (((CheckBox)row.FindControl("chkItems")).Checked == true)
{
ATTInvItemsTransfered obj = new ATTInvItemsTransfered();
obj.OrgID = int.Parse(row.Cells[1].Text);
obj.TransSEQ = int.Parse(row.Cells[2].Text);
obj.TransORG = int.Parse(row.Cells[3].Text);
obj.TransfOrgName = row.Cells[4].Text;
obj.Quantity = int.Parse(row.Cells[5].Text);
obj.DecisionDate = row.Cells[6].Text;
obj.TransDate = row.Cells[7].Text;
obj.TransVia = int.Parse(row.Cells[8].Text);
obj.TransOrgUnit = int.Parse(row.Cells[9].Text);
obj.TransTo = int.Parse(row.Cells[10].Text);
obj.ItemsCategoryID = int.Parse(row.Cells[11].Text);
obj.ItemsCategoryName = row.Cells[12].Text;
obj.ItemsSubCategoryID = int.Parse(row.Cells[13].Text);
obj.ItemsSubCategoryName = row.Cells[14].Text;
obj.ItemsID = int.Parse(row.Cells[15].Text);
obj.ItemsName = row.Cells[16].Text;
obj.ItemsTypeID = int.Parse(row.Cells[17].Text);
obj.ItemsTypeName = row.Cells[18].Text;
obj.ItemsUnitID = int.Parse(row.Cells[19].Text);
obj.ItemsUnitName = row.Cells[20].Text;
obj.TransRecvBy = user.OrgID;
obj.TransRecvDate = this.txtReceivedDate.Text.Trim();
obj.ReturnBy = null;
obj.ReturnDate = "";
obj.ReturnRecvDate = "";
obj.ReturnVia = null;
obj.Action = "E";
lstNew.Add(obj);
count++;
}
}
if (BLLInvItemsTransfered.SaveItemsTransfer(lstNew, "receive"))
{
this.lblStatusMessage.Text = "Received Items Saved";
this.programmaticModalPopup.Show();
Session["ItemsTransfKBJ"] = null;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
ClearControls();
}
