public ActionResult CloneQuotationPackages(int? id)
        {
            //# validation
            if (!id.HasValue)
                return Json(new { bIsSuccessful = false });

            bool isSuccessful = true;
            Member member = new Member("users");
            int newQuotationPackageID = 0;
            string newCode = "";
            string message = "複製失敗!請重試";

            try
            {
                //# get existing quotation package
                recsys_quotation_packages existingQuotationPackage = this._db.recsys_quotation_packages.FirstOrDefault(theQuotationPackage => theQuotationPackage.id == id.Value);
                if (existingQuotationPackage != null)
                {

                    //# get existing quotation package items
                    IEnumerable<recsys_quotation_package_items> existingQuotationPackageItems = (from qpi in this._db.recsys_quotation_package_items
                                                                                                 where qpi.quotation_package_id == id && qpi.status == 1
                                                                                                 orderby qpi.nSequence
                                                                                                 select qpi).ToList();
                    //# check repeated quotation package code
                    newCode = existingQuotationPackage.code + " (Copy)";

                    var quotationPackages = from qp in this._db.recsys_quotation_packages
                                            where qp.status == 1
                                            select qp;

                    foreach (recsys_quotation_packages quotationPackage in quotationPackages)
                    {
                        if (newCode.Trim().ToUpper() == quotationPackage.code.Trim().ToUpper())
                        {
                            message = "已有Quotation Package (" + newCode + ")";

                            return Json(
                                new
                                {
                                    bIsSuccessful = false,
                                    message = message
                                });
                        }
                    }

                    //# construct new quotation package
                    recsys_quotation_packages newQuotationPackage = new recsys_quotation_packages();

                    newQuotationPackage.package_name = existingQuotationPackage.package_name;
                    newQuotationPackage.code = newCode;
                    newQuotationPackage.remark = existingQuotationPackage.remark;
                    newQuotationPackage.price = existingQuotationPackage.price;
                    newQuotationPackage.status = 1;
                    newQuotationPackage.create_date = DateTime.Now;
                    newQuotationPackage.update_date = DateTime.Now;
                    newQuotationPackage.create_by = (int)member.infoBySession("id");
                    newQuotationPackage.update_by = (int)member.infoBySession("id");
                    newQuotationPackage.district_id = existingQuotationPackage.district_id;
                    newQuotationPackage.customer_type = existingQuotationPackage.customer_type;

                    this._db.recsys_quotation_packages.AddObject(newQuotationPackage);

                    //# save quotation package
                    this._db.SaveChanges();

                    //# load new quotation package
                    this._db.Refresh(RefreshMode.StoreWins, newQuotationPackage);

                    newQuotationPackageID = newQuotationPackage.id;

                    //# construct new quotation package items
                    recsys_quotation_package_items[] newQuotationPackageItems = existingQuotationPackageItems.Select(theItem => QuotationPackagesController.CopyQuotationPackageItem(theItem)).ToArray();

                    foreach (recsys_quotation_package_items item in newQuotationPackageItems)
                    {
                        item.quotation_package_id = newQuotationPackageID;
                        this._db.recsys_quotation_package_items.AddObject(item);
                    }

                    //# save data
                    this._db.SaveChanges();

                    //# load new items
                    this._db.Refresh(RefreshMode.StoreWins, newQuotationPackageItems);
                }

                //# clone quotation package
                //# save changes
            }
            catch (OptimisticConcurrencyException)
            {
                //# log down
            }

            return Json(new { bIsSuccessful = isSuccessful, newCode = newCode, newQuotationPackageID = newQuotationPackageID, message = message });
        }
Пример #2
0
 /// <summary>
 /// Create a new recsys_quotation_packages object.
 /// </summary>
 /// <param name="id">Initial value of the id property.</param>
 /// <param name="package_name">Initial value of the package_name property.</param>
 /// <param name="code">Initial value of the code property.</param>
 /// <param name="status">Initial value of the status property.</param>
 /// <param name="create_date">Initial value of the create_date property.</param>
 /// <param name="create_by">Initial value of the create_by property.</param>
 public static recsys_quotation_packages Createrecsys_quotation_packages(global::System.Int32 id, global::System.String package_name, global::System.String code, global::System.Byte status, global::System.DateTime create_date, global::System.Int32 create_by)
 {
     recsys_quotation_packages recsys_quotation_packages = new recsys_quotation_packages();
     recsys_quotation_packages.id = id;
     recsys_quotation_packages.package_name = package_name;
     recsys_quotation_packages.code = code;
     recsys_quotation_packages.status = status;
     recsys_quotation_packages.create_date = create_date;
     recsys_quotation_packages.create_by = create_by;
     return recsys_quotation_packages;
 }
        public ActionResult DetailsAdd(recsys_quotation_packages data)
        {
            bool isSuccess = false;
            int id = 0;
            Member member = new Member("users");

            data.status = 1;
            data.create_date = DateTime.Now;
            data.create_by = (int)member.infoBySession("id");
            data.update_date = DateTime.Now;
            data.update_by = (int)member.infoBySession("id");

            data.code = data.code.Trim();

            if (data.package_name == null)
                data.package_name = "";
            else
                data.package_name = data.package_name.Trim();

            if (data.remark != null)
                data.remark = data.remark.Trim();

            if (data.price == null)
                data.price = 0.0;

            var quotationPackages = from qp in this._db.recsys_quotation_packages
                                    where qp.status == 1
                                    select qp;

            foreach (recsys_quotation_packages quotationPackage in quotationPackages)
            {
                if (!string.IsNullOrEmpty(data.code) && data.code.Trim().ToUpper() == quotationPackage.code.Trim().ToUpper())
                {
                    string message = "已有Quotation Package (" + data.code.Trim().ToUpper() + ")";

                    return Json(
                        new
                        {
                            isSuccess = isSuccess,
                            message = message
                        }, JsonRequestBehavior.AllowGet);
                }
            }

            this._db.recsys_quotation_packages.AddObject(data);

            try
            {
                this._db.SaveChanges();
                id = data.id;
                isSuccess = true;
            }
            catch (OptimisticConcurrencyException)
            {
                //# log down
            }

              //  return Content(Common.json_encode(true));
            return Json(
                new
                {
                    isSuccess = isSuccess,
                    newid = id
                }, JsonRequestBehavior.AllowGet);
        }
Пример #4
0
 /// <summary>
 /// Deprecated Method for adding a new object to the recsys_quotation_packages EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddTorecsys_quotation_packages(recsys_quotation_packages recsys_quotation_packages)
 {
     base.AddObject("recsys_quotation_packages", recsys_quotation_packages);
 }