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