/// <summary> /// /// </summary> /// <param name="brandName"></param> /// <returns></returns> public Entities.Brand GetBrandDetailsByName(string brandName) { var brand = new Entities.Brand(); using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetBrandDetailsByName)) { database.AddInParameter(dbCommand, "@brand_name", DbType.String, brandName); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var _brand = new Entities.Brand { BrandId = DRE.GetNullableInt32(reader, "brand_id", 0), BrandName = DRE.GetNullableString(reader, "brand_name", null), guid = DRE.GetNullableGuid(reader, "row_guid", null) }; brand = _brand; } } } return(brand); }
/// <summary> /// /// </summary> /// <returns></returns> public List <Entities.Brand> GetAllBrands() { var brands = new List <Entities.Brand>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllBrands)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var brand = new Entities.Brand { BrandId = DRE.GetNullableInt32(reader, "brand_id", 0), BrandName = DRE.GetNullableString(reader, "brand_name", null), guid = DRE.GetNullableGuid(reader, "row_guid", null), SrNo = DRE.GetNullableInt64(reader, "sr_no", null) }; brands.Add(brand); } } } } catch (Exception ex) { throw ex; } return(brands); }
public Entities.User GetUserDetails(string username, string password) { var userId = 0; var user = new Entities.User(); DbCommand dbCommand = null; try { userId = VerifyUser(username, password); if (userId > 0) { using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetUserDetailsById)) { database.AddInParameter(dbCommand, "@user_id", DbType.Int32, userId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var _user = new Entities.User { UserId = userId, FullName = DRE.GetNullableString(reader, "full_name", null), RoleId = DRE.GetNullableInt32(reader, "role_id", 0), RoleName = DRE.GetNullableString(reader, "role_name", null), guid = DRE.GetNullableGuid(reader, "row_guid", null) }; user = _user; } } } } else { var _user = new Entities.User { UserId = 0 }; user = _user; } } catch (Exception e) { throw e; } finally { dbCommand = null; } return(user); }
/// <summary> /// /// </summary> /// <param name="companyId"></param> /// <returns></returns> public Entities.Company GetCompanyDetailsById(Int32 companyId) { var companyDetails = new Entities.Company(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetCompanyDetailsById)) { database.AddInParameter(dbCommand, "@company_id", DbType.Int32, companyId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var company = new Entities.Company { CompanyId = DRE.GetNullableInt32(reader, "company_id", 0), CompanyCode = DRE.GetNullableString(reader, "company_code", null), CompanyName = DRE.GetNullableString(reader, "company_name", null), ShortName = DRE.GetNullableString(reader, "short_name", null), CompanyAddress = DRE.GetNullableString(reader, "company_address", null), CountryId = DRE.GetNullableInt32(reader, "country_id", null), CountryName = DRE.GetNullableString(reader, "country_name", null), StateId = DRE.GetNullableInt32(reader, "state_id", null), StateName = DRE.GetNullableString(reader, "state_name", null), CityId = DRE.GetNullableInt32(reader, "city_id", null), CityName = DRE.GetNullableString(reader, "city_name", null), Locality = DRE.GetNullableString(reader, "locality", null), Website = DRE.GetNullableString(reader, "website", null), GSTINNo = DRE.GetNullableString(reader, "gstin_no", null), ContactPerson = DRE.GetNullableString(reader, "contact_person", null), ContactNo = DRE.GetNullableString(reader, "contact_no", null), EmailId = DRE.GetNullableString(reader, "email_id", null), guid = DRE.GetNullableGuid(reader, "row_guid", null) }; companyDetails = company; } } } } catch (Exception ex) { throw ex; } return(companyDetails); }
/// <summary> /// / /// </summary> /// <returns></returns> public List <Entities.Pettycash> GetAllPettyCashDocno() { var Pettys = new List <Entities.Pettycash>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllPettycase)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var Petty = new Entities.Pettycash { PettycaseId = DRE.GetNullableInt32(reader, "pettycase_id", 0), DocNo = DRE.GetNullableString(reader, "docno", null), EntryDate = DRE.GetNullableString(reader, "Date", null), DateRange = DRE.GetNullableString(reader, "daterange", null), AccountHead = DRE.GetNullableString(reader, "account_head_name", null), Supplier = DRE.GetNullableString(reader, "nameofsupplier", null), VoucherNo = DRE.GetNullableString(reader, "voucherno", null), Amount = DRE.GetNullableDecimal(reader, "Amount", 0), guid = DRE.GetNullableGuid(reader, "row_guid", null), SrNo = DRE.GetNullableInt64(reader, "sr_no", null) }; Pettys.Add(Petty); } } } } catch (Exception ex) { throw ex; } return(Pettys); }
public List <Entities.ModeOfPayment> GetAllModeOfPayments() { var modeOfPayments = new List <Entities.ModeOfPayment>(); DbCommand dbCommand = null; try { using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllModeOfPayments)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var modeOfPayment = new Entities.ModeOfPayment { ModeOfPaymentId = DRE.GetNullableInt32(reader, "mode_of_payment_id", 0), PaymentMode = DRE.GetNullableString(reader, "mode_of_payment", null), guid = DRE.GetNullableGuid(reader, "row_guid", null) }; modeOfPayments.Add(modeOfPayment); } } } } catch (Exception ex) { throw ex; } finally { dbCommand = null; } return(modeOfPayments); }