public UserMaster GetUserdetailsByUsernameAndRole(string name, string userRole)
{
UserMaster userMaster = new UserMaster();
using (var context = new InvoiceGenEntities())
{
userMaster = (from a in context.UserMasters
where a.UserName == name
select a).FirstOrDefault();
var userRoleMapping = (from a in context.UserRoleMappings
where a.UserId == userMaster.ID
select a).FirstOrDefault();
var rolemaster = (from a in context.RoleMasters
where a.ID == userRoleMapping.RoleId
select a).FirstOrDefault();
if (string.Equals(rolemaster.RoleName, userRole, StringComparison.InvariantCultureIgnoreCase))
{
return(userMaster);
}
else
{
return(null);
}
}
}
public List <Operations> GetOperationListForUser(long userId)
{
List <Operations> opList = new List <Operations>();
using (var context = new InvoiceGenEntities())
{
var userRoleMapping = (from a in context.UserRoleMappings
where a.UserId == userId
select a).FirstOrDefault();
var rolemaster = (from a in context.RoleMasters
where a.ID == userRoleMapping.RoleId
select a).FirstOrDefault();
List <RoleOperationMapping> roleOpMapping = new List <RoleOperationMapping>();
roleOpMapping = (from a in context.RoleOperationMappings
where a.RoleId == userRoleMapping.RoleId
select a).ToList();
foreach (RoleOperationMapping opMapp in roleOpMapping)
{
Operations op = new Operations();
OperationMaster opm = new OperationMaster();
opm = (from a in context.OperationMasters
where a.ID == opMapp.OperationId
select a).FirstOrDefault();
if (opm != null)
{
op.OperationName = opm.OperationName;
opList.Add(op);
}
}
}
return(opList);
}
public long CreateNewProduct(ProductsMaster products)
{
using (var context = new InvoiceGenEntities())
{
context.ProductsMasters.Add(products);
context.SaveChanges();//this generates the Id for customer
return(products.ID);
}
}
public long SaveCustomerProductMapping(CustomerProductMapping customerProductMapping)
{
using (var context = new InvoiceGenEntities())
{
context.CustomerProductMappings.Add(customerProductMapping);
context.SaveChanges();//this generates the Id for customer
return(customerProductMapping.ID);
}
}
public long CreateNewCustomer(Customer customer)
{
using (var context = new InvoiceGenEntities())
{
context.Customers.Add(customer);
context.SaveChanges();//this generates the Id for customer
return(customer.ID);
}
}
public long CreateNewBill(BillMaster billMaster)
{
using (var context = new InvoiceGenEntities())
{
context.BillMasters.Add(billMaster);
context.SaveChanges();//this generates the Id for customer
return(billMaster.ID);
}
}
/// <summary>
/// Returns List of all products
/// </summary>
/// <returns></returns>
public List <ProductsMaster> GetAllProductList()
{
List <ProductsMaster> listProduct = new List <ProductsMaster>();
using (var context = new InvoiceGenEntities())
{
listProduct = (from a in context.ProductsMasters
where a.Name != null
select a).ToList();
}
return(listProduct);
}
public UserMaster GetUserdetailsByUsernamePass(string username, string passWord)
{
UserMaster userMaster = new UserMaster();
using (var context = new InvoiceGenEntities())
{
userMaster = (from a in context.UserMasters
where a.UserName == username && a.password == passWord
select a).FirstOrDefault();
}
return(userMaster);
}
/// <summary>
/// Returns List of all products
/// </summary>
/// <returns></returns>
public List <Customer> GetAllProductList()
{
List <Customer> listCustomer = new List <Customer>();
using (var context = new InvoiceGenEntities())
{
listCustomer = (from a in context.Customers
where a.IsActive == true
select a).ToList();
}
return(listCustomer);
}
public List <ProductsMaster> GetProductListByProductName(string productName)
{
List <ProductsMaster> listProduct = new List <ProductsMaster>();
using (var context = new InvoiceGenEntities())
{
listProduct = (from a in context.ProductsMasters
where a.Name.Contains(productName)
select a).ToList();
}
return(listProduct);
}
public List <ProductsMaster> GetProducListByHSNSACCode(string hSNPrefix)
{
List <ProductsMaster> listProduct = new List <ProductsMaster>();
using (var context = new InvoiceGenEntities())
{
listProduct = (from a in context.ProductsMasters
where a.HSNCode.Contains(hSNPrefix) || a.SACCode.Contains(hSNPrefix)
select a).ToList();
}
return(listProduct);
}
public UserMaster GetUserdetailsByUsername(string name)
{
UserMaster userMaster = new UserMaster();
using (var context = new InvoiceGenEntities())
{
userMaster = (from a in context.UserMasters
where a.UserName == name
select a).FirstOrDefault();
}
return(userMaster);
}
public List <State> GetStateList()
{
List <State> listSate = new List <State>();
using (var context = new InvoiceGenEntities())
{
listSate = (from a in context.States
where a.Name != null
select a).ToList();
}
return(listSate);
}
public List <City> GetCityByStateID(string selectedState)
{
List <City> listCity = new List <City>();
int id = Convert.ToInt32(selectedState);
using (var context = new InvoiceGenEntities())
{
listCity = (from a in context.Cities
where a.StateID == id
select a).ToList();
}
return(listCity);
}
public State GetStateByID(string number)
{
State state = new State();
var query = "select s.Name,s.ID,null as country_id from GstStateCodes gst inner join States s on s.ID = gst.StateID where gst.GSTStateCode =";
query += Convert.ToString(number) + " ";
using (var context = new InvoiceGenEntities())
{
state = context.States
.SqlQuery(query)
.FirstOrDefault();
}
return(state);
}
public bool CreateNewProductBillMapping(BillProductMapping productBillMapp)
{
using (var context = new InvoiceGenEntities())
{
context.BillProductMappings.Add(productBillMapp);
context.SaveChanges();//this generates the Id for customer
}
if (productBillMapp.ID > 0)
{
return(true);
}
else
{
return(false);
}
}
public string GetStateNameByID(long?stateID)
{
State state = new State();
using (var context = new InvoiceGenEntities())
{
state = (from a in context.States
where a.ID == stateID
select a).FirstOrDefault();
}
if (state != null)
{
return(state.Name);
}
else
{
return(string.Format("State with ID:{0} Not Found !", stateID));
}
}
public string GetCityNameByID(long?cityID)
{
City city = new City();
using (var context = new InvoiceGenEntities())
{
city = (from a in context.Cities
where a.ID == cityID
select a).FirstOrDefault();
}
if (city != null)
{
return(city.Name);
}
else
{
return(string.Format("City with ID:{0} Not Found !", cityID));
}
}
/// <summary>
/// Saves List of Products to Database
/// </summary>
/// <param name="listProduct"></param>
public List <ProductsMaster> SaveProductsData(List <ProductsMaster> listProduct)
{
using (var context = new InvoiceGenEntities())
{
try
{
foreach (var product in listProduct)
{
ProductsMaster prod = new ProductsMaster();
if (product.HSNCode != null)
{
prod = context.ProductsMasters.SqlQuery("Select * from ProductsMaster where HSNCode=@HSNCode", new SqlParameter("@HSNCode", product.HSNCode)).FirstOrDefault();
}
else if (product.SACCode != null)
{
prod = context.ProductsMasters.SqlQuery("Select * from ProductsMaster where SACCode=@SACCode", new SqlParameter("@SACCode", product.SACCode)).FirstOrDefault();
}
if (prod == null)
{
context.ProductsMasters.Add(product);
context.SaveChanges();
}
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
throw new Exception(string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage));
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listProduct);
}
}
public string GetUserRole(long userID)
{
string role = string.Empty;
using (var context = new InvoiceGenEntities())
{
var userRoleMapping = (from a in context.UserRoleMappings
where a.UserId == userID
select a).FirstOrDefault();
var rolemaster = (from a in context.RoleMasters
where a.ID == userRoleMapping.RoleId
select a).FirstOrDefault();
if (rolemaster != null)
{
role = rolemaster.RoleName;
}
}
return(role);
}
public bool CheckIfCustomerExistByName(string name, out long customerID)
{
customerID = -1;
Customer customer = new Customer();
using (var context = new InvoiceGenEntities())
{
customer = (from a in context.Customers
where a.IsActive == true && a.Name == name
select a).FirstOrDefault();
}
if (customer == null)
{
return(false);
}
else
{
customerID = customer.ID;
return(true);
}
}
public bool CheckIfProductExistBySACode(string sACCode, out long productID)
{
productID = -1;
ProductsMaster productsMaster = new ProductsMaster();
using (var context = new InvoiceGenEntities())
{
productsMaster = (from a in context.ProductsMasters
where a.SACCode == sACCode
select a).FirstOrDefault();
}
if (productsMaster != null)
{
productID = productsMaster.ID;
return(true);
}
else
{
return(false);
}
}