public long AddDesignation(designation designation) { try { designation insertDesignation = new designation { sales_designation = designation.sales_designation, sales_person_type_code = designation.sales_person_type_code, parent_designation_id = designation.parent_designation_id, sales_type_id = designation.sales_type_id, created_by = designation.created_by, updated_by = designation.updated_by, created_date = designation.created_date, updated_date = designation.updated_date }; _entities.designations.Add((insertDesignation)); _entities.SaveChanges(); long lastInsertId = insertDesignation.sales_designation_id; return(lastInsertId); } catch (Exception ex) { throw ex; } }
public long AddProductVersion(product_version product_version, long created_by) { try { product_version insert_product_version = new product_version { product_version_name = product_version.product_version_name, created_by = created_by, created_date = DateTime.Now, updated_by = created_by, updated_date = DateTime.Now, is_active = true, is_deleted = false, }; _entities.product_version.Add(insert_product_version); _entities.SaveChanges(); long last_insert_id = insert_product_version.product_version_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public long PartyJournalEntry(string transactionType, long partyId, decimal transactionAmount, string remarks, long userId, string documentCode) { try { // GET TRANSACTION CONFIGURATION var tranConfig = _entities.transaction_configuration.FirstOrDefault(w => w.transaction_type == transactionType); if (tranConfig != null) { party_journal partyJournal = new party_journal { transaction_date = DateTime.Now, transaction_type = transactionType, party_id = partyId, opening_balance = 0, dr_amount = 0, cr_amount = 0, closing_balance = 0, remarks = remarks, created_by = userId, document_code = documentCode, created_date = DateTime.Now, updated_by = userId, updated_date = DateTime.Now, }; // GET OPENNIG BALANCE var partyTransaction = _entities.party_journal.Where(w => w.party_id == partyId) .OrderByDescending(o => o.party_journal_id) .FirstOrDefault(); decimal closingBalance = 0; if (partyTransaction != null) { closingBalance = partyTransaction.closing_balance ?? 0; } partyJournal.opening_balance = closingBalance; // DEBIT OR CREDIT if (tranConfig.is_dr ?? false) { partyJournal.dr_amount = transactionAmount; } else if (tranConfig.is_cr ?? false) { partyJournal.cr_amount = transactionAmount; } partyJournal.closing_balance = partyJournal.opening_balance + partyJournal.dr_amount - partyJournal.cr_amount; // INSERT PARTY JOURNAL _entities.party_journal.Add(partyJournal); _entities.SaveChanges(); return(partyJournal.party_journal_id); } } catch (Exception) { return(0); } return(0); }
public long AddProductCategory(product_category product_category) { try { product_category insert_product_category = new product_category { product_category_name = product_category.product_category_name, product_category_code = product_category.product_category_code, //created_by = created_date = DateTime.Now, //updated_by = updated_date = DateTime.Now, is_active = true, is_deleted = false, }; _entities.product_category.Add(insert_product_category); _entities.SaveChanges(); long last_insert_id = insert_product_category.product_category_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public long AddUser(user aUser) { try { var hashPassword = PasswordHash.HashPassword(aUser.password); var newUser = new user { full_name = aUser.full_name, password = hashPassword, role_id = aUser.role_id, login_name = aUser.login_name, branch_id = aUser.branch_id, party_id = aUser.party_id, company_id = aUser.company_id, is_new_pass = aUser.is_new_pass, emp_id = aUser.emp_id }; _entities.users.Add(newUser); _entities.SaveChanges(); long newUserId = newUser.user_id; return(newUserId); } catch (Exception ex) { return(0); } }
public long Addbrand(brand brand) { try { brand insert_brand = new brand { brand_name = brand.brand_name, //created_by = created_date = DateTime.Now, //updated_by = updated_date = DateTime.Now, is_active = true, is_deleted = false, }; _entities.brands.Add(insert_brand); _entities.SaveChanges(); long last_insert_id = insert_brand.brand_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public bool AddVersionMapping(product_version_mapping productVersion, long create_by) { try { var product = new product_version_mapping(); product.product_version_id = productVersion.product_version_id; product.created_by = create_by; product.is_active = productVersion.is_active; product.product_id = productVersion.product_id; product.created_date = DateTime.Now; _entities.product_version_mapping.Add(product); int save = _entities.SaveChanges(); if (save > 0) { return(true); } else { return(false); } } catch (Exception) { return(false); } }
public long PostAccessories(inventory_adjustment inventory_adjustment) { try { inventory_adjustment insertInventoryAdjustment = new inventory_adjustment { adjustment_type = inventory_adjustment.adjustment_type, warehouse_id = inventory_adjustment.warehouse_id, contra_warehouse_id = inventory_adjustment.contra_warehouse_id, product_id = inventory_adjustment.product_id, system_quantity = inventory_adjustment.system_quantity, physical_quantity = inventory_adjustment.physical_quantity, adjustment_quantity = inventory_adjustment.adjustment_quantity, status = inventory_adjustment.status, created_by = inventory_adjustment.created_by, created_date = inventory_adjustment.created_date, updated_by = inventory_adjustment.created_by, updated_date = inventory_adjustment.updated_date }; _entities.inventory_adjustment.Add(insertInventoryAdjustment); _entities.SaveChanges(); long last_insert_id = insertInventoryAdjustment.inventory_adjustment_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public bool InsertControl(control ocontrol) { try { control Insert_control = new control(); Insert_control = new control { control_name = ocontrol.control_name, control_parent_id = ocontrol.control_parent_id, control_type_id = ocontrol.control_type_id, control_sort = ocontrol.control_sort, control_alias = ocontrol.control_alias, control_controller = ocontrol.control_controller, control_action = ocontrol.control_action, created_by = ocontrol.created_by, created_date = ocontrol.created_date, updated_by = ocontrol.updated_by, updated_date = ocontrol.updated_date, company_id = ocontrol.company_id, is_active = ocontrol.is_active, Level = ocontrol.Level, icon = ocontrol.icon }; var exists_control = _entities.controls.Where(con => con.control_name == ocontrol.control_name).FirstOrDefault(); _entities.controls.Add(Insert_control); _entities.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool InsertMailReceiverSetting(mail_receiver_setting oMailReceiverSetting) { try { mail_receiver_setting insertMailReceiverSetting = new mail_receiver_setting { process_code_id = oMailReceiverSetting.process_code_id, receiver_name = oMailReceiverSetting.receiver_name, receiver_email = oMailReceiverSetting.receiver_email, created_by = oMailReceiverSetting.created_by, created_date = oMailReceiverSetting.created_date, updated_by = oMailReceiverSetting.updated_by, updated_date = oMailReceiverSetting.updated_date, is_active = oMailReceiverSetting.is_active, is_deleted = oMailReceiverSetting.is_deleted }; _entities.mail_receiver_setting.Add(insertMailReceiverSetting); _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public int Save(SetupBranchViewModel model) { //var user = Userprovider.CustomeUserManager.GetUserDetails(); SetupBranch setupBranchEntity = new SetupBranch(); var data = _ent.SetupBranches.Where(x => x.BranchName == model.BranchName.Trim() && x.HeadOfficeId == model.HeadOfficeId && x.DeletedDate == null).ToList(); if (data.Count > 0) { return(2); } setupBranchEntity.BranchCode = model.BranchName; setupBranchEntity.HeadOfficeId = model.HeadOfficeId ?? 0; setupBranchEntity.BranchName = model.BranchName; setupBranchEntity.ImageName = model.ImageName; setupBranchEntity.ImagePath = model.ImagePath; setupBranchEntity.Location = model.Location; setupBranchEntity.State = model.State; setupBranchEntity.District = model.District; setupBranchEntity.Metropolitan = model.Metropolitan; setupBranchEntity.SubMetropolitan = model.SubMetropolitan; setupBranchEntity.Municipality = model.Municipality; setupBranchEntity.GauPalika = model.GauPalika; setupBranchEntity.WardNo = model.WardNo; setupBranchEntity.EmailId = model.EmailId; setupBranchEntity.Web = model.Web; setupBranchEntity.PhoneNumber = model.PhoneNumber; setupBranchEntity.PanNo = model.PanNo; setupBranchEntity.VatNo = model.VatNo; setupBranchEntity.EstablishDate = model.EstablishDate; setupBranchEntity.RegisteredDate = model.RegisteredDate; if (model.BranchId > 0) { setupBranchEntity.Status = model.Status; setupBranchEntity.UpdatedBy = 1;// user.UserId; setupBranchEntity.BranchId = model.BranchId; setupBranchEntity.UpdatedDate = DateTime.UtcNow; _ent.Entry(setupBranchEntity).State = EntityState.Modified; _ent.Entry(setupBranchEntity).Property(x => x.CreatedBy).IsModified = false; _ent.Entry(setupBranchEntity).Property(x => x.CreatedDate).IsModified = false; } else { setupBranchEntity.Status = true; setupBranchEntity.CreatedBy = 1;// user.UserId; setupBranchEntity.CreatedDate = DateTime.UtcNow; _ent.Entry(setupBranchEntity).State = EntityState.Added; } try { _ent.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }
public bool AddProductPriceing(product_price_mapping productPrice, long create_by) { try { var priceing = new product_price_mapping(); priceing.product_id = productPrice.product_id; priceing.product_version_id = productPrice.product_version_id; priceing.color_id = productPrice.color_id; priceing.is_active = productPrice.is_active; priceing.created_by = create_by; priceing.created_date = DateTime.Now; priceing.b2b_cost = productPrice.b2b_cost; priceing.corporate_cost = productPrice.corporate_cost; priceing.dealer_cost = productPrice.dealer_cost; priceing.emi_cost = productPrice.emi_cost; priceing.gift_cost = productPrice.gift_cost; priceing.internal_cost = productPrice.internal_cost; priceing.online_cost = productPrice.online_cost; priceing.telco_cost = productPrice.telco_cost; priceing.is_deleted = false; priceing.land_cost = productPrice.land_cost; priceing.fin_cost = productPrice.fin_cost; priceing.incentive_cost = productPrice.incentive_cost; priceing.price_protection = productPrice.price_protection; priceing.promotional_cost = productPrice.promotional_cost; priceing.marketing_cost = productPrice.marketing_cost; priceing.distribution_cost = productPrice.distribution_cost; priceing.qc_cost = productPrice.qc_cost; priceing.we_wifi = productPrice.we_wifi; priceing.we_cloud = productPrice.we_cloud; priceing.cost_price = productPrice.cost_price; priceing.package_cost = productPrice.package_cost; priceing.total_package_cost = productPrice.total_package_cost; priceing.amra_margin = productPrice.amra_margin; priceing.dealer_margin = productPrice.dealer_margin; priceing.retailer_margin = productPrice.retailer_margin; priceing.retailer_cost = productPrice.retailer_cost; priceing.mrp_cost = productPrice.mrp_cost; priceing.last_grn_no = productPrice.last_grn_no; _entities.product_price_mapping.Add(priceing); int save = _entities.SaveChanges(); if (save > 0) { return(true); } else { return(false); } } catch (Exception) { return(false); } }
public int Save(SetupHeadOfficeViewModel model) { SetupHaeadOffice headOfficeEntity = new SetupHaeadOffice(); var data = (_ent.SetupHaeadOffices.Where(h => h.HeadOfficeName == model.HeadOfficeName.Trim() && h.DeletedDate == null)).ToList(); if (data.Count > 0) { return(2); } headOfficeEntity.HeadOfficeCode = model.HeadOfficeCode; headOfficeEntity.HeadOfficeName = model.HeadOfficeName; headOfficeEntity.ImageName = model.ImageName; headOfficeEntity.ImagePath = model.ImagePath; headOfficeEntity.Location = model.Location; headOfficeEntity.State = model.State; headOfficeEntity.District = model.District; headOfficeEntity.Metropolitan = model.Metropolitan; headOfficeEntity.SubMetropolitan = model.SubMetropolitan; headOfficeEntity.Municipality = model.Municipality; headOfficeEntity.GauPalika = model.GauPalika; headOfficeEntity.WardNo = model.WardNo; headOfficeEntity.EmailId = model.EmailId; headOfficeEntity.Web = model.Web; headOfficeEntity.PhoneNumber = model.PhoneNumber; headOfficeEntity.PanNo = model.PanNo; headOfficeEntity.VatNo = model.VatNo; headOfficeEntity.EstablishDate = model.EstablishDate; headOfficeEntity.RegisteredDate = model.RegisteredDate; if (model.HeadOfficeId > 0) { headOfficeEntity.HeadOfficeId = model.HeadOfficeId; headOfficeEntity.Status = model.Status; headOfficeEntity.UpdatedBy = 1; headOfficeEntity.UpdatedDate = DateTime.UtcNow; _ent.Entry(headOfficeEntity).State = EntityState.Modified; _ent.Entry(headOfficeEntity).Property(x => x.CreatedBy).IsModified = false; _ent.Entry(headOfficeEntity).Property(x => x.CreatedDate).IsModified = false; } else { headOfficeEntity.Status = true; headOfficeEntity.CreatedBy = 1; headOfficeEntity.CreatedDate = DateTime.UtcNow; _ent.Entry(headOfficeEntity).State = EntityState.Added; } try { _ent.SaveChanges(); return(1); } catch (Exception) { return(0); } }
public ActionResult Create([Bind(Include = "id,Name,Supplier,Title,StartDate,EndDate,TimeH,TimeM,AllDay")] Schedule schedule) { if (ModelState.IsValid) { db.Schedules.Add(schedule); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(schedule)); }
public bool InsertDealerType(dealer_type objDealerType, long created_by) { try { _entities.dealer_type.Add(objDealerType); _entities.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool AddTermsAndCondition(terms_and_condition objTermsAndCondition) { try { _entities.terms_and_condition.Add(objTermsAndCondition); _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public long AddEmployee(EmployeeModel employeeModel) { try { var insertEmployee = new employee { employee_name = employeeModel.employee_name, date_of_birth = employeeModel.date_of_birth, date_of_join = employeeModel.date_of_join, department_id = employeeModel.department_id, designation_id = employeeModel.designation_id, email_address = employeeModel.email_address, mobile_number = employeeModel.mobile_number, address = employeeModel.address, gender = employeeModel.gender, marital_status = employeeModel.marital_status, blood_group = employeeModel.blood_group, region_id = employeeModel.region_id, area_id = employeeModel.area_id, territory_id = employeeModel.territory_id, is_active = employeeModel.is_active, is_deleted = false, created_date = DateTime.Now, created_by = employeeModel.created_by, updated_date = DateTime.Now, updated_by = employeeModel.updated_by }; _entities.employees.Add(insertEmployee); _entities.SaveChanges(); long lastEmployeeId = insertEmployee.employee_id; if (employeeModel.is_user) { var hashPassword = PasswordHash.HashPassword(employeeModel.password); user insert_user = new user { full_name = employeeModel.employee_name, password = hashPassword, role_id = employeeModel.role_id, login_name = employeeModel.login_name, company_id = 2, is_new_pass = true, emp_id = lastEmployeeId, party_id = 1, created_by = employeeModel.created_by, created_date = DateTime.Now, is_active = true, is_deleted = false }; _entities.users.Add(insert_user); _entities.SaveChanges(); return(lastEmployeeId); } return(0); } catch (Exception ex) { return(0); } }
public bool InsertBank(bank oBank) { try { _entities.banks.Add(oBank); _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public long AddCompany(company objCompany) { try { _entities.companies.Add(objCompany); _entities.SaveChanges(); long last_insert_id = objCompany.company_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public bool InsertSbu(sbu oSbu) { try { _entities.sbus.Add(oSbu); _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertPaymentMethod(payment_method payment_method, long?created_by) { payment_method insert_payment_method = new payment_method { payment_method_name = payment_method.payment_method_name, is_active = true, is_deleted = false, created_by = created_by, created_date = DateTime.Now, }; _entities.payment_method.Add(insert_payment_method); _entities.SaveChanges(); return(true); }
//receiving the verified returned imei public bool ReceivingVerifiedIMEI(long return_details_id) { try { return_details rdetails = _entities.return_details.Find(return_details_id); rdetails.verify_status = true; rdetails.verify_date = DateTime.Now; _entities.SaveChanges(); return(true); } catch (Exception) { throw; } }
public void CreateClient(Client client) { using (DMSEntities dmsEntities = this.dmsEntities){ dmsEntities.Client.Add(client); dmsEntities.SaveChanges(); } }
public static bool InsertProduct(Dealer productItem) { bool status; try { DbContext.Dealers.Add(productItem); DbContext.SaveChanges(); status = true; } catch (Exception) { status = false; } return(status); }
public IHttpActionResult PostUser(UserDto user) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (DMSEntities dbContext = new DMSEntities()) { dbContext.users.Add(new user() { //user_id = user.user_id, first_name = user.first_name, last_name = user.last_name, role = user.role, location = user.role, Username = user.username, Mail = user.mail, Password = user.password, }); dbContext.SaveChanges(); } return(Ok()); }
public void CreateProductionType(ProductionType productionType) { using (DMSEntities dmsEntities = this.dmsEntities) { dmsEntities.ProductionType.Add(productionType); dmsEntities.SaveChanges(); } }
public long AddSupplier(supplier objSupplier) { try { int suppliersCode = _entities.suppliers.Max(sp => (int?)sp.supplier_id) ?? 0; suppliersCode++; var spStr = suppliersCode.ToString().PadLeft(7, '0'); string SupplierCode = "SUP" + "-" + spStr; supplier insert_supplier = new supplier { supplier_name = objSupplier.supplier_name, supplier_code = SupplierCode, supplier_type_id = objSupplier.supplier_type_id, company_address = objSupplier.company_address, factory_address = objSupplier.factory_address, phone = objSupplier.phone, mobile = objSupplier.mobile, email = objSupplier.email, email2 = objSupplier.email2, contact_person = objSupplier.contact_person, contact_person2 = objSupplier.contact_person2, total_debit = objSupplier.total_debit, total_credit = objSupplier.total_credit, balance = objSupplier.balance, vat_id = objSupplier.vat_id, tin_no = objSupplier.tin_no, receiving_company_name = objSupplier.receiving_company_name, receiving_company_person = objSupplier.receiving_company_person, receiving_company_contact_email = objSupplier.receiving_company_contact_email, is_active = true, is_deleted = objSupplier.is_deleted = false, created_by = objSupplier.created_by, created_date = objSupplier.created_date = DateTime.Now }; _entities.suppliers.Add(insert_supplier); _entities.SaveChanges(); long last_insert_id = insert_supplier.supplier_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public long AddColor(color color) { try { color insert_color = new color { color_name = color.color_name }; _entities.colors.Add(insert_color); _entities.SaveChanges(); long last_insert_id = insert_color.color_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public bool InsertSalesType(sales_type objSalesType) { try { sales_type sales = new sales_type { sales_type1 = objSalesType.sales_type1, is_active = objSalesType.is_active, }; _entities.sales_type.Add(sales); _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertDepartment(department oDepartment) { try { department insertdepartment = new department { department_name = oDepartment.department_name, is_active = oDepartment.is_active, }; _entities.departments.Add(insertdepartment); _entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }