コード例 #1
0
 public mProduct fGetIns(mProduct pPrd)
 {
     try
     {
         var vPrd = (from p in Db.tbl_product
                     where p.product_id == pPrd.product_id
                     select new mProduct
         {
             product_id = p.product_id,
             product_img1 = p.product_img1,
             product_img2 = p.product_img2,
             product_img_alt = p.product_img_alt,
             product_price = p.product_price,
             product_summery = p.product_summery,
             product_title1 = p.product_title1,
             product_title2 = p.product_title2,
             product_cat = p.product_cat,
             product_parent = p.product_parent,
             product_exist = p.product_exist,
             product_exp = p.product_exp,
             product_visit = p.product_visit
         }).FirstOrDefault();
         return(vPrd);
     }
     catch (Exception)
     {
         return(null);
     }
 }
コード例 #2
0
 public bool InsertIns(mProduct pPrd)
 {
     try
     {
         tbl_product vPrd  = new tbl_product();
         var         query = from b in Db.tbl_product
                             orderby b.product_id descending
                             select b;
         vPrd = query.FirstOrDefault();
         tbl_product p   = new tbl_product();
         Random      rnd = new Random();
         p.product_img1    = pPrd.product_img1;
         p.product_img2    = pPrd.product_img2;
         p.product_img_alt = pPrd.product_img_alt;
         p.product_price   = pPrd.product_price;
         p.product_summery = pPrd.product_summery;
         p.product_title1  = pPrd.product_title1;
         p.product_title2  = pPrd.product_title2;
         p.product_cat     = pPrd.product_cat;
         p.product_parent  = pPrd.product_parent;
         p.product_exist   = pPrd.product_exist;
         p.product_exp     = pPrd.product_exp;
         p.product_save    = pPrd.product_save;
         p.product_visit   = 200;
         p.product_id      = vPrd.product_id + 1;
         Db.tbl_product.Add(p);
         return(Convert.ToBoolean(Db.SaveChanges()));
     }
     catch (Exception)
     {
         return(false);
     }
 }
コード例 #3
0
        protected void btnSubmit_OnClick(object sender, EventArgs e)
        {
            try
            {
                string        state;
                CustomProfile profile = CustomProfile.GetProfile();
                //if (checkduplicate() == "")
                //{
                iProductMasterClient productClient = new iProductMasterClient();
                mProduct             obj           = new mProduct();

                state = "Edit";
                obj   = productClient.GetmProductToUpdate(Convert.ToInt64(hdnprodID.Value), profile.DBConnection._constr);
                obj.LastModifiedBy   = profile.Personal.UserID.ToString();
                obj.LastModifiedDate = DateTime.Now;

                obj.ProductTypeID     = Convert.ToInt64(ddlProductType.SelectedItem.Value);
                obj.ProductCategoryID = Convert.ToInt64(ddlCategory.SelectedItem.Value);
                if (ddlSubCategory.SelectedIndex > 0)
                {
                    obj.ProductSubCategoryID = Convert.ToInt64(ddlSubCategory.SelectedItem.Value);
                }
                obj.ProductCode = txtProductCode.Text.ToString().Trim();
                obj.Name        = txtProductName.Text.ToString().Trim();
                obj.UOMID       = Convert.ToInt64(ddlUOM.SelectedItem.Value);
                if (txtPrincipalPrice.Text == "")
                {
                    txtPrincipalPrice.Text = "0";
                }
                obj.PrincipalPrice = Convert.ToDecimal(txtPrincipalPrice.Text);
                obj.Description    = txtPrdDesc.Text.ToString().Trim();

                obj.Installable = Convert.ToBoolean(0);

                hdnprodID.Value = productClient.FinalSaveProductDetailByProductID(obj, profile.DBConnection._constr).ToString();

                productClient.Close();

                GetIssueHead();

                this.ModelPopUp.Hide();
                //}
            }
            catch (System.Exception ex)
            {
                Login.Profile.ErrorHandling(ex, this, "PartIssueEntry", "ProductSave");
            }
            finally
            {
            }
        }
コード例 #4
0
        public ActionResult InsuranceGet(int pId = 0)
        {
            if (fUserControl() == 0)
            {
                ViewBag.Message = "شما وارد سایت نشده اید...";
                return(RedirectToAction("LoginForm", "Login"));
            }
            mProduct vProduct = new mProduct();

            if (pId > 0)
            {
                vProduct.product_id = pId;
                vProduct            = p.fGetIns(vProduct);
            }
            else
            {
                vProduct = new mProduct();
            }
            return(View("_Insurance", vProduct));
        }
コード例 #5
0
        public bool fUpdateIns(mProduct pPrd)
        {
            tbl_product p = new tbl_product();

            p.product_id      = pPrd.product_id;
            p.product_img1    = pPrd.product_img1;
            p.product_img2    = pPrd.product_img2;
            p.product_img_alt = pPrd.product_img_alt;
            p.product_price   = pPrd.product_price;
            p.product_summery = pPrd.product_summery;
            p.product_title1  = pPrd.product_title1;
            p.product_title2  = pPrd.product_title2;
            p.product_cat     = pPrd.product_cat;
            p.product_parent  = pPrd.product_parent;
            p.product_exist   = pPrd.product_exist;
            p.product_exp     = pPrd.product_exp;
            p.product_save    = pPrd.product_save;
            Db.tbl_product.Attach(p);
            Db.Entry(p).State = System.Data.Entity.EntityState.Modified;
            return(Convert.ToBoolean(Db.SaveChanges()));
        }
コード例 #6
0
        public ActionResult Insurance(int page)
        {
            mHome vHome = new mHome();
            mLink vLink = new mLink();

            vLink.link_status = 6;
            vLink.link_cat    = page;
            mProduct        vProduct = new mProduct();
            List <mArticle> aArticle = new List <mArticle>();
            mArticle        vArticle = new mArticle();

            List <mLink> aLinks = new List <mLink>();

            aLinks = l.fLinkList(12, 0, vLink);
            if (aLinks != null && aLinks.Count > 0)
            {
                vHome.aLink = aLinks;
            }
            else
            {
                vHome.aLink = new List <mLink>();
            }
            vArticle.article_type = 1;
            aArticle = a.fArticlesListMostVisited(10, 0, vArticle, vHome);
            if (aArticle != null && aArticle.Count > 0)
            {
                vHome.aArticles = aArticle;
            }
            else
            {
                vHome.aArticles = new List <mArticle>();
            }
            vProduct.product_id = page;
            vHome.Ins           = p.fGetInsCat(vProduct);
            if (vHome == null)
            {
                vHome = new mHome();
            }
            return(View(vHome));
        }
コード例 #7
0
 public ActionResult InsurancePost(mProduct pInsurance)
 {
     if (fUserControl() == 0)
     {
         ViewBag.Message = "شما وارد سایت نشده اید...";
         return(RedirectToAction("LoginForm", "Login"));
     }
     if (!(ModelState.IsValid))
     {
         ViewBag.error = "خطا در  اطلاعات ورودی !";
         return(View(pInsurance));
     }
     else
     {
         if (pInsurance.img_file1 != null && pInsurance.img_file1.ContentLength > 0)
         {
             if (pInsurance.img_file1.ContentLength < 10485760)
             {
                 Random rnd  = new Random();
                 string img  = rnd.Next().ToString() + ".jpg";
                 string Path = System.IO.Path.Combine(Server.MapPath("~/images/Product/"));
                 pInsurance.img_file1.SaveAs(Path + img);
                 using (MemoryStream ms = new MemoryStream())
                 {
                     pInsurance.img_file1.InputStream.CopyTo(ms);
                     byte[] array = ms.GetBuffer();
                     pInsurance.product_img1 = img;
                 }
             }
             else
             {
                 ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
                 return(View(pInsurance));
             }
         }
         if (pInsurance.img_file2 != null && pInsurance.img_file2.ContentLength > 0)
         {
             if (pInsurance.img_file2.ContentLength < 10485760)
             {
                 Random rnd  = new Random();
                 string img  = rnd.Next().ToString() + ".jpg";
                 string Path = System.IO.Path.Combine(Server.MapPath("~/images/Insurance/"));
                 pInsurance.img_file2.SaveAs(Path + img);
                 using (MemoryStream ms = new MemoryStream())
                 {
                     pInsurance.img_file2.InputStream.CopyTo(ms);
                     byte[] array = ms.GetBuffer();
                     pInsurance.product_img1 = img;
                 }
             }
             else
             {
                 ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
                 return(View(pInsurance));
             }
         }
         if (pInsurance.product_id > 0)
         {
             if (p.fUpdateIns(pInsurance))
             {
                 return(RedirectToAction("index"));
             }
             ViewBag.error = "خطا در انجام عملیات  ! ";
         }
         else
         {
             if (p.InsertIns(pInsurance))
             {
                 return(RedirectToAction("index"));
             }
             ViewBag.error = "خطا در انجام عملیات  ! ";
         }
     }
     return(View(pInsurance));
 }
コード例 #8
0
        protected void FinalSaveProductDetailByProductID()
        {
            try
            {
                string        state;
                CustomProfile profile = CustomProfile.GetProfile();
                if (checkDuplicate() == "")
                {
                    iProductMasterClient productClient = new iProductMasterClient();
                    mProduct             obj           = new mProduct();
                    if (hdnprodID.Value != "0")
                    {
                        state = "Edit";
                        obj   = productClient.GetmProductToUpdate(Convert.ToInt64(hdnprodID.Value), profile.DBConnection._constr);
                        obj.LastModifiedBy   = profile.Personal.UserID.ToString();
                        obj.LastModifiedDate = DateTime.Now;
                    }
                    else
                    {
                        state            = "AddNew";
                        obj.CreatedBy    = profile.Personal.UserID.ToString();
                        obj.CreationDate = DateTime.Now;
                    }

                    obj.ProductTypeID     = Convert.ToInt64(ddlProductType.SelectedItem.Value);
                    obj.ProductCategoryID = Convert.ToInt64(ddlCategory.SelectedItem.Value);
                    if (ddlSubCategory.SelectedIndex > 0)
                    {
                        obj.ProductSubCategoryID = Convert.ToInt64(ddlSubCategory.SelectedItem.Value);
                    }
                    obj.ProductCode = txtProductCode.Text.ToString().Trim();
                    obj.Name        = txtProductName.Text.ToString().Trim();
                    obj.UOMID       = Convert.ToInt64(ddlUOM.SelectedItem.Value);
                    if (txtPrincipalPrice.Text == "")
                    {
                        txtPrincipalPrice.Text = "0";
                    }
                    obj.PrincipalPrice = Convert.ToDecimal(txtPrincipalPrice.Text);

                    if (txtFixedDisc.Text == "")
                    {
                        txtFixedDisc.Text = "0";
                    }
                    obj.FixedDiscount = Convert.ToDecimal(txtFixedDisc.Text);

                    obj.FixedDiscountPercent = chkboxFixedDiscIsPercent.Checked;
                    obj.Installable          = chkProductSpe.Items[0].Selected;
                    obj.AMC = chkProductSpe.Items[1].Selected;
                    if (txtWarrenyInDays.Text == "")
                    {
                        txtWarrenyInDays.Text = "0";
                    }
                    obj.WarrantyDays = Convert.ToInt32(txtWarrenyInDays.Text);
                    if (txtGuaranteeInDays.Text == "")
                    {
                        txtGuaranteeInDays.Text = "0";
                    }
                    obj.GuaranteeDays = Convert.ToInt32(txtGuaranteeInDays.Text);
                    obj.Active        = "N";
                    if (rbtYes.Checked == true)
                    {
                        obj.Active = "Y";
                    }

                    hdnprodID.Value = productClient.FinalSaveProductDetailByProductID(obj, profile.DBConnection._constr).ToString();
                    productClient.FinalSaveProductTaxDetailByProductID(Session.SessionID, profile.Personal.UserID.ToString(), Convert.ToInt64(hdnprodID.Value), profile.DBConnection._constr);
                    productClient.FinalSaveProductImagesByProductID(Session.SessionID.ToString(), profile.Personal.UserID.ToString(), Convert.ToInt64(hdnprodID.Value), Server.MapPath(""), profile.DBConnection._constr);
                    productClient.FinalSaveProductSpecificationDetailByProductID(sessionID, profile.Personal.UserID.ToString(), Convert.ToInt64(hdnprodID.Value), Convert.ToInt64(profile.Personal.CompanyID), profile.DBConnection._constr);
                    productClient.FinalSaveProductInventory(sessionID, CurrentObject, Convert.ToInt64(hdnprodID.Value), Convert.ToDateTime(UC_EffectiveDateInventory.Date), profile.Personal.UserID.ToString(), profile.DBConnection._constr);
                    UC_AttachDocument1.FinalSaveDocument(Convert.ToInt64(hdnprodID.Value));
                    productClient.Close();
                    if (hdnprodID.Value != "0")
                    {
                        WebMsgBox.MsgBox.Show("Record saved sussessfully");
                    }
                    // clear();
                    GetProductDocumentByProductID();
                    GetProductSpecificationDetailByProductID();
                    GetProductTaxDetailByProductID();
                    GetProductImagesByProductID();
                    GetProductList();
                    GVRateHistory();
                    FillInventoryGrid();
                    setActiveTab(1);
                    clear();
                    //   changePrice1.Attributes.Add("style", "visibility:visible");
                }
            }
            catch (System.Exception ex)
            {
                Login.Profile.ErrorHandling(ex, this, "Product master", "pageSave");
            }
            finally
            {
            }
        }