private UOMConversionModel fnUOMConversion_Get(UOMConversionModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); UOMConversionModel objUOMConversion = new UOMConversionModel(); DataSet usersInfoDS = DAL_UOMMaster.UOMConversion_Get(crCnString, apiObject.SourceUOMId, apiObject.DestinationUOMId, apiObject.CompanyId); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; DataRow dr = usersInfoDT.Rows[0]; objUOMConversion.SourceUOMId = UtilityLib.FormatNumber(dr["SourceUOMId"].ToString()); objUOMConversion.SourceConversionRation = UtilityLib.FormatDecimal(dr["SourceConversionRation"].ToString()); objUOMConversion.DestinationUOMId = UtilityLib.FormatNumber(dr["DestinationUOMId"].ToString()); objUOMConversion.DestinationConversionRation = UtilityLib.FormatDecimal(dr["DestinationConversionRation"].ToString()); } else { strReturnCode = "002"; apiObject.ReturnMessage = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objUOMConversion); }
private IList <GeneralMasterClass> fnGeneralMasterClass_List(GeneralMasterClass apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <GeneralMasterClass> objGeneralClassModelList = new List <GeneralMasterClass>(); DataSet usersInfoDS = DAL_GeneralMasterClass.GeneralMasterClass_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString, apiObject.IntID, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new GeneralMasterClass(); apiObject.GeneralMasterClassId = UtilityLib.FormatNumber(dr["GeneralMasterClassId"].ToString()); apiObject.GeneralMasterClassName = (string)dr["GeneralMasterClassName"]; apiObject.CompanyId = (Guid)(dr["CompanyId"]); objGeneralClassModelList.Add(apiObject); } } else { strReturnCode = "002"; apiObject.ReturnMessage = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objGeneralClassModelList); }
public InventoryModel GetREciptNo() { string strResult = ""; string strReturnCode = "000"; string strReturnMsg = "UnDefined"; InventoryModel apiObject = new InventoryModel(); string crCnString = UtilityLib.GetConnectionString(); DataSet dt = DAL_Inventory.GetRecipt(crCnString); DataTable usersInfoDT = dt.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new InventoryModel(); apiObject.NewReciptNo = UtilityLib.FormatNumber(dr["UpRwcipt"].ToString()); } } else { strReturnCode = "002"; strReturnMsg = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(apiObject); ; }
private IList <RoleRightsModel> fnRightsBasedMenu_List(RoleRightsModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <RoleRightsModel> objRightsModelList = new List <RoleRightsModel>(); DataSet usersInfoDS = DAL_RoleRightsBasedMenu.ShowModules_RightsBased(crCnString, apiObject.RequestType, apiObject.RoleId, apiObject.CompanyId); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new RoleRightsModel(); apiObject.RoleRightsId = UtilityLib.FormatNumber(dr["RoleRightsId"].ToString()); apiObject.RoleId = UtilityLib.FormatNumber(dr["RoleId"].ToString()); apiObject.RoleName = (string)dr["RoleName"]; apiObject.ModuleName = (string)dr["ModuleName"]; //apiObject.ModuleOrder = (string)dr["ModuleOrder"]; apiObject.ModuleURL = (string)dr["ModuleURL"]; apiObject.ModuleCode = (string)dr["ModuleCode"]; apiObject.ModuleImagePath = (string)dr["ModuleImagePath"]; apiObject.ModuleId = UtilityLib.FormatNumber(dr["ModuleId"].ToString()); apiObject.PrecedingModuleId = UtilityLib.FormatNumber(dr["PrecedingModuleId"].ToString()); apiObject.View = UtilityLib.FormatBoolean(dr["View"].ToString()); apiObject.Edit = UtilityLib.FormatBoolean(dr["Edit"].ToString()); apiObject.Create = UtilityLib.FormatBoolean(dr["Create"].ToString()); apiObject.Delete = UtilityLib.FormatBoolean(dr["Delete"].ToString()); apiObject.CompanyId = (Guid)(dr["CompanyId"]); objRightsModelList.Add(apiObject); } } else { strReturnCode = "002"; strReturnMsg = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objRightsModelList); }
private IList <ProductMasterModel> fnProductMaster_List(ProductMasterModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <ProductMasterModel> objFieldClassModelList = new List <ProductMasterModel>(); DataSet usersInfoDS = DL_ProductMaster.Product_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString, apiObject.Productid, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new ProductMasterModel(); apiObject.Productid = UtilityLib.FormatNumber(dr["Processid"].ToString()); apiObject.ProductName = (string)dr["ProductName"]; apiObject.UOM = UtilityLib.FormatNumber(dr["UOM"].ToString()); //apiObject.State = UtilityLib.FormatString(dr["State"]); //apiObject.Texture = UtilityLib.FormatNumber(dr["Texture "].ToString()); //apiObject.Catagory = UtilityLib.FormatNumber(dr["Catagory "].ToString()); apiObject.CreatedBy = (Guid)(dr["CreatedBy"]); apiObject.CreatedDate = UtilityLib.FormatDate(dr["CreatedDate"]); apiObject.IsDelete = UtilityLib.FormatBoolean(dr["IsDelete"].ToString()); apiObject.SafeLifeInGodown = UtilityLib.FormatDate(dr["SafeLifeInGodown"]); apiObject.ProcessId = (string)(dr["ProcessId"]); apiObject.BuyProductId = UtilityLib.FormatNumber(dr["BuyProductId"].ToString()); apiObject.BuyProductPacking = UtilityLib.FormatNumber(dr["BuyProductPacking"].ToString()); apiObject.CompanyId = (Guid)(dr["CompanyId"]); objFieldClassModelList.Add(apiObject); } } else { strReturnCode = "002"; strReturnMsg = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objFieldClassModelList); }
private IList <InventoryModel> fnInventory_List(InventoryModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <InventoryModel> objFieldClassModelList = new List <InventoryModel>(); DataSet usersInfoDS = DAL_Inventory.Inventory_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString, apiObject.ReciptNo, apiObject.ComapnyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new InventoryModel(); apiObject.ReciptNo = UtilityLib.FormatNumber(dr["ReciptNo"].ToString()); apiObject.FarmerId = UtilityLib.FormatNumber(dr["FarmerId"].ToString()); apiObject.LoginId = UtilityLib.FormatNumber(dr["LoginId"].ToString()); apiObject.PersonName = (string)dr["PersonName"]; apiObject.Quantity = UtilityLib.FormatNumber(dr["Qunatity"].ToString()); apiObject.Unit = (string)dr["Unit"]; apiObject.RawMaterial = (string)dr["RawMaterial"]; apiObject.Storage = UtilityLib.FormatNumber(dr["Storage"].ToString()); apiObject.CreatedDate = UtilityLib.FormatDate(dr["CreatedDate"]); //apiObject.CompanyId = (Guid)(dr["CompanyId"]); objFieldClassModelList.Add(apiObject); } } else { strReturnCode = "002"; strReturnMsg = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objFieldClassModelList); }
private IList <RoleRightsModel> fnRights_List(RoleRightsModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <RoleRightsModel> objRightsModelList = new List <RoleRightsModel>(); DataSet usersInfoDS = DAL_RoleRights.Rights_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString, apiObject.IntID, apiObject.RoleId, apiObject.ModuleId, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new RoleRightsModel(); apiObject.RoleRightsId = UtilityLib.FormatNumber(dr["RoleRightsId"].ToString()); apiObject.RoleId = UtilityLib.FormatNumber(dr["RoleId"].ToString()); apiObject.RoleName = (string)dr["RoleName"]; apiObject.ModuleId = UtilityLib.FormatNumber(dr["ModuleId"].ToString()); apiObject.ModuleName = (string)dr["ModuleName"]; apiObject.View = UtilityLib.FormatBoolean(dr["View"].ToString()); apiObject.Edit = UtilityLib.FormatBoolean(dr["Edit"].ToString()); apiObject.Create = UtilityLib.FormatBoolean(dr["Create"].ToString()); apiObject.Delete = UtilityLib.FormatBoolean(dr["Delete"].ToString()); apiObject.CompanyId = (Guid)(dr["CompanyId"]); objRightsModelList.Add(apiObject); } } else { strReturnCode = "002"; strReturnMsg = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objRightsModelList); }
private IList <UOMMasterModel> fnUOMMaster_List(UOMMasterModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <UOMMasterModel> objUOMMasterModelList = new List <UOMMasterModel>(); DataSet usersInfoDS = DAL_UOMMaster.UOMMaster_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString, apiObject.IntID, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new UOMMasterModel(); apiObject.UOMId = UtilityLib.FormatNumber(dr["UOMId"].ToString()); apiObject.UOMTypeId = UtilityLib.FormatNumber(dr["UOMTypeId"].ToString()); apiObject.DecimalPoints = UtilityLib.FormatNumber(dr["DecimalPoints"].ToString()); apiObject.BaseUnit = (bool)dr["BaseUnit"]; apiObject.ConversionRation = UtilityLib.FormatDecimal(dr["ConversionRation"].ToString()); apiObject.UOMName = (string)dr["UOMName"]; apiObject.UOMCode = (string)dr["UOMCode"]; apiObject.CompanyId = (Guid)(dr["CompanyId"]); objUOMMasterModelList.Add(apiObject); } } else { strReturnCode = "002"; apiObject.ReturnMessage = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objUOMMasterModelList); }
private IList <ProcessMasterModel> fnProcessMaster_List(ProcessMasterModel apiObject, ref string strResult) { string strReturnCode = "000"; string strReturnMsg = "UnDefined"; string crCnString = UtilityLib.GetConnectionString(); IList <ProcessMasterModel> objFieldClassModelList = new List <ProcessMasterModel>(); DataSet usersInfoDS = DL_ProcessMaster.Process_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString, apiObject.ProcessId, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo); DataTable usersInfoDT = usersInfoDS.Tables[0]; if (usersInfoDT != null && usersInfoDT.Rows.Count > 0) { strReturnCode = "001"; strReturnMsg = "Success"; foreach (DataRow dr in usersInfoDT.Rows) { apiObject = new ProcessMasterModel(); apiObject.ProcessId = UtilityLib.FormatNumber(dr["ProcessId"].ToString()); apiObject.ProcessName = (string)dr["ProcessName"]; apiObject.QuantityFlag = UtilityLib.FormatBoolean(dr["QuantityFlag"].ToString()); apiObject.ByProduct = UtilityLib.FormatBoolean(dr["ByProduct"].ToString()); apiObject.WastageFlag = UtilityLib.FormatBoolean(dr["WastageFlag"].ToString()); apiObject.QuantityFlag = UtilityLib.FormatBoolean(dr["QuantityFlag"].ToString()); apiObject.IsDelete = UtilityLib.FormatBoolean(dr["IsDelete"].ToString()); apiObject.ProcessDuration = UtilityLib.FormatDate(dr["ProcessDuration"]).ToString(); apiObject.ProcessVolume = UtilityLib.FormatFloat(dr["ProcessVolume"]); //apiObject.CompanyId = (Guid)(dr["CompanyId"]); objFieldClassModelList.Add(apiObject); } } else { strReturnCode = "002"; strReturnMsg = "Fail-Record Not Found"; } strResult = strReturnCode + "|" + strReturnMsg; return(objFieldClassModelList); }