Ejemplo n.º 1
0
        public HttpResponseMessage SaveCustomCode(object[] data)
        {
            CmnCustomCode itemMaster = JsonConvert.DeserializeObject <CmnCustomCode>(data[0].ToString());
            List <CmnCustomCodeDetail> itemDetails = JsonConvert.DeserializeObject <List <CmnCustomCodeDetail> >(data[1].ToString());
            CmnCustomCode obj    = new CmnCustomCode();
            string        result = "";

            try
            {
                result = "1";
                if (ModelState.IsValid)
                {
                    using (CmnCustomCodeMgt objService = new CmnCustomCodeMgt())
                    {
                        result = (objService.SavCustomCode(itemMaster, itemDetails)).ToString();
                    }
                }
            }
            catch (Exception e)
            {
                e.ToString();
                result = e.ToString();
            }
            return(Request.CreateResponse(HttpStatusCode.OK, result));
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Save Data To Database
        /// <para>Use it when save data through a stored procedure</para>
        /// </summary>
        public int SaveCompany(CmnCompany model)
        {
            GenericFactoryEF_Company  = new CmnCompany_EF();
            GFactory_EF_CmnCustomCode = new SalCmnCustomCode_EF();

            int result = 0;

            try
            {
                #region CustomCode And Primary Key  Process
                int NextId = Convert.ToInt16(GenericFactoryEF_Company.getMaxID("CmnCompany"));
                model.CompanyID = NextId;
                //......... START for custom code........... //
                //string customCode = "";
                CmnCustomCode objCustomCode = GFactory_EF_CmnCustomCode.FindBy(m => m.MenuID == model.MenuID && m.IsDeleted == false).FirstOrDefault();
                //int customCodeID = Convert.ToInt16(objCustomCode.RecordID);
                //if (customCodeID > 0)
                //{
                //  //  customCode = GenericFactory_EF_SalPIMaster.getCustomCode(customCodeID, DateTime.Now, itemMaster.CompanyID, 1, 1);
                //    customCode = GFactory_EF_CmnCustomCode.getCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
                //}
                //else
                //{
                //    customCode = NextId.ToString();
                //}
                //.........END for custom code............ //

                #endregion CustomCode And Primary Key  Process
                Hashtable ht = new Hashtable();
                ht.Add("CompanyID", model.CompanyID);
                ht.Add("CustomCode", model.CustomCode);
                ht.Add("CompanyShortName", model.CompanyShortName);
                ht.Add("CompanyName", model.CompanyName);
                //ht.Add("StatusID", model.StatusID);
                string spQuery = "[Set_CmnCompany]";
                result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);

                //Update Primary Key and Custom Code
                GenericFactoryEF_Company.updateMaxID("CmnCompany", Convert.ToInt64(NextId));
                //GFactory_EF_CmnCustomCode.updateCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
            }
            catch (Exception ex)
            {
                ErrorLog.Log(ex);
                ex.ToString();
            }

            return(result);
        }
Ejemplo n.º 3
0
        public HttpResponseMessage DeleteMaster(int RecordID)
        {
            CmnCustomCode itemMaster = new CmnCustomCode();
            int           result     = 0;

            try
            {
                if (ModelState.IsValid)
                {
                    objService = new CmnCustomCodeMgt();
                    result     = (objService.UpdateMasterStatus(RecordID));
                    result     = 1;
                }
            }
            catch (Exception e)
            {
                e.ToString();
                result = 0;
            }
            return(Request.CreateResponse(HttpStatusCode.OK, result));
        }
Ejemplo n.º 4
0
        public int SavCustomCode(CmnCustomCode model, List <CmnCustomCodeDetail> details)
        {
            GenericFactory_EF_customCode    = new CmnCustomCode_EF();
            GenericFactory_EF_customDetails = new CmnCustomCodeDetail_EF();
            int           masterID   = model.RecordID;
            CmnCustomCode modelBase  = new CmnCustomCode();
            List <Int32>  UpdatedIDs = new List <Int32>();
            List <CmnCustomCodeDetail> detailsListDeleted   = new List <CmnCustomCodeDetail>();
            List <CmnCustomCodeDetail> detailsList          = new List <CmnCustomCodeDetail>();
            List <CmnCustomCodeDetail> detailsInsertionList = new List <CmnCustomCodeDetail>();
            int result = 0;

            try
            {
                modelBase = ModelBinding(model, details);
                foreach (var item in modelBase.CmnCustomCodeDetails)
                {
                    if (item.EntryStateStatus == "Modified")
                    {
                        CmnCustomCodeDetail detailsEntity = new CmnCustomCodeDetail();
                        detailsEntity = DetailsBinding(modelBase.CmnCustomCodeDetails.Where(x => x.RecordDetailID == item.RecordDetailID).FirstOrDefault());
                        detailsList.Add(detailsEntity);
                        UpdatedIDs.Add(detailsEntity.RecordDetailID);
                    }
                    if (item.EntryStateStatus == "Add" && masterID > 0)
                    {
                        CmnCustomCodeDetail detailsEntity = new CmnCustomCodeDetail();
                        detailsEntity = DetailsBinding(modelBase.CmnCustomCodeDetails.Where(x => x.RecordDetailID == item.RecordDetailID).FirstOrDefault());
                        detailsInsertionList.Add(detailsEntity);
                    }
                }

                foreach (var item in UpdatedIDs)
                {
                    modelBase.CmnCustomCodeDetails.Remove(modelBase.CmnCustomCodeDetails.Where(x => x.RecordDetailID == item).FirstOrDefault());
                }
                if (masterID == 0)
                {
                    GenericFactory_EF_customCode.Insert(modelBase);
                    GenericFactory_EF_customCode.Save();
                }
                else
                {
                    GenericFactory_EF_customCode.Update(model);
                    GenericFactory_EF_customDetails.UpdateList(detailsList);
                    foreach (CmnCustomCodeDetail item in detailsList)
                    {
                        if (item.IsDeleted)
                        {
                            detailsListDeleted.Add(item);
                        }
                    }
                    if (detailsListDeleted.Count > 0)
                    {
                        GenericFactory_EF_customDetails.DeleteList(detailsListDeleted);
                    }
                    GenericFactory_EF_customDetails.InsertList(detailsInsertionList);


                    GenericFactory_EF_customCode.Save();
                    GenericFactory_EF_customDetails.Save();
                    GenericFactory_EF_customDetails = new CmnCustomCodeDetail_EF();
                }

                result = 1;
            }
            catch (Exception ex)
            {
                ex.ToString();
                return(result);
            }
            return(result);
        }
Ejemplo n.º 5
0
 private CmnCustomCode ModelBinding(CmnCustomCode model, List <CmnCustomCodeDetail> details)
 {
     GenericFactory_EF_customCode = new CmnCustomCode_EF();
     try
     {
         int NextID = GenericFactory_EF_customCode.getMaxVal_int("RecordID", "CmnCustomCode");
         model.RecordID         = model.RecordID == 0 ? NextID : model.RecordID;
         model.CustomCode       = model.RecordID.ToString();
         model.CompanyID        = model.CompanyID;
         model.IsCompany        = model.IsCompany ?? false;
         model.IsOrganogramCode = model.IsOrganogramCode ?? false;
         model.IsDeleted        = false;
         NextID = GenericFactory_EF_customCode.getMaxVal_int("RecordDetailID", "CmnCustomCodeDetail");
         foreach (CmnCustomCodeDetail Item in details)
         {
             CmnCustomCodeDetail entity = new CmnCustomCodeDetail();
             entity.RecordDetailID = Item.RecordDetailID;
             if (Item.RecordDetailID == 0)
             {
                 if (Item.IsDeleted)
                 {
                     continue;
                 }
                 Item.RecordDetailID     = NextID++;
                 entity.RecordDetailID   = Item.RecordDetailID;
                 entity.EntryStateStatus = "Add";
             }
             else if (Item.IsDeleted == true)
             {
                 entity.EntryStateStatus = "Delete";
             }
             else
             {
                 entity.EntryStateStatus = "Modified";
             }
             entity.CustomCode    = entity.RecordDetailID.ToString();
             entity.CustomCodeID  = model.RecordID;
             entity.ParameterName = Item.ParameterName;
             entity.Length        = Item.Length;
             entity.Seperator     = Item.Seperator;
             entity.Sequence      = Item.Sequence;
             entity.StatusID      = Item.StatusID;
             entity.CompanyID     = model.CompanyID;
             entity.CreateBy      = Item.CreateBy;
             entity.CreateOn      = Item.CreateOn;
             entity.CreatePc      = Item.CreatePc;
             entity.UpdateBy      = Item.UpdateBy;
             entity.UpdateOn      = Item.UpdateOn;
             entity.UpdatePc      = Item.UpdatePc;
             if (entity.EntryStateStatus != "Delete")
             {
                 entity.IsDeleted = false;
             }
             else
             {
                 entity.EntryStateStatus = "Modified";
                 entity.IsDeleted        = true;
             }
             entity.DeleteBy = Item.DeleteBy;
             entity.DeleteOn = Item.DeleteOn;
             entity.DeletePc = Item.DeletePc;
             model.CmnCustomCodeDetails.Add(entity);
         }
     }
     catch (Exception ex)
     {
         ex.ToString();
     }
     return(model);
 }
Ejemplo n.º 6
0
        /// <summary>
        /// Save Data To Database
        /// <para>Use it when save data through a stored procedure</para>
        /// </summary>
        public int SaveCompanyParam(CmnCompany model, UserCommonEntity commonEntity)
        {
            GenericFactoryFor_Company = new CmnCompany_GF();
            GenericFactoryEF_Company  = new CmnCompany_EF();
            GFactory_EF_CmnCustomCode = new SalCmnCustomCode_EF();
            int result = 0;

            try
            {
                #region CustomCode And Primary Key  Process
                int NextId = Convert.ToInt16(GenericFactoryEF_Company.getMaxID("CmnCompany"));
                model.CompanyID = NextId;
                //......... START for custom code........... //
                //string customCode = "";
                CmnCustomCode objCustomCode = GFactory_EF_CmnCustomCode.FindBy(m => m.MenuID == model.MenuID && m.IsDeleted == false).FirstOrDefault();
                //int customCodeID = Convert.ToInt16(objCustomCode.RecordID);
                //if (customCodeID > 0)
                //{
                //  //  customCode = GenericFactory_EF_SalPIMaster.getCustomCode(customCodeID, DateTime.Now, itemMaster.CompanyID, 1, 1);
                //    customCode = GFactory_EF_CmnCustomCode.getCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
                //}
                //else
                //{
                //    customCode = NextId.ToString();
                //}
                //.........END for custom code............ //

                #endregion CustomCode And Primary Key  Process
                #region Basic Save
                Hashtable ht = new Hashtable();
                ht.Add("CompanyID", model.CompanyID);
                ht.Add("CustomCode", model.CustomCode);
                ht.Add("CompanyShortName", model.CompanyShortName);
                ht.Add("CompanyName", model.CompanyName);
                ht.Add("LoggedCompanyID", commonEntity.loggedCompnyID);
                ht.Add("LoggedUser", commonEntity.loggedUserID);

                //  ht.Add("StatusID", model.StatusID);
                string spQuery = "[Set_CmnCompany]";
                result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
                #endregion Basic Save

                #region WorkFlow Transaction Entry
                ////  CHECK WorkFLow Setup
                ////IF targetUserID=0 Then Work flow is not configured
                //int targetUserID = new WorkFLowMgt().GetWorkFlowBeginner(commonEntity);
                //if (targetUserID > 0)
                //{
                //    //IN CASE OF SAVE
                //    //REQUIRD MENUID, COMPANYID, TARGET USERID AS TARGET USERID, USER AS CURRENT USERID,TRANSACTION ID AS MASTERID(INSERTED) ,STATUSID 1
                //    //IS APPROVED 0, IS DELETE 0, IS UPDATE 0 , @APPROVALCUSTOMCODE = '',Is Declained=0
                //    var comment = "";
                //    var APPROVALCUSTOMCODE = string.Empty;
                //    //    int WorkFlowStatus = new WorkFLowMgt().ExecuteWorkFlowTransactionProcess(new WorkFLowMgt().SetProcedureParam(commonEntity, targetUserID, NextId, 0, comment, 0, 0, 1, "", 0));
                //    String MessageName = System.Enum.GetName(typeof(workFlowTranEnum_MessageName), (int)workFlowTranEnum_MessageName.Created);
                //    int WorkFlowStatus = new WorkFLowMgt().ExecuteWorkFlowTransactionProcess(new WorkFLowMgt().SetProcedureParam(commonEntity, targetUserID, NextId, (int)workFlowTranEnum_IsApproved.False, comment, (int)workFlowTranEnum_IsUpdate.False, (int)workFlowTranEnum_IsDelete.False, (int)workFlowTranEnum_Status.Active, APPROVALCUSTOMCODE, (int)workFlowTranEnum_IsDeclained.False, MessageName));

                //}
                #endregion WorkFlow Transaction Entry
                #region CustomCode And Primary Key  Process Update Process
                //Update Primary Key and Custom Code
                GenericFactoryEF_Company.updateMaxID("CmnCompany", Convert.ToInt64(NextId));
                //  GFactory_EF_CmnCustomCode.updateCustomCode(customCodeID, DateTime.Now, 0, 1, 1);
                #endregion  CustomCode And Primary Key  Process Update Process

                #region WorkFlow Transaction Entry Team
                int workflowID = 0;
                List <vmCmnWorkFlowMaster> listWorkFlow = new WorkFLowMgt().GetWorkFlowMasterListByMenu(commonEntity);
                foreach (vmCmnWorkFlowMaster item in listWorkFlow)
                {
                    int userTeamID = item.UserTeamID ?? 0;
                    if (new WorkFLowMgt().checkUserValidation(commonEntity.loggedUserID ?? 0, item.WorkFlowID) && userTeamID > 0)
                    {
                        item.WorkFlowTranCustomID = model.CompanyID;
                        workflowID = new WorkFLowMgt().ExecuteTransactionProcess(item, commonEntity);
                        //Mail Service
                    }
                    if (userTeamID == 0)
                    {
                        item.WorkFlowTranCustomID = model.CompanyID;
                        workflowID = new WorkFLowMgt().ExecuteTransactionProcess(item, commonEntity);
                    }
                }
                #endregion Workflow Transaction Enltry Team
            }
            catch (Exception)
            {
                throw new Exception();
            }

            return(result);
        }