public static bool DoLogin(string userId, string password, string macId, out string msg) { bool isSuccess; DBoperationsManager.DoLogin(userId, password, macId, out msg, out isSuccess); return(isSuccess); }
public static RationCardDetail FetchFamilyCount(string custId) { ErrorEnum errType = ErrorEnum.Other; string errMsg = string.Empty; bool isSuccess = false; Exception errObj = new Exception(); int convertedNum = 0; RationCardDetail card = new RationCardDetail(); try { DataSet ds = DBoperationsManager.FetchFamilyCount(custId, out errType, out errMsg, out isSuccess, out errObj); if ((ds != null) && (ds.Tables.Count > 1)) { card.FamilyCount = (( //TOTAL_CARD_COUNT (ds.Tables[0].Rows.Count > 0) && Int32.TryParse(ds.Tables[0].Rows[0][0].ToString(), out convertedNum)) ? convertedNum : 0).ToString(); card.CardCount = (( //Active_CARD_COUNT (ds.Tables[1].Rows.Count > 0) && Int32.TryParse(ds.Tables[1].Rows[0][0].ToString(), out convertedNum)) ? convertedNum : 0).ToString(); } } catch (Exception ex) { Logger.LogError(ex); } return(card); }
public static void FetchConfig(string distId = "", string keyText = "", string keyVal = "", int active = 1, string operation = "GET", string cloneFromDistId = "") { ErrorEnum errType = ErrorEnum.Other; string errMsg = string.Empty; bool isSuccess = false; Exception errObj = new Exception(); isSuccess = false; distId = (string.IsNullOrEmpty(distId.Trim())) ? RationCardUser.DistId : distId; if (operation == "CLONE") { cloneFromDistId = (string.IsNullOrEmpty(cloneFromDistId.Trim())) ? RationCardUser.DistId : cloneFromDistId; } try { DataSet ds = DBoperationsManager.FetchConfig(out errType, out errMsg, out isSuccess, out errObj); if ((ds != null) && (ds.Tables.Count > 0)) { AssignConfigData(ds); } } catch (Exception ex) { Logger.LogError(ex); } }
public JsonResult DuplicateCheck(string val, string checkBy) { bool isUnique = false; string finalMsg = string.Empty; Exception errObj = new Exception(); DBoperationsManager.DuplicateCheck(val, checkBy, out finalMsg); return(new JsonResult(new { isUnique = isUnique, finalMsg = finalMsg })); }
public static void RemoveUser(string userId, out bool isSuccess) { isSuccess = false; try { DBoperationsManager.RemoveUser(userId, out isSuccess); } catch (Exception ex) { Logger.LogError(ex); } }
public static void ApplicationStartDbFetch() { ErrorEnum errType = ErrorEnum.Other; string errMsg = string.Empty; bool isSuccess = false; Exception errObj = new Exception(); try { DBoperationsManager.ApplicationStartDbFetch(out errType, out errMsg, out isSuccess); } catch (Exception ex) { Logger.LogError(ex); } }
public static void RegisterNewUser(string name, string mobileNo, string address, string email, string profilePicPath , string login, string password, bool macChekRequired, string fpsCode, string fpsLiscenceNo, string mrShopNo , string mac, string remark, string code , out string successMsg) { List <MacIdAssigned> mcs = new List <MacIdAssigned>(); successMsg = ""; try { DBoperationsManager.RegisterNewUser(name, mobileNo, address, email, profilePicPath , login, password, macChekRequired, fpsCode, fpsLiscenceNo, mrShopNo , mac, remark, code , out successMsg); } catch (Exception ex) { Logger.LogError(ex); } }
public static void FetchDistributorData() { ErrorEnum errType = ErrorEnum.Other; string errMsg = string.Empty; bool isSuccess = false; Exception errObj = new Exception(); try { DataSet ds = DBoperationsManager.FetchDistributorData(out errType, out errMsg, out isSuccess, out errObj); if ((ds != null) && (ds.Tables.Count > 0)) { AssignDistributorData(ds); } } catch (Exception ex) { Logger.LogError(ex); } }
public static CategoryWiseSearchResult SearchCard(string searchBy, string searchText, string searchCatId, bool fetchOnlyRecentData = false) { ErrorEnum errType = ErrorEnum.Other; string errMsg = string.Empty; bool isSuccess = false; Exception errObj = new Exception(); int convertedNum = 0; var result = new CategoryWiseSearchResult(); result.CardSearchResult = new List <RationCardDetail>(); try { DataSet ds = DBoperationsManager.SearchCard(searchBy, searchText, searchCatId, out errType, out errMsg, out isSuccess, out errObj); if ((ds != null) && (ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)) { int count = 1; result.CardCountOfCategory = int.TryParse(ds.Tables[1].Rows[0]["RECORD_COUNT"].ToString(), out convertedNum) ? convertedNum : 0; result.CategoryOfCard = MasterData.Categories.Data.FirstOrDefault(i => i.Cat_Id == searchCatId); foreach (DataRow r in ds.Tables[0].Rows) { result.CardSearchResult.Add(new RationCardDetail { SlNo = count, Number = r["RATIONCARD_NO"].ToString(), Adhar_No = r["Adhar_No"].ToString(), Mobile_No = r["Mobile_No"].ToString(), Hof_Name = r["HOF_NAME"].ToString(), Name = r["Name"].ToString(), Age = r["Age"].ToString(), Address = r["Address"].ToString(), CardStatus = (r["STATUS"].ToString() == "True") ? "Active" : "", ActiveCard = r["STATUS"].ToString() == "True", Card_Created_Date = r["Created_Date"].ToString(), Cat_Desc = r["Cat_Desc"].ToString(), Customer_Id = r["Customer_Id"].ToString(), Hof_Flag = r["Hof_Flag"].ToString(), Hof_Id = r["Hof_Id"].ToString(), RationCard_Id = r["RationCard_Id"].ToString(), Cat_Id = r["Cat_Id"].ToString(), Card_Category_Id = r["Cat_Id"].ToString(), Remarks = r["Remarks"].ToString(), Relation_With_Hof = r["Relation_With_Hof"].ToString(), Gaurdian_Relation = r["Gaurdian_Relation"].ToString(), Gaurdian_Name = r["Gaurdian_Name"].ToString(), FamilyCount = ds.Tables[0].AsEnumerable().Count( i => i["Hof_Id"].ToString() == r["Hof_Id"].ToString()).ToString(), CardCount = ds.Tables[0].AsEnumerable().Count( i => i["Hof_Id"].ToString() == r["Hof_Id"].ToString() && (r["STATUS"].ToString() == "True")).ToString() }); count++; } } } catch (Exception ex) { Logger.LogError(ex); } return(result); }
public static void FetchMasterData() { ErrorEnum errType = ErrorEnum.Other; string errMsg = string.Empty; bool isSuccess = false; Exception errObj = new Exception(); try { DataSet ds = DBoperationsManager.FetchMasterData(out errType, out errMsg, out isSuccess, out errObj); DataSet tmpDs = new DataSet(); if ((ds != null) && (ds.Tables.Count > 0)) { tmpDs.Tables.Add(ds.Tables[0].Copy()); tmpDs.Tables.Add(ds.Tables[1].Copy()); tmpDs.Tables.Add(ds.Tables[2].Copy()); AssignHofData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[3].Copy()); AssignCategoryData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[4].Copy()); AssignRelationData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[5].Copy()); tmpDs.Tables.Add(ds.Tables[6].Copy()); tmpDs.Tables.Add(ds.Tables[7].Copy()); tmpDs.Tables.Add(ds.Tables[8].Copy()); AssignProductData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[9].Copy()); tmpDs.Tables.Add(ds.Tables[10].Copy()); AssignUomData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[11].Copy()); AssignProductDeptData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[12].Copy()); AssignProductSubDeptData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[13].Copy()); AssignProductClassData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[14].Copy()); AssignProductSubClassData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[15].Copy()); AssignProductMcData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[16].Copy()); AssignProductBrandData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[17].Copy()); AssignRoleData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[18].Copy()); tmpDs.Tables.Add(ds.Tables[19].Copy()); AssignDistributorData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[20].Copy()); AssignConfigData(tmpDs); tmpDs.Reset(); tmpDs.Tables.Add(ds.Tables[21].Copy()); AssignCardsOfThisFortnight(tmpDs); tmpDs.Reset(); //DataFetchTime MasterData.DataFetchTime = DateTime.Now; MasterDataHelper.FetchCategoryWiseSearchResult(); } Logger.LogInfo(Environment.NewLine + "masterdata fetch completed on " + DateTime.Now); } catch (Exception ex) { Logger.LogError(ex); } }