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