コード例 #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            DIA_JangadItem dIA_JangadItem = db.DIA_JangadItem.Find(id);

            db.DIA_JangadItem.Remove(dIA_JangadItem);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #2
0
        // GET: DIA_JangadItem/Create
        public ActionResult Create()
        {
            ViewBag.CassettsID       = new SelectList(db.DIA_Cassett, "CassettsID", "Remarks");
            ViewBag.JangadID         = new SelectList(db.DIA_Jangad, "JangadID", "Remarks");
            ViewBag.PolishingStageID = new SelectList(db.SYS_PolishingStage, "PolishingStageID", "SatgeName");
            ViewBag.StatusID         = new SelectList(db.SYS_Status, "StatusID", "StatusName");
            ViewBag.UserID           = new SelectList(db.SEC_User, "UserID", "UserName");
            DIA_JangadItem _dIA_JangadItem = new DIA_JangadItem();

            return(View("Edit", _dIA_JangadItem));
        }
コード例 #3
0
        // GET: DIA_JangadItem/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DIA_JangadItem dIA_JangadItem = db.DIA_JangadItem.Find(id);

            if (dIA_JangadItem == null)
            {
                return(HttpNotFound());
            }
            return(View(dIA_JangadItem));
        }
コード例 #4
0
        // GET: DIA_JangadItem/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DIA_JangadItem dIA_JangadItem = db.DIA_JangadItem.Find(id);

            if (dIA_JangadItem == null)
            {
                return(HttpNotFound());
            }
            ViewBag.CassettsID       = new SelectList(db.DIA_Cassett, "CassettsID", "Remarks", dIA_JangadItem.CassettsID);
            ViewBag.JangadID         = new SelectList(db.DIA_Jangad, "JangadID", "Remarks", dIA_JangadItem.JangadID);
            ViewBag.PolishingStageID = new SelectList(db.SYS_PolishingStage, "PolishingStageID", "SatgeName", dIA_JangadItem.PolishingStageID);
            ViewBag.StatusID         = new SelectList(db.SYS_Status, "StatusID", "StatusName", dIA_JangadItem.StatusID);
            ViewBag.UserID           = new SelectList(db.SEC_User, "UserID", "UserName", dIA_JangadItem.UserID);
            return(View(dIA_JangadItem));
        }
コード例 #5
0
        public ActionResult Create([Bind(Include = "JangadItemID,JangadID,Weight,Size,PavalionAngle,CrownAngle,CrownWeight,Girdle,Para1,Para2,Para3,CassettsID,PolishingStageID,PavalionORCrown,UserID,StatusID,QCRemarks,Created,Completed,Remarks,PhysicalReceived,PhysicalReceivedDateTime,PhysicalSend,PhysicalSendDateTime,Delivered,DeliveredDateTime")] DIA_JangadItem dIA_JangadItem)
        {
            if (ModelState.IsValid)
            {
                dIA_JangadItem.Created = DateTime.Now;
                if (Session["UserID"] != null)
                {
                    dIA_JangadItem.UserID = Convert.ToInt16(Session["UserID"].ToString());
                }
                db.DIA_JangadItem.Add(dIA_JangadItem);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.CassettsID       = new SelectList(db.DIA_Cassett, "CassettsID", "Remarks", dIA_JangadItem.CassettsID);
            ViewBag.JangadID         = new SelectList(db.DIA_Jangad, "JangadID", "Remarks", dIA_JangadItem.JangadID);
            ViewBag.PolishingStageID = new SelectList(db.SYS_PolishingStage, "PolishingStageID", "SatgeName", dIA_JangadItem.PolishingStageID);
            ViewBag.StatusID         = new SelectList(db.SYS_Status, "StatusID", "StatusName", dIA_JangadItem.StatusID);
            ViewBag.UserID           = new SelectList(db.SEC_User, "UserID", "UserName", dIA_JangadItem.UserID);
            return(View(dIA_JangadItem));
        }
コード例 #6
0
        public ActionResult Forward([Bind(Include = "JangadItemID,PolishingStageID")] DIA_JangadItem dIA_JangadItem)
        {
            DIA_JangadItem _OldDIA_JangadItem = db.DIA_JangadItem.Find(dIA_JangadItem.JangadItemID);

            _OldDIA_JangadItem.PolishingStageID = dIA_JangadItem.PolishingStageID;
            if (ModelState.IsValid)
            {
                db.Entry(_OldDIA_JangadItem).State = EntityState.Modified;
                if (Session["UserID"] != null)
                {
                    _OldDIA_JangadItem.UserID = Convert.ToInt16(Session["UserID"].ToString());
                }
                //dIA_JangadItem.PolishingStageID = 1;
                _OldDIA_JangadItem.StatusID = 1;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            ViewBag.CassettsID       = new SelectList(db.DIA_Cassett, "CassettsID", "Remarks", dIA_JangadItem.CassettsID);
            ViewBag.JangadID         = new SelectList(db.DIA_Jangad, "JangadID", "Remarks", dIA_JangadItem.JangadID);
            ViewBag.PolishingStageID = new SelectList(db.SYS_PolishingStage, "PolishingStageID", "SatgeName", dIA_JangadItem.PolishingStageID);
            ViewBag.StatusID         = new SelectList(db.SYS_Status, "StatusID", "StatusName", dIA_JangadItem.StatusID);
            ViewBag.UserID           = new SelectList(db.SEC_User, "UserID", "UserName", dIA_JangadItem.UserID);
            return(View(dIA_JangadItem));
        }
コード例 #7
0
        public JsonResult AddJangad(DIA_JangadViewModal dIA_JangadViewModal)
        {
            try
            {
                if (dIA_JangadViewModal == null)
                {
                    //error meesage or expception handle
                }
                else if (dIA_JangadViewModal.DIA_JangadItems == null)
                {
                    //error meesage or expception handle
                }
                else
                {
                    if (Session["UserID"] != null)
                    {
                        dIA_JangadViewModal.UserID = Convert.ToInt16(Session["UserID"].ToString());
                    }
                    //dIA_JangadViewModal;
                    if (dIA_JangadViewModal.JangadID > 0)
                    {
                        //edit time logic
                    }
                    else
                    {
                        DIA_Jangad new_DIA_Jangad = new DIA_Jangad();
                        new_DIA_Jangad.CompanyID     = CommonConfig.GetCompanyID();
                        new_DIA_Jangad.PartyID       = dIA_JangadViewModal.PartyID;
                        new_DIA_Jangad.Weight        = dIA_JangadViewModal.Weight;
                        new_DIA_Jangad.StatusID      = 1;                        //ask to kamal
                        new_DIA_Jangad.UserID        = dIA_JangadViewModal.UserID;
                        new_DIA_Jangad.Amount        = 0;                        //dIA_JangadViewModal.Amount;
                        new_DIA_Jangad.RecivedAmount = 0;                        //dIA_JangadViewModal.RecivedAmount;

                        new_DIA_Jangad.JangadNo = dIA_JangadViewModal.JangadNo;; //ask to kamal
                        new_DIA_Jangad.Created  = DateTime.Now;
                        new_DIA_Jangad.Modified = DateTime.Now;
                        new_DIA_Jangad.Remarks  = dIA_JangadViewModal.Remarks;

                        new_DIA_Jangad.PricePerCarat = dIA_JangadViewModal.PricePerCarat;
                        new_DIA_Jangad.FinYearID     = CommonConfig.GetFinYearID();
                        new_DIA_Jangad.CGSTAmount    = dIA_JangadViewModal.CGSTAmount;
                        new_DIA_Jangad.SGSTAmount    = dIA_JangadViewModal.SGSTAmount;
                        new_DIA_Jangad.IGSTAmount    = dIA_JangadViewModal.IGSTAmount;
                        new_DIA_Jangad.TDSAmount     = dIA_JangadViewModal.TDSAmount;
                        new_DIA_Jangad.IsActive      = true;

                        if (dIA_JangadViewModal.CGST > 0)
                        {
                            new_DIA_Jangad.CGST = dIA_JangadViewModal.CGST;
                        }
                        else
                        {
                            new_DIA_Jangad.CGST = null;
                        }

                        if (dIA_JangadViewModal.SGST > 0)
                        {
                            new_DIA_Jangad.SGST = dIA_JangadViewModal.SGST;
                        }
                        else
                        {
                            new_DIA_Jangad.SGST = null;
                        }

                        if (dIA_JangadViewModal.IGST > 0)
                        {
                            new_DIA_Jangad.IGST = dIA_JangadViewModal.IGST;
                        }
                        else
                        {
                            new_DIA_Jangad.IGST = null;
                        }

                        if (dIA_JangadViewModal.TDS > 0)
                        {
                            new_DIA_Jangad.TDS = dIA_JangadViewModal.TDS;
                        }
                        else
                        {
                            new_DIA_Jangad.TDS = null;
                        }

                        new_DIA_Jangad.IsLocal = dIA_JangadViewModal.IsLocal;
                        new_DIA_Jangad.Casar   = 0;//ask to kamal
                        //start default value set
                        new_DIA_Jangad.Quantity      = dIA_JangadViewModal.Quantity;
                        new_DIA_Jangad.PricePerCarat = 0;
                        new_DIA_Jangad.QTYByThan     = 0;
                        new_DIA_Jangad.Rate          = 0;
                        //end
                        if (dIA_JangadViewModal.IsRatePerCarat == true)
                        {
                            new_DIA_Jangad.IsRatePerCarat = dIA_JangadViewModal.IsRatePerCarat;
                            new_DIA_Jangad.Quantity       = dIA_JangadViewModal.Quantity;      //ask to kamal
                            new_DIA_Jangad.PricePerCarat  = dIA_JangadViewModal.PricePerCarat; //ask to kamal
                            new_DIA_Jangad.TotalAmount    = dIA_JangadViewModal.TotalAmount;
                            new_DIA_Jangad.PendingAmount  = Convert.ToInt32(dIA_JangadViewModal.TotalAmount);
                        }
                        if (dIA_JangadViewModal.IsRatePerThan == true)
                        {
                            new_DIA_Jangad.IsRatePerThan = dIA_JangadViewModal.IsRatePerThan;
                            new_DIA_Jangad.QTYByThan     = dIA_JangadViewModal.QTYByThan;//ask to kamal
                            new_DIA_Jangad.Rate          = dIA_JangadViewModal.Rate;
                            new_DIA_Jangad.TotalAmount   = dIA_JangadViewModal.TotalAmount;
                            new_DIA_Jangad.PendingAmount = Convert.ToInt32(dIA_JangadViewModal.TotalAmount);
                        }
                        #region Generate InvoiceNo
                        String _NewJangadCode = CommonConfig.GetNextNumber("JN");
                        #endregion Generate InvoiceNo
                        new_DIA_Jangad.JangadCode = _NewJangadCode;

                        db.DIA_Jangad.Add(new_DIA_Jangad);
                        db.SaveChanges();

                        if (dIA_JangadViewModal.DIA_JangadItems.Count() > 0)
                        {
                            List <DIA_JangadItem> newList_DIA_JangadItems = new List <DIA_JangadItem>();
                            DIA_JangadItem        new_DIA_JangadItem;
                            foreach (var item in dIA_JangadViewModal.DIA_JangadItems)
                            {
                                new_DIA_JangadItem                 = new DIA_JangadItem();
                                new_DIA_JangadItem.JangadID        = new_DIA_Jangad.JangadID;
                                new_DIA_JangadItem.Weight          = item.Weight;
                                new_DIA_JangadItem.Dia             = item.Dia;
                                new_DIA_JangadItem.PavalionAngle   = item.PavalionAngle;
                                new_DIA_JangadItem.CrownAngle      = item.CrownAngle;
                                new_DIA_JangadItem.CrownHeight     = item.CrownHeight;
                                new_DIA_JangadItem.Girdle          = item.Girdle;
                                new_DIA_JangadItem.Para1           = item.Para1;
                                new_DIA_JangadItem.Para2           = item.Para2;
                                new_DIA_JangadItem.Para3           = item.Para3;
                                new_DIA_JangadItem.PavalionORCrown = "1";//ask to kamal
                                new_DIA_JangadItem.UserID          = dIA_JangadViewModal.UserID;
                                new_DIA_JangadItem.StatusID        = CommonConfig.GetStatusPending();
                                new_DIA_JangadItem.Created         = DateTime.Now;
                                new_DIA_JangadItem.Remarks         = item.Remarks;
                                new_DIA_JangadItem.RWeight         = item.RWeight;
                                new_DIA_JangadItem.PWeight         = item.PWeight;
                                new_DIA_JangadItem.Culet           = item.Culet;          //ask to kamal
                                new_DIA_JangadItem.ji_table        = item.ji_table;       //ask to kamal
                                new_DIA_JangadItem.JangadItemCode  = item.JangadItemCode; //ask to kamal

                                new_DIA_JangadItem.PolishingStageID = 1;                  //Jangad Fresh
                                newList_DIA_JangadItems.Add(new_DIA_JangadItem);
                            }
                            db.DIA_JangadItem.AddRange(newList_DIA_JangadItems);
                            db.SaveChanges();
                        }
                    }
                }
                return(Json("Sucess", JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
            }
            return(Json("failure", JsonRequestBehavior.AllowGet));
        }
コード例 #8
0
        public JsonResult UploadCollectionFile()
        {
            var tempobj = new List <object>();

            try
            {
                if (Request.Files.Count > 0)
                {
                    HttpFileCollectionBase file = Request.Files;
                    if (file != null)
                    {
                        var filecount = file.Count;

                        for (int f = 0; f < filecount; f++)
                        {
                            if ((file != null) && (file.Count > 0))
                            {
                                byte[] fileBytes  = new byte[Request.Files[f].ContentLength];
                                var    fileBytess = new byte[Request.Files[f].ContentLength];
                                var    data       = Request.Files[f].InputStream.Read(fileBytess, 0, fileBytess.Length);

                                #region Directory
                                string subPath = "~/Upload/Jangad"; // your code goes here
                                bool   exists  = System.IO.Directory.Exists(Server.MapPath(subPath));
                                if (!exists)
                                {
                                    System.IO.Directory.CreateDirectory(Server.MapPath(subPath));
                                }
                                string pathtosave = Server.MapPath(subPath) + "\\" + file[f].FileName;
                                file[f].SaveAs(pathtosave);
                                #endregion Directory

                                string text1 = System.IO.File.ReadAllText(pathtosave);
                                text1.Replace(System.Environment.NewLine, string.Empty);
                                string[]       split             = text1.Split('\t');
                                DIA_JangadItem newDIA_JangadItem = new DIA_JangadItem();
                                newDIA_JangadItem.Dia           = Convert.ToDecimal(split[5]);
                                newDIA_JangadItem.RWeight       = Convert.ToDecimal(split[3]);
                                newDIA_JangadItem.PWeight       = Convert.ToDecimal(split[4]);
                                newDIA_JangadItem.PavalionAngle = Convert.ToDecimal(split[6]);
                                newDIA_JangadItem.CrownAngle    = Convert.ToDecimal(split[7]);
                                newDIA_JangadItem.CrownHeight   = Convert.ToDecimal(split[8]);
                                split[9] = split[9].Replace("M: ", "");
                                newDIA_JangadItem.Girdle         = Convert.ToDecimal(split[9]);
                                newDIA_JangadItem.Culet          = Convert.ToDecimal(split[10]);
                                newDIA_JangadItem.ji_table       = Convert.ToDecimal(split[11]);
                                newDIA_JangadItem.JangadItemCode = Request.Files[f].FileName;
                                ListDIA_JangadViewModal.DIA_JangadItems.Add(newDIA_JangadItem);
                            }
                        }

                        ViewData["UploadData"] = ListDIA_JangadViewModal;
                        return(Json(ListDIA_JangadViewModal, JsonRequestBehavior.AllowGet));
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(Json("", JsonRequestBehavior.AllowGet));
        }
コード例 #9
0
        // GET: DIA_JangadItem/Edit/5
        public ActionResult ABC()
        {
            DIA_JangadItem dIA_JangadItem = new DIA_JangadItem();

            return(View(dIA_JangadItem));
        }