public string AddDefineService(DefineService _DefineService)
        {
            int    result     = 0;
            string MainResult = string.Empty;
            DefineServiceService OBJ_DefineServiceService = new DefineServiceService();

            try
            {
                var duplicateCheck = OBJ_DefineServiceService.IsDefineServiceExist(_DefineService);
                if (duplicateCheck == "NotExist")
                {
                    var _max = _IUoW.Repository <DefineService>().GetMaxValue(x => x.DefineServiceId) + 1;
                    _DefineService.DefineServiceId = _max.ToString().PadLeft(3, '0');
                    _DefineService.AuthStatusId    = "U";
                    _DefineService.LastAction      = "ADD";
                    _DefineService.MakeDT          = System.DateTime.Now;
                    _DefineService.MakeBy          = "prova";
                    result = _IUoW.Repository <DefineService>().Add(_DefineService);
                    #region Auth Log
                    if (result == 1)
                    {
                        _IAuthLogService = new AuthLogService();
                        long _outMaxSlAuthLogDtl = 0;
                        result = _IAuthLogService.AddAuthLog(_IUoW, null, _DefineService, "ADD", "0001", _DefineService.FunctionId, 1, "DefineService", "MTK_SP_DEFINE_SERVICE", "DefineServiceId", _DefineService.DefineServiceId, _DefineService.UserName, _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
                    }
                    #endregion
                    if (result == 1)
                    {
                        _IUoW.Commit();
                    }
                    MainResult = result + ":" + "Successfull";
                    return(MainResult);
                }
                else
                {
                    MainResult = result + ":" + "Define service already exists..";
                    return(MainResult);
                }
            }
            catch (Exception ex)
            {
                _ObjErrorLogService = new ErrorLogService();
                _ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddDefineService(obj)", string.Empty);
                MainResult = result + ":" + "NotSuccessfull";
                return(MainResult);
            }
        }
        public List <StatusWiseService> GetAllStatusWiseService()
        {
            try
            {
                List <StatusWiseService> OBJ_LIST_StatusWiseService = new List <StatusWiseService>();
                var _ListStatusWiseService = _IUoW.Repository <StatusWiseService>().Get(x => x.AuthStatusId == "A" && x.LastAction != "DEL").OrderByDescending(x => x.StatusWiseServiceId);
                foreach (var item in _ListStatusWiseService)
                {
                    StatusWiseService     OBJ_StatusWiseService     = new StatusWiseService();
                    DefineServiceService  OBJ_DefineServiceService  = new DefineServiceService();
                    AccStatusSetupService OBJ_AccStatusSetupService = new AccStatusSetupService();

                    OBJ_StatusWiseService.StatusWiseServiceId = item.StatusWiseServiceId;
                    OBJ_StatusWiseService.DefineServiceId     = item.DefineServiceId;
                    foreach (var item1 in OBJ_DefineServiceService.GetDefineServiceForDD())
                    {
                        if (item1.Value == OBJ_StatusWiseService.DefineServiceId)
                        {
                            OBJ_StatusWiseService.DefineServiceNm = item1.Text;
                        }
                    }
                    OBJ_StatusWiseService.AccountStatusId = item.AccountStatusId;
                    foreach (var item1 in OBJ_AccStatusSetupService.GetAccStatusSetupForDD())
                    {
                        if (item1.Value == OBJ_StatusWiseService.AccountStatusId)
                        {
                            OBJ_StatusWiseService.AccountStatusName = item1.Text;
                        }
                    }
                    OBJ_StatusWiseService.AuthStatusId = item.AuthStatusId;
                    OBJ_StatusWiseService.LastAction   = item.LastAction;
                    OBJ_StatusWiseService.LastUpdateDT = item.LastUpdateDT;
                    OBJ_StatusWiseService.MakeBy       = item.MakeBy;
                    OBJ_StatusWiseService.MakeDT       = item.MakeDT;
                    OBJ_StatusWiseService.TransDT      = item.TransDT;
                    OBJ_LIST_StatusWiseService.Add(OBJ_StatusWiseService);
                }
                return(OBJ_LIST_StatusWiseService);
            }
            catch (Exception ex)
            {
                _ObjErrorLogService = new ErrorLogService();
                _ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetAllStatusWiseService()", string.Empty);
                return(null);
            }
        }
        public List <TransactionTemplate> GetAllTransactionTemplate()
        {
            try
            {
                List <TransactionTemplate> OBJ_LIST_TransactionTemplate = new List <TransactionTemplate>();
                var _ListTransactionTemplate = _IUoW.Repository <TransactionTemplate>().Get(x => x.AuthStatusId == "A" && x.LastAction != "DEL").OrderByDescending(x => x.TransactionTemplateId);
                foreach (var item in _ListTransactionTemplate)
                {
                    TransactionTemplate  OBJ_TransactionTemplate  = new TransactionTemplate();
                    DefineServiceService OBJ_DefineServiceService = new DefineServiceService();
                    AccTypeService       OBJ_AccTypeService       = new AccTypeService();
                    CommonServiceService OBJ_CommonServiceService = new CommonServiceService();

                    OBJ_TransactionTemplate.TransactionTemplateId = item.TransactionTemplateId;
                    OBJ_TransactionTemplate.DefineServiceId       = item.DefineServiceId;
                    foreach (var item1 in OBJ_DefineServiceService.GetDefineServiceForDD())
                    {
                        if (item1.Value == OBJ_TransactionTemplate.DefineServiceId)
                        {
                            OBJ_TransactionTemplate.DefineServiceName = item1.Text;
                        }
                    }
                    OBJ_TransactionTemplate.SourceofAccountId = item.SourceofAccountId;
                    foreach (var item1 in OBJ_CommonServiceService.GetSourceofAccForDD())
                    {
                        if (item1.Value == OBJ_TransactionTemplate.SourceofAccountId)
                        {
                            OBJ_TransactionTemplate.SourceofAccountName = item1.Text;
                        }
                    }
                    OBJ_TransactionTemplate.TypeofAccountId = item.TypeofAccountId;
                    foreach (var item1 in OBJ_CommonServiceService.GetTypeofAccForDD())
                    {
                        if (item1.Value == OBJ_TransactionTemplate.TypeofAccountId)
                        {
                            OBJ_TransactionTemplate.TypeofAccountName = item1.Text;
                        }
                    }
                    OBJ_TransactionTemplate.AccountTypeId = item.AccountTypeId;
                    foreach (var item1 in OBJ_AccTypeService.GetAccTypeForDD())
                    {
                        if (item1.Value == OBJ_TransactionTemplate.AccountTypeId)
                        {
                            OBJ_TransactionTemplate.AccountTypeName = item1.Text;
                        }
                    }
                    OBJ_TransactionTemplate.GLAccSl       = item.GLAccSl;
                    OBJ_TransactionTemplate.DebitOrCredit = item.DebitOrCredit;
                    foreach (var item1 in OBJ_CommonServiceService.GetAccBalanceTypeForDD())
                    {
                        if (item1.Value == OBJ_TransactionTemplate.DebitOrCredit)
                        {
                            OBJ_TransactionTemplate.BalanceTypeName = item1.Text;
                        }
                    }
                    OBJ_TransactionTemplate.Narration = item.Narration;
                    //OBJ_TransactionTemplate.ChargeRuleId = item.ChargeRuleId;
                    //foreach (var item1 in OBJ_CommonServiceService.GetChargeRuleForDD())
                    //{
                    //    if (item1.Value == OBJ_TransactionTemplate.ChargeRuleId)
                    //    {
                    //        OBJ_TransactionTemplate.ChargeRuleName = item1.Text;
                    //    }
                    //}
                    OBJ_TransactionTemplate.AuthStatusId = item.AuthStatusId;
                    OBJ_TransactionTemplate.LastAction   = item.LastAction;
                    OBJ_TransactionTemplate.LastUpdateDT = item.LastUpdateDT;
                    OBJ_TransactionTemplate.MakeBy       = item.MakeBy;
                    OBJ_TransactionTemplate.MakeDT       = System.DateTime.Now;
                    OBJ_TransactionTemplate.TransDT      = item.TransDT;
                    OBJ_LIST_TransactionTemplate.Add(OBJ_TransactionTemplate);
                }
                return(OBJ_LIST_TransactionTemplate);
            }
            catch (Exception ex)
            {
                _ObjErrorLogService = new ErrorLogService();
                _ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetAllTransactionTemplate()", string.Empty);
                return(null);
            }
        }