public ActionResult GetDetails(long id)
{
try
{
Session["id"] = id;
Models.APIUserModel cm = new Models.APIUserModel();
if (id != 0)
{
CLayer.APIPriceMarkup usr = BLayer.APIPriceMarkup.Get(id);
if (usr != null)
{
cm.APIPriceMarkupCode = usr.APIPriceMarkupCode;
cm.CustomerId = usr.CustomerId;
cm.CustomerName = usr.CustomerName;
cm.DescriptionId = usr.DescriptionId;
cm.SellPrice = usr.SellMarkup;
}
}
return(View("_Details", cm));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
Redirect("~/ErrorPage");
}
return(View());
}
//Added by rahul for Saving New API Markup price in edit for new Screen on 30-01-2020
public int SaveNewAPIMarkup(CLayer.APIPriceMarkup API)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, API.APIPriceMarkupCode));
param.Add(Connection.GetParameter("pSellMarkup", DataPlug.DataType._Varchar, API.SellMarkup));
int result = Connection.ExecuteQuery("sp_new_api_pricemarkup_save", param);
return(result);
}
//----END-----
public int Save(CLayer.APIPriceMarkup API)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, API.APIPriceMarkupCode));
param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Int, API.DescriptionId));
param.Add(Connection.GetParameter("pCustomerID", DataPlug.DataType._Varchar, API.CustomerId));
param.Add(Connection.GetParameter("pSellMarkup", DataPlug.DataType._Varchar, API.SellMarkup));
int result = Connection.ExecuteQuery("sp_api_pricemarkup_save", param);
return(result);
}
//Added by rahul for Listing New API Markup price in edit for new Screen on 30-01-2020
public CLayer.APIPriceMarkup GetNewAPIDetails(long id)
{
CLayer.APIPriceMarkup user = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pID", DataPlug.DataType._BigInt, id));
DataTable dt = Connection.GetTable("sp_new_api_pricemarkup_get", param);
if (dt.Rows.Count > 0)
{
user = new CLayer.APIPriceMarkup();
user.APIPriceMarkupCode = Connection.ToLong(dt.Rows[0]["pricemarkup_code"]);
user.DescriptionId = Connection.ToInteger(dt.Rows[0]["description"]);
user.SellMarkup = Connection.ToString(dt.Rows[0]["markup_per"]);
}
return(user);
}
public ActionResult SaveDetails(Models.APIUserModel data)
{
try
{
CLayer.APIPriceMarkup API = new CLayer.APIPriceMarkup();
{
API.APIPriceMarkupCode = data.APIPriceMarkupCode;
API.SellMarkup = data.SellPrice;
};
BLayer.APIPriceMarkup.SaveNewAPIMarkup(API);
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
}
return(RedirectToAction("Index"));
}
//-----END------
public CLayer.APIPriceMarkup Get(long id)
{
CLayer.APIPriceMarkup user = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pID", DataPlug.DataType._BigInt, id));
DataTable dt = Connection.GetTable("sp_api_pricemarkup_get", param);
if (dt.Rows.Count > 0)
{
user = new CLayer.APIPriceMarkup();
user.APIPriceMarkupCode = Connection.ToLong(dt.Rows[0]["api_pricemarkup_code"]);
user.DescriptionId = Connection.ToInteger(dt.Rows[0]["api_code"]);
user.CustomerId = Connection.ToLong(dt.Rows[0]["customer_id"]);
user.SellMarkup = Connection.ToString(dt.Rows[0]["sell_markup_inPercentage"]);
user.CustomerName = Connection.ToString(dt.Rows[0]["Name"]);
}
return(user);
}
//Added by rahul for Saving New API Markup price in edit for new Screen on 30-01-2020
public static int SaveNewAPIMarkup(CLayer.APIPriceMarkup t)
{
DataLayer.APIPriceMarkup API = new DataLayer.APIPriceMarkup();
return(API.SaveNewAPIMarkup(t));
}
//---END-----
public static int Save(CLayer.APIPriceMarkup t)
{
DataLayer.APIPriceMarkup API = new DataLayer.APIPriceMarkup();
// t.Validate();
return(API.Save(t));
}
