public IActionResult PurchaseRateApplicability(List <PurchaseRateApplicability> PurchaseRateApplicabilityList) { Unions UnionsModel = GetLastRecord <Unions>("tbl_unions"); QueryParam Query = new QueryParam { Fields = "*" }; IEnumerable <Shift> shiftList = NewRepo.FindAll <Shift>(Query); int code = NewRepo.Find <int>(new QueryParam { DirectQuery = "select IFNULL(max(rate_app_code),0) from tbl_purchase_rate_applicability" }); foreach (PurchaseRateApplicability PurchaseRateApplicabilityModel in PurchaseRateApplicabilityList) { Data = new List <ModelParameter>(); if (PurchaseRateApplicabilityModel.module_name.ToLower() == "dcs") { if (PurchaseRateApplicabilityModel.rate_for == "farmer_collection") { PurchaseRateApplicabilityModel.rate_app_code = (code + 1).ToString(); PurchaseRateApplicabilityModel.ref_code = PurchaseRateApplicabilityModel.applicability_unique_code; PurchaseRateApplicabilityModel.originating_org_code = PurchaseRateApplicabilityModel.union_code = UnionsModel.union_code; PurchaseRateApplicabilityModel.dcs_code = PurchaseRateApplicabilityModel.module_code; PurchaseRateApplicabilityModel.shift_code = shiftList.Where(x => x.short_name.ToLower() == PurchaseRateApplicabilityModel.shift.ToLower()).Select(x => x.id).FirstOrDefault(); string time = PurchaseRateApplicabilityModel.wef_date.ToString("yyyy-MM-dd") + " " + shiftList.Where(x => x.short_name.ToLower() == PurchaseRateApplicabilityModel.shift.ToLower()).Select(x => x.shift_time.ToString(@"hh\:mm\:ss")).FirstOrDefault(); PurchaseRateApplicabilityModel.wef_date = DateHelper.ParseDate(time); Data.Add(new ModelParameter { SaveModel = PurchaseRateApplicabilityModel, ValidateModel = new PurchaseRateApplicabilityValidator() }); SaveData(PurchaseRateApplicabilityModel.applicability_unique_code); } } } return(new CustomResult("success", _response)); }
private void OrgDetail() { Hierarchy = new Dictionary <string, List <string> >(); List <Dcs> OrgData = NewRepo.FindAll <Dcs>(new QueryParam { Fields = "union_code,plant_code,mcc_plant_code,bmc_code,dcs_code", Where = new List <ConditionParameter> { Condition("bmc_code", _request.organizationCode) } }).ToList(); if (OrgData == null) { Bmc BmcData = NewRepo.FindByKey <Bmc>(_request.organizationCode); Hierarchy.Add("union_code", new List <string> { BmcData.union_code }); Hierarchy.Add("plant_code", new List <string> { BmcData.plant_code }); Hierarchy.Add("mcc_plant_code", new List <string> { BmcData.mcc_plant_code }); Hierarchy.Add("bmc_code", new List <string> { _request.organizationCode }); Hierarchy.Add("dcs_code", new List <string> { "" }); } else { Hierarchy.Add("union_code", new List <string> { OrgData.Select(x => x.union_code).FirstOrDefault() }); Hierarchy.Add("plant_code", new List <string> { OrgData.Select(x => x.plant_code).FirstOrDefault() }); Hierarchy.Add("mcc_plant_code", new List <string> { OrgData.Select(x => x.mcc_plant_code).FirstOrDefault() }); Hierarchy.Add("bmc_code", new List <string> { _request.organizationCode }); Hierarchy.Add("dcs_code", OrgData.Select(x => x.dcs_code).ToList()); } }
private List <string> SingleHierarchy(string hierarchy_code, string parent_code, string[] parent_value, bool IsHierarchy) { string table; if (IsHierarchy) { table = "business_hierarchy"; } else { table = hierarchy_code.Split('-')[0]; } Query = new QueryParam { Fields = hierarchy_code, Table = table, Where = new List <ConditionParameter> { Condition(parent_code, parent_value, "IN") } }; return(NewRepo.FindAll <string>(Query).ToList()); }
private void SetFreeActions() { FreeAction _freeAction = _cache.GetData <FreeAction>("FreeActions"); if (_freeAction == null || (DateTime.Now.Subtract(_freeAction.created_at).Hours >= 24)) { _freeAction = new FreeAction(); Query = new QueryParam() { Table = typeof(Actions).GetTableName(), Fields = "distinct service_url", Where = new List <ConditionParameter> { Condition("is_free", true), new ConditionParameter { direct_condition = "service_url is not null", PropertyValue = "#$#", PropertyName = "service_url" } } }; _freeAction.actions = NewRepo.FindAll <string>(Query).ToList(); _freeAction.created_at = DateTime.Now; _cache.SaveData(_freeAction, "FreeActions", null); } }
public IActionResult Generate(string host) { AndroidInstallationDetails DetailModel = NewRepo.FindByColumn <AndroidInstallationDetails>(new List <ConditionParameter> { Condition("hash_key", _request.token) }); if (DetailModel != null) { string NewFileName = FileHelper.NewFileName(FileHelper.FileServerPath("Identity/Data/"), $"{_request.organizationType}_{_request.organizationCode}_", "db"); FileHelper.Copy(FileHelper.FileServerPath("Identity/Struct/everest_amcs.db"), NewFileName); DetailModel.db_path = host + "/" + NewFileName.Replace(FileHelper.ProjectPath(), ""); DetailModel.model_operation = "update"; _data = new List <ModelParameter> { new ModelParameter { ValidateModel = null, SaveModel = DetailModel } }; AUDOperation(_data); DBRepository Sqlite = new DBRepository(NewFileName); _query = new QueryParam { DirectQuery = $"SELECT tbl_name FROM sqlite_master WHERE type='table'" }; List <string> SqliteTable = Sqlite.FindAll <string>(_query).ToList(); List <TableList> AllTableList = NewRepo.FindAll <TableList>(new QueryParam { Where = new List <ConditionParameter> { Condition("is_offline", 0) } }).ToList(); OrgDetail(); foreach (TableList tables in AllTableList) { if (SqliteTable.Contains(tables.table_name.Trim())) { _query = new QueryParam { DirectQuery = $"PRAGMA table_info({tables.table_name.Trim()})" }; List <TableInfo> TableInfoDetail = Sqlite.FindAll <TableInfo>(_query).ToList(); string fields = string.Join(",", TableInfoDetail.Select(x => x.name).ToArray()); _query = new QueryParam { Fields = fields, Distinct = "distinct", Table = tables.table_name.Trim(), }; if (tables.key_field != null && tables.key_field.Trim() != "") { string comapre_field = tables.key_field == "to_dest"?"bmc_code": tables.key_field; _query.Where = new List <ConditionParameter> { Condition(tables.key_field, Hierarchy[comapre_field], "in") }; } IEnumerable <object> ObjectResult = NewRepo.FindAll(_query); int i = 0; string DirectQuery = ""; foreach (var ObjTmp in ObjectResult) { IDictionary <string, object> Tmp = ObjTmp as IDictionary <string, object>; if (i == 0) { DirectQuery = $"insert into {tables.table_name} ({fields}) values ("; } if (i == 200) { DirectQuery = DirectQuery.TrimEnd('('); DirectQuery = DirectQuery.TrimEnd(','); Sqlite.Add(new QueryParam { DirectQuery = DirectQuery }); i = 0; } else { DirectQuery += string.Join(",", Tmp.Select(x => x.Value == null ? "NULL" : $"'{x.Value.ToString()}'")) + "),("; i++; } } if (DirectQuery != "") { DirectQuery = DirectQuery.TrimEnd('('); DirectQuery = DirectQuery.TrimEnd(','); Sqlite.Add(new QueryParam { DirectQuery = DirectQuery }); } } } dynamic data = new ExpandoObject(); data.dbPath = DetailModel.db_path; return(new CustomResult2(data)); } return(new CustomResult2(null, "Authentication Failed.")); }
public IActionResult Verification() { dynamic data = new ExpandoObject(); AndroidInstallationDetails DetailModel = NewRepo.FindByColumn <AndroidInstallationDetails>(new List <ConditionParameter> { Condition("hash_key", _request.token), Condition("otp_code", _request.content.otpCode), Condition("imei_no", _request.imei), }); if (DetailModel == null) { return(new CustomResult2(data, "OTP Not Verified.")); } else { _data = new List <ModelParameter>(); _query = new QueryParam { Where = new List <ConditionParameter> { Condition("android_installation_id", DetailModel.android_installation_id), Condition("android_installation_details_id", DetailModel.android_installation_details_id, "!=") } }; List <AndroidInstallationDetails> DetailList = NewRepo.FindAll <AndroidInstallationDetails>(_query).ToList(); foreach (AndroidInstallationDetails UdateDetailModel in DetailList.NotEmpty()) { UdateDetailModel.sync_active = false; UdateDetailModel.model_operation = "update"; _data.Add(new ModelParameter { ValidateModel = null, SaveModel = UdateDetailModel }); } DetailModel.is_active = true; DetailModel.sync_key = NumericHelper.RandomNumber().ToString(); DetailModel.sync_active = true; DetailModel.model_operation = "update"; _data.Add(new ModelParameter { ValidateModel = null, SaveModel = DetailModel }); CustomResult result = AUDOperation(_data); if (result._result.message.ToLower() == "success") { _query = new QueryParam { Fields = "tbl_mcc_plant.mcc_plant_code,tbl_mcc_plant.name", Join = new List <JoinParameter> { new JoinParameter { table = "tbl_bmc", condition = "tbl_bmc.mcc_plant_code=tbl_mcc_plant.mcc_plant_code" } }, Where = new List <ConditionParameter> { Condition("bmc_code", _request.organizationCode) } }; MccPlant MccModel = NewRepo.Find <MccPlant>(_query); if (MccModel == null) { return(new CustomResult2(data, "OTP Not Verified.")); } data.message = "OTP Verified"; data.syncKey = DetailModel.sync_key; data.parentType = "MCC"; data.parentCode = MccModel.mcc_plant_code; data.parentName = MccModel.name; return(new CustomResult2(data)); } return(new CustomResult2(data, "OTP Not Verified.")); } }
public IActionResult SaveCustomer(List <CustomerMaster> CustomerMasterList) { Unions UnionsModel = GetLastRecord <Unions>("tbl_unions"); QueryParam Query = new QueryParam { Fields = "*", Table = "tbl_customer_type" }; List <CustomerType> CustomerTypeList = NewRepo.FindAll <CustomerType>(Query).ToList(); foreach (CustomerMaster CustomerMasterModel in CustomerMasterList) { Data = new List <ModelParameter>(); if (CustomerMasterModel.customer_unique_code.Trim() != "") { string prefix = CustomerTypeList.Where(x => x.customer_type == CustomerMasterModel.customer_type).Select(x => x.code_prefix).FirstOrDefault(); if (CheckPrefix(prefix, CustomerMasterModel.customer_code)) { CustomerMaster NewModel = NewRepo.Find <CustomerMaster>(new QueryParam { Where = new List <ConditionParameter> { Condition("ref_code", CustomerMasterModel.customer_unique_code) } }); if (NewModel == null) { CustomerMasterModel.ref_code = CustomerMasterModel.customer_unique_code; CustomerMasterModel.x_col1 = SetDcsXcol(CustomerMasterModel.allow_multiple_milktype); CustomerMasterModel.originating_org_code = CustomerMasterModel.union_code = UnionsModel.union_code; Data.Add(new ModelParameter { SaveModel = CustomerMasterModel, ValidateModel = new CustomerMasterValidator() }); } else { NewModel.customer_unique_code = CustomerMasterModel.customer_unique_code; NewModel.bmc_code = CustomerMasterModel.bmc_code; NewModel.x_col1 = SetDcsXcol(CustomerMasterModel.allow_multiple_milktype); NewModel.route_code = CustomerMasterModel.route_code; NewModel.customer_name = CustomerMasterModel.customer_name; NewModel.is_active = CustomerMasterModel.is_active; NewModel.mobile_no = CustomerMasterModel.mobile_no; NewModel.customer_type = CustomerMasterModel.customer_type; NewModel.model_operation = "update"; Data.Add(new ModelParameter { SaveModel = NewModel, ValidateModel = new CustomerMasterValidator() }); } SaveData(CustomerMasterModel.customer_unique_code); } else { _response.Add(new CustomResponse { status = "300", msg = "error:customer_code:Invalid Code" }); } } else { _response.Add(new CustomResponse { status = "300", msg = "error:customer_unique_code:Require" }); } } return(new CustomResult("success", _response)); }
private TmpUserToken SetUserCache(Users UserData) { Query = new QueryParam() { Table = "user_organization_mapping", Fields = "org_type,company_code,plant_code,mcc_code,bmc_code,mpp_code", Where = new List <ConditionParameter> { Condition("user_code", UserData.user_code) } }; List <UserOrganizationMapping> _UserOrganizationMappingList = NewRepo.FindAll <UserOrganizationMapping>(Query).ToList(); if (_UserOrganizationMappingList == null || _UserOrganizationMappingList.Count == 0) { return(null); } Query = new QueryParam() { Table = "user_role", Fields = "role_code", Where = new List <ConditionParameter> { Condition("user_code", UserData.user_code) } }; TmpUserToken _TmpUserToken = new TmpUserToken { token = UserData.token, username = UserData.user_name, user_code = UserData.user_code, id = UserData.token, role = NewRepo.FindAll <string>(Query).ToList(), usertype = _UserOrganizationMappingList.FirstOrDefault().org_type, company_code = _UserOrganizationMappingList.Select(o => o.company_code).Distinct().ToList(), plant_code = _UserOrganizationMappingList.Select(o => o.plant_code).Distinct().ToList(), mcc_code = _UserOrganizationMappingList.Select(o => o.mcc_code).Distinct().ToList(), bmc_code = _UserOrganizationMappingList.Select(o => o.bmc_code).Distinct().ToList(), mpp_code = _UserOrganizationMappingList.Select(o => o.mpp_code).Distinct().ToList(), member_code = UserData.reference_code, exp = DateTime.Now.AddHours(6) }; Query = new QueryParam() { Table = "actions", Fields = "distinct service_url", Join = new List <JoinParameter>() { new JoinParameter { table = "permission_action", condition = "permission_action.action_code=actions.action_code" }, new JoinParameter { table = "role_permission", condition = "role_permission.permission_code=permission_action.permission_code" } }, Where = new List <ConditionParameter> { Condition("role_code", _TmpUserToken.role, "in") } }; _TmpUserToken.actions = NewRepo.FindAll <string>(Query).ToList(); return(_TmpUserToken); }