Example #1
0
 public static List <ATTInvItemsWriteOffDT> GetWriteOffDetailsDT(string MinahaDate)
 {
     try
     {
         List <ATTInvItemsWriteOffDT> LSTItemsKNJ = new List <ATTInvItemsWriteOffDT>();
         foreach (DataRow row in DLLInvItemsWriteOffDT.GetWriteOffDetailsDT(MinahaDate).Rows)
         {
             ATTInvItemsWriteOffDT obj = new ATTInvItemsWriteOffDT();
             obj.OrgID        = int.Parse(row["ORG_ID"].ToString());
             obj.OrgName      = row["ORG_NAME"].ToString();
             obj.WriteOffSEQ  = int.Parse(row["WRITEOFF_SEQ"].ToString());
             obj.WriteOffDate = row["WRITEOFF_DATE"].ToString();
             if (obj.AppBy != 0)
             {
                 obj.AppBy = int.Parse(row["APP_BY"].ToString());
             }
             obj.FirstName = row["APP_PERSON"].ToString();
             //obj.MiddleName = row["MID_NAME"].ToString();
             //obj.LastName = row["SUR_NAME"].ToString();
             obj.AppDate              = row["APP_DATE"].ToString();
             obj.AppYesNo             = row["APP_YES_NO"].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.SeqNo        = int.Parse(row["SEQ_NO"].ToString());
             obj.ItemsName    = row["ITEMS_NAME"].ToString();
             obj.JI_KHA_PA_NO = row["JI_KHA_PA_NO"].ToString();
             obj.UnitPrice    = int.Parse(row["UNIT_PRICE"].ToString());
             obj.ItemsStatus  = row["ITEMS_STATUS"].ToString();
             obj.Remarks      = row["REMARKS"].ToString();
             LSTItemsKNJ.Add(obj);
         }
         return(LSTItemsKNJ);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #2
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (this.ddlItemCategory.SelectedIndex == -1)
        {
            this.lblStatusMessage.Text = "Please select Item Name Name.";
            this.programmaticModalPopup.Show();
            this.lblStatus.Focus();
            return;
        }
        if (this.ddlItemSubCategory.SelectedIndex == 0)
        {
            this.lblStatusMessage.Text = "Please select Iten Category Name.";
            this.programmaticModalPopup.Show();
            this.lblStatus.Focus();
            return;
        }
        if (this.ddlItem.SelectedIndex == 0)
        {
            this.lblStatusMessage.Text = "Please select the Item Name.";
            this.programmaticModalPopup.Show();
            this.lblStatus.Focus();
            return;
        }

        if (this.txtRemarks.Text == "")
        {
            this.lblStatusMessage.Text = "Please Enter Remarks.";
            this.programmaticModalPopup.Show();
            this.lblStatus.Focus();
            return;
        }

        ATTInvItemsWriteOff obj = (ATTInvItemsWriteOff)Session["ItemsWriteOff"];

        //List<ATTInvItemsWriteOff> lstItemsWriteOff = (List<ATTInvItemsWriteOff>)Session["ItemsWriteOff"];

        if (grdMinahaList.SelectedIndex > -1)
        {
            List <ATTInvOrgItemsKNJ> LSTSeq = (List <ATTInvOrgItemsKNJ>)Session["Items"];// how to get seq no it comes from DLLInvOrgItemsKNJ

            obj.LstItemsWriteOffDT[grdMinahaList.SelectedIndex].ItemsCategoryID    = int.Parse(ddlItemCategory.SelectedValue);
            obj.LstItemsWriteOffDT[grdMinahaList.SelectedIndex].ItemsSubCategoryID = int.Parse(ddlItemSubCategory.SelectedValue);
            obj.LstItemsWriteOffDT[grdMinahaList.SelectedIndex].ItemsID            = LSTSeq[ddlItem.SelectedIndex - 1].ItemsID;
            obj.LstItemsWriteOffDT[grdMinahaList.SelectedIndex].Remarks            = txtRemarks.Text;
            obj.LstItemsWriteOffDT[grdMinahaList.SelectedIndex].Action             = (obj.LstItemsWriteOffDT[grdMinahaList.SelectedIndex].Action == "A" ? "A" : "E");
        }
        else
        {
            //List<ATTInvOrgItemsKNJ> LSTAucItems = (List<ATTInvOrgItemsKNJ>)Session["Items"];
            //int itemID = LSTAucItems[this.ddlItem.SelectedIndex - 1].ItemsID;
            List <ATTInvOrgItemsKNJ> LSTSeq = (List <ATTInvOrgItemsKNJ>)Session["Items"];
            ATTInvItemsWriteOffDT    ob     = new ATTInvItemsWriteOffDT();
            int itemid = LSTSeq[ddlItem.SelectedIndex - 1].ItemsID;

            foreach (GridViewRow row in this.grdMinahaList.Rows)
            {
                if (int.Parse(row.Cells[4].Text) == itemid)
                {
                    this.lblStatusMessage.Text = "**सामान पहिले नै उपलब्द छ";
                    this.programmaticModalPopup.Show();
                    return;
                }
            }

            ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);

            //ATTInvItemsWriteOffDT ob = new ATTInvItemsWriteOffDT();

            ob.OrgID              = user.OrgID;
            ob.ItemsCategoryID    = int.Parse(ddlItemCategory.SelectedValue);
            ob.ItemsSubCategoryID = int.Parse(ddlItemSubCategory.SelectedValue);
            //get ItemID from session
            // List<ATTInvOrgItemsKNJ> LSTSeq = (List<ATTInvOrgItemsKNJ>)Session["Items"];// get ItemID from session -- (DLLInvOrgItemsKNJ)
            ob.ItemsID = itemid;

            ob.SeqNo   = LSTSeq[ddlItem.SelectedIndex - 1].KNJSeq;
            ob.Remarks = txtRemarks.Text;
            ob.Action  = "A";
            obj.LstItemsWriteOffDT.Add(ob);
            this.grdMinahaList.SelectedIndex      = -1;
            this.ddlItemCategory.SelectedIndex    = 0;
            this.ddlItemSubCategory.SelectedIndex = 0;
            this.ddlItem.SelectedIndex            = 0;
            this.txtRemarks.Text = "";
        }
        this.grdMinahaList.DataSource = obj.LstItemsWriteOffDT;
        this.grdMinahaList.DataBind();
        this.grdMinahaList.SelectedIndex      = -1;
        this.txtRemarks.Text                  = "";
        this.ddlItemCategory.SelectedIndex    = 0;
        this.ddlItemSubCategory.SelectedIndex = 0;
        this.ddlItem.SelectedIndex            = 0;
    }