public List <Models.ExcelPriceList> ImportPrice(DataTable dt) { List <Models.ExcelPriceList> list = new List <Models.ExcelPriceList>(); // OfferActionType checkIsExist; OfferActionType actionTypes = OfferActionType.Non; DateTime StartDate = DateTime.Now; DateTime EndDate = DateTime.Now; //Getting the default Margin for reseller ViewModel.DefaultMargin.DefaultMarginResellers odjDMR = new DefaultMargin.DefaultMarginResellers(); Models.DefaultMargin defaultResellerMargin = odjDMR.GetDefaultMargin(); //Getting the default Margin for Customer ViewModel.DefaultMargin.DefaultMarginUsers odjDMU = new DefaultMargin.DefaultMarginUsers(); Models.DefaultMargin defaultUserMargin = odjDMU.GetDefaultMargin(); foreach (DataRow item in dt.Rows) { if (item[0].ToString() != "A/C/D/U") { if (item[0].ToString() != "") { actionTypes = OfferActionTypes.ParseEnum <OfferActionType>(item[0].ToString()); //item["A/C/D/U"] } if (item[1].ToString() != "") { StartDate = Convert.ToDateTime(item[1].ToString()); //item["Valid-From Date"] } if (item[2].ToString() != "") { EndDate = Convert.ToDateTime(item[2].ToString()); //item["Valid To Date"] } AgreementType agreementTypes = AgreementTypes.ParseEnum <AgreementType>(item[5].ToString()); //item["License Agreement Type"] CustomerType customerTypes = CustomerTypes.ParseEnum <CustomerType>(item[8].ToString()); //item["End Customer Type"] LicenseType licenseTypes = LicenseTypes.ParseEnum <LicenseType>(item[7].ToString()); //item["Secondary License Type"] string[] unit = item[6].ToString().Split(' ');//item["Purchase Unit"] PurchaseUnit purchaseUnit = PurchaseUnits.ParseEnum <PurchaseUnit>(unit[1]); Models.ExcelPriceList _m = new Models.ExcelPriceList(); _m.ActionType = Convert.ToInt16(actionTypes); _m.AgreementType = Convert.ToInt16(agreementTypes); _m.CustomerType = Convert.ToInt16(customerTypes); _m.LicenseType = Convert.ToInt16(licenseTypes); _m.PurchaseUnitNumber = Convert.ToInt16(unit[0]); _m.PurchaseUnit = Convert.ToInt16(purchaseUnit); _m.MicrosoftId = item[4].ToString();//item["Offer ID"] _m.StartDate = StartDate; _m.EndDate = EndDate; _m.Price = float.Parse(item[9].ToString()); //item["List Price"] _m.Name = item[3].ToString(); _m.CustomerPrice = item[10].ToString() != "" && item[10].ToString() != " " ? Convert.ToDouble(item[10].ToString()) : Convert.ToDouble((_m.Price * defaultUserMargin.DefaultPercentage / 100) + _m.Price); //item["ERP Price"] _m.ResellerPrice = 0; //item[11].ToString() != "" && item[11].ToString() != " " ? Convert.ToDouble(item[11].ToString()) : Convert.ToDouble(((_m.Price * defaultResellerMargin.DefaultPercentage / 100) + _m.Price));//item["Reseller Price"] list.Add(_m); } } return(list); }
public ActionResult DefaultMarginResellers(Models.DefaultMargin d) { if (ModelState.IsValid) { ViewModel.DefaultMargin.DefaultMarginResellers defaultMarginResellers = new ViewModel.DefaultMargin.DefaultMarginResellers(); defaultMarginResellers.CheckIfExist(d); } return(View()); }
public virtual string CheckIfExist(Models.DefaultMargin d, int ResellerId = 0) { d.CreatedDate = DateTime.Now; var db = new Context.ConnectionStringsContext(); if (db.DefaultMargin.Any(m => m.Role == (int)d.Role && m.ResellerId == ResellerId)) //Update { return(EditDefaultMargin(d)); } else //Add { return(AddDefaultMargin(d)); } }
public virtual string AddDefaultMargin(Models.DefaultMargin d) { try { var db = new Context.ConnectionStringsContext(); db.DefaultMargin.Add(d); db.SaveChanges(); return("Successfully Saved"); } catch (Exception ex) { return("Unknown error occur, Please try again."); } }
public virtual string EditDefaultMargin(Models.DefaultMargin d) { try { var db = new Context.ConnectionStringsContext(); Models.DefaultMargin defaultMargin = db.DefaultMargin.Where(m => m.Id == d.Id).SingleOrDefault(); defaultMargin.DefaultPercentage = d.DefaultPercentage; db.SaveChanges(); return("Successfully Updated"); } catch (Exception ex) { return("Unknown error occur, Please try again."); } }
public override string CheckIfExist(Models.DefaultMargin d, int ResellerId = 0) { d.Role = (int)Models.Roles.Resellers; return(base.CheckIfExist(d)); }
public override string EditDefaultMargin(Models.DefaultMargin d) { return(base.EditDefaultMargin(d)); }
public override string AddDefaultMargin(Models.DefaultMargin d) { d.Role = (int)Roles.Resellers; d.ResellerId = 0; return(base.AddDefaultMargin(d)); }