예제 #1
0
        public static bool Insert_DOMaster(VehicleDeliveryMasterVM model, string dealerCode)
        {
            try
            {
                if (model.DeliveryNo == "" || model.DeliveryNo == null)
                {
                    strAutoCode = sysfun.AutoGen("VehicleDeliveryMaster", "DeliveryNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
                }
                else
                {
                    strAutoCode = model.DeliveryNo;
                }
                SqlParameter[] param =
                {
                    new SqlParameter("@DealerCode", dealerCode),                                      //0
                    new SqlParameter("@DeliveryNo", strAutoCode),                                     //1
                    new SqlParameter("@DeliveryDate", sysfun.SaveDate(model.DeliveryDate)),           //2
                    new SqlParameter("@BookRefNo", model.BookRefNo),                                  //3
                    new SqlParameter("@UpdUser", AuthBase.UserId),                                    //4
                    new SqlParameter("@UpdTerm", General.CurrentIP),                                  //5
                    new SqlParameter("@Type", model.Type),                                            //6
                    new SqlParameter("@ReceiverCode", model.ReceiverCode),                            //7
                    new SqlParameter("@Remarks", model.Remarks),                                      //8
                    new SqlParameter("@Segment", model.Segment),                                      //9
                    new SqlParameter("@Usage", model.Usage),                                          //10
                    new SqlParameter("@CusCode", model.CusCode),                                      //11
                    new SqlParameter("@VehTypeCode", model.VehTypeCode),                              //12
                    new SqlParameter("@CusContNo", model.CusContNo),                                  //13
                    new SqlParameter("@EmpCode", model.EmpCode)
                };

                if (ObjTrans.BeginTransaction(ref Trans) == true)
                {
                    sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param, Trans);


                    IsSaved = true;
                }

                //if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param))
                //{

                //    IsSaved = true;

                //}
            }
            catch (Exception)
            {
                //ObjTrans.RollBackTransaction(ref Trans);
                throw;
            }

            return(IsSaved);
        }
예제 #2
0
        public JsonResult Insert_DOMaster(VehicleDeliveryMasterVM DOMasterVM)
        {
            bool result = false;

            string msg = "Failed to save record..";

            result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString());

            if (result)
            {
                msg = "Successfully Added";
            }

            return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
        }
예제 #3
0
        public JsonResult Insert_DOMaster(VehicleDeliveryMasterVM DOMasterVM)
        {
            bool result = false;

            string msg = "Failed to save record..";

            if (DOMasterVM.DeliveryNo != "" && DOMasterVM.DeliveryNo != "0")
            {
                if (Core.CRM.ADO.SecurityBll.UserRights("2017", "003"))
                {
                    result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString());

                    if (result)
                    {
                        msg = "Successfully Added";
                    }
                }
                else
                {
                    msg    = "You dn't have a right! Please Contact to Administrator";
                    result = false;
                }
            }
            else
            {
                result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString());

                if (result)
                {
                    msg = "Successfully Added";
                }
            }



            return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
        }