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 <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); }