// GET: CorporateEmployeeGrades
public ActionResult Index()
{
try
{
CLayer.CityEntitle CityClassList = new CLayer.CityEntitle();
ViewBag.CityEntitle = new CorporateCityEntitlement()
{
GradeId = 0, GradeCode = "", Gradedescription = ""
};
return(View(CityClassList));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/ErrorPage"));
}
}
public ActionResult Savedetails(string ClsID, string Amount, Models.CorporateCityEntitlement data)
{
try
{
CLayer.CityEntitle details = new CLayer.CityEntitle();
details.GradeId = data.GradeId;
details.DefaultAmount = data.DefaultAmount;
string[] classid;
string[] classAmt;
classid = ClsID.Split(',');
classAmt = Amount.Split(',');
CLayer.CityEntitleSvaeRslt Rslt = BLayer.CityEntitle.Savedetails(classid, classAmt, details);
return(Json(Rslt, "application/json", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/ErrorPage"));
}
}
public static CLayer.CityEntitleSvaeRslt Savedetails(string[] ClsID, string[] Amount, CLayer.CityEntitle data)
{
DataLayer.CityEntitle Save = new DataLayer.CityEntitle();
return(Save.Savedetails(ClsID, Amount, data));
}
public CLayer.CityEntitleSvaeRslt Savedetails(string[] ClsID, string[] Amount, CLayer.CityEntitle data)
{
CLayer.CityEntitleSvaeRslt rslt = new CLayer.CityEntitleSvaeRslt();
List <DataPlug.Parameter> param1 = new List <DataPlug.Parameter>();
param1.Add(Connection.GetParameter("pDefaultAmt", DataPlug.DataType._Decimal, data.DefaultAmount));
param1.Add(Connection.GetParameter("pGradeID", DataPlug.DataType._BigInt, data.GradeId));
Connection.ExecuteQueryScalar("entitlements_Update", param1);
for (int i = 0; i <= ClsID.Length - 1; i++)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pClsID", DataPlug.DataType._BigInt, ClsID[i]));
param.Add(Connection.GetParameter("pClsAmt", DataPlug.DataType._Decimal, Amount[i]));
param.Add(Connection.GetParameter("pGradeID", DataPlug.DataType._BigInt, data.GradeId));
rslt.Result = Connection.ExecuteQueryScalar("entitlements_Save", param).ToString();
}
return(rslt);
}
