Exemplo n.º 1
0
 /// <summary>
 /// Deprecated Method for adding a new object to the recsys_costs EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddTorecsys_costs(recsys_costs recsys_costs)
 {
     base.AddObject("recsys_costs", recsys_costs);
 }
Exemplo n.º 2
0
        public JsonResult CostBatchInsertProcess(FormCollection elements)
        {
            bool isSuccess = false;
            Dictionary<int, recsys_costs> insertItems = new Dictionary<int, recsys_costs>();
            List<string> validationControlSelectors = new List<string>();

            string relateIDString = elements["hfRelateID"];
            string relateTableString = elements["hfRelateTable"];
            string relateCenter = "68";

            //get relateCenter with relateIDString and relateTableString
            int relateID1 = Convert.ToInt32(relateIDString);
            if (relateTableString == "quotation")
            {
                var records = from q in this._db.recsys_quotation
                              join rc in this._db.recsys_relate_customers on q.customer_id equals rc.id into rcs
                              from rc in rcs.DefaultIfEmpty()
                              where q.id == relateID1
                              select
                              new
                              {
                                  relateCenter = rc.center
                              };
                var record = records.FirstOrDefault();
                relateCenter = record.relateCenter;
            }
            else
            {
                var records = from q in this._db.recsys_maintenance
                              join rc in this._db.recsys_relate_customers on q.customer_id equals rc.id into rcs
                              from rc in rcs.DefaultIfEmpty()
                              where q.id == relateID1
                              select
                              new
                              {
                                  relateCenter = rc.center
                              };
                var record = records.FirstOrDefault();
                relateCenter = record.relateCenter;
            }

            int relateID;

            if (int.TryParse(relateIDString, out relateID))
            {
                string[] isValidRecords = elements.GetValues("hfValid");
                string[] supplierSubConIDs = elements.GetValues("hfSupplierSubContractorID");
                string[] supplierSubConRoles = elements.GetValues("hfSupplierSubContractorRole");
                string[] workerIDs = elements.GetValues("hfWorkerID");
                //string[] centerNames = elements.GetValues("cbCenter");
                string[] categoryIDs = elements.GetValues("hfCategoryID");
                string[] invoiceDates = elements.GetValues("tbBillingDate");
                string[] prices = elements.GetValues("tbPrice");
                string[] invoiceNumbers = elements.GetValues("tbInvoice");
                string[] remarks = elements.GetValues("tbRemark");

                int itemsCount = isValidRecords.Count();

                for (int i = 0; i < itemsCount; i++)
                {
                    recsys_costs cost = new recsys_costs()
                    {
                        account_date = null,
                        center = "",
                        cost_id = null,
                        invoice = "",
                        last_update = DateTime.Now,
                        remark = "",
                        status = 0,
                        supplier_id = null,
                        update_user_id = 0,
                        user_id = null,
                        price1 = null,
                        price2 = null
                    };
                    //DateTime invoiceDate;
                    int categoryID;
                    double price;
                    int supplierID;
                    int subConID;
                    int workerID;
                    bool isValid;
                    Member member = new Member("users");

                    if (!string.IsNullOrEmpty(invoiceDates[i]))
                        cost.account_date = DateTime.ParseExact(invoiceDates[i], "dd-MM-yyyy", null);
                    /*if (DateTime.TryParse(invoiceDates[i], out invoiceDate))
                        cost.account_date = invoiceDate;*/
                        cost.center = relateCenter;
                    if (int.TryParse(categoryIDs[i], out categoryID))
                        cost.cost_id = categoryID;
                    cost.invoice = invoiceNumbers[i];
                    if (double.TryParse(prices[i], out price))
                        cost.price1 = price;
                    cost.remark = remarks[i];
                    if (bool.TryParse(isValidRecords[i], out isValid))
                    {
                        if (isValid)
                            cost.status = (int)RecordStatus.Active;
                        else
                            cost.status = (int)RecordStatus.InActive;
                    }
                    if (supplierSubConRoles[i] == ((int)SupplierSubConType.Supplier).ToString())
                    {
                        if (int.TryParse(supplierSubConIDs[i], out supplierID))
                            cost.supplier_id = supplierID;
                    }
                    else if (supplierSubConRoles[i] == ((int)SupplierSubConType.SubContractor).ToString())
                    {
                        if (int.TryParse(supplierSubConIDs[i], out subConID))
                            cost.user_id = subConID;
                    }
                    if (int.TryParse(workerIDs[i], out workerID))
                        cost.user_id = workerID;
                    cost.update_user_id = (int)member.infoBySession("id");

                    if (cost.user_id > 0 || cost.supplier_id > 0 || cost.cost_id > 0)
                        insertItems.Add(i, cost);
                }

                //# Validation
                foreach (KeyValuePair<int, recsys_costs> kvp in insertItems)
                {
                    if (!kvp.Value.cost_id.HasValue)
                        validationControlSelectors.Add("#cost_custom_insert_form .tbCategory:eq(" + kvp.Key + ")");
                }
                if (validationControlSelectors.Count > 0)
                {
                    return Json(new
                    {
                        bIsSuccess = false,
                        exception = new ValidationException("無效的Category", validationControlSelectors.ToArray())
                    });
                }

                if (insertItems.Count > 0)
                {
                    List<recsys_costs> items = new List<recsys_costs>();

                    foreach (KeyValuePair<int, recsys_costs> kvp in insertItems)
                    {
                        items.Add(kvp.Value);
                        this._db.recsys_costs.AddObject(kvp.Value);
                    }

                    try
                    {
                        int number = this._db.SaveChanges();

                        this._db.Refresh(RefreshMode.StoreWins, items);

                        foreach (recsys_costs item in items)
                        {
                            recsys_relate relation = new recsys_relate();
                            relation.table1 = "costs";
                            relation.table2 = relateTableString;
                            relation.id1 = item.id;
                            relation.id2 = relateID;

                            this._db.recsys_relate.AddObject(relation);
                        }

                        this._db.SaveChanges();

                        isSuccess = true;

                    }
                    catch (OptimisticConcurrencyException)
                    {
                        //# log down
                    }
                }

            }

            return Json(new
            {
                bIsSuccess = isSuccess
            });
        }
Exemplo n.º 3
0
 /// <summary>
 /// Create a new recsys_costs object.
 /// </summary>
 /// <param name="id">Initial value of the id property.</param>
 /// <param name="status">Initial value of the status property.</param>
 public static recsys_costs Createrecsys_costs(global::System.Int32 id, global::System.Byte status)
 {
     recsys_costs recsys_costs = new recsys_costs();
     recsys_costs.id = id;
     recsys_costs.status = status;
     return recsys_costs;
 }