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