//Update Rank
public static int UpdateRecord(etblRankManagement eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
bool checkExists = false;
checkExists = db.tblRankManagements.Any(
p => p.iPropId == eobj.iPropId &&
p.iID != eobj.iID &&
(((p.dtStartdate <= eobj.dtStartdate && p.dtEndDate >= eobj.dtStartdate) || (p.dtStartdate <= eobj.dtEndDate && p.dtEndDate >= eobj.dtEndDate)) ||
((eobj.dtStartdate <= p.dtStartdate && eobj.dtEndDate >= p.dtStartdate) || (eobj.dtStartdate <= p.dtEndDate && eobj.dtEndDate >= p.dtEndDate)))
);
if (checkExists != true)
{
OneFineRate.tblRankManagement obj = (OneFineRate.tblRankManagement)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRankManagement());
db.tblRankManagements.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public ActionResult Update(int Id)
{
etblRankManagement obj = new etblRankManagement();
obj = BL_tblRankManagement.GetRankManagementByID(Id);
obj.Mode = "Update";
obj.dtValidFrom = obj.dtStartdate.ToString("dd/MM/yyyy");
obj.dtValidTo = obj.dtEndDate.ToString("dd/MM/yyyy");
if (obj.IsSponsored == true)
{
obj.IsSponsoredYes = true;
obj.IsSponsoredNo = false;
}
else if (obj.IsSponsored == false)
{
obj.IsSponsoredYes = false;
obj.IsSponsoredNo = true;
}
else
{
obj.IsSponsoredYes = false;
obj.IsSponsoredNo = false;
}
if (obj.iNewRank == 0)
{
obj.iNewRank = null;
}
return(PartialView("pvRankManagement", obj));
}
public ActionResult Add()
{
etblRankManagement obj = new etblRankManagement();
obj.IsSponsored = true;
obj.Mode = "Add";
return(PartialView("pvRankManagement", obj));
}
public static etblRankManagement GetRankManagementByID(int a)
{
etblRankManagement promorec = new etblRankManagement();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var rec = (from m in db.tblRankManagements
join c in db.tblUserMs on m.iActionBy equals c.iUserId
select new
{
m.iID,
m.iPropId,
m.dtStartdate,
m.dtEndDate,
m.IsSponsored,
m.IsRateDisparity,
m.iNewRank,
m.iOldRank,
m.cStatus,
UserName = c.sFirstName + " " + c.sLastName,
m.dtActionDate,
m.iActionBy
}).Where(u => u.iID == a).AsQueryable();
var data = rec.ToList();
etblRankManagement objMain = new etblRankManagement();
objMain = (etblRankManagement)OneFineRateAppUtil.clsUtils.ConvertToObject(data[0], objMain);
promorec.iID = objMain.iID;
promorec.iPropId = objMain.iPropId;
promorec.dtStartdate = objMain.dtStartdate;
promorec.dtEndDate = objMain.dtEndDate;
promorec.IsSponsored = objMain.IsSponsored;
promorec.IsRateDisparity = objMain.IsRateDisparity;
promorec.iNewRank = objMain.iNewRank;
promorec.iOldRank = objMain.iOldRank;
promorec.cStatus = objMain.cStatus;
promorec.dtActionDate = objMain.dtActionDate;
promorec.iActionBy = objMain.iActionBy;
return(promorec);
}
}
//Delete Rank
public static int DeleteRecord(etblRankManagement eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblRankManagement obj = (OneFineRate.tblRankManagement)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRankManagement());
db.tblRankManagements.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public ActionResult Delete(int Id)
{
string strReturn = string.Empty;
try
{
etblRankManagement prop = new etblRankManagement();
prop = BL_tblRankManagement.GetRankManagementByID(Id);
if (prop.cStatus == "A")
{
prop.cStatus = "I";
}
else if (prop.cStatus == "I")
{
prop.cStatus = "A";
}
int val = BL_tblRankManagement.DeleteRecord(prop);
if (val == 1)
{
if (prop.cStatus == "I")
{
TempData["msg"] = "Disabled successfully";
}
else
{
TempData["msg"] = "Enabled successfully";
}
}
else
{
TempData["ERROR"] = "Kindly try after some time";
}
}
catch (Exception)
{
}
return(RedirectToAction("Index"));
}
public ActionResult Save(etblRankManagement prop)
{
string strReturn = string.Empty;
int val = 0;
object result = null;
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
string str;
str = "a";
// DoSomethingWith(error);
}
}
if (ModelState.IsValid)
{
#region Add Rank
if (prop.Mode == "Add")
{
etblRankManagement eobj = new etblRankManagement();
eobj.iPropId = prop.iPropId;
eobj.dtStartdate = clsUtils.ConvertddmmyyyytoDateTime(prop.dtValidFrom);
eobj.dtEndDate = clsUtils.ConvertddmmyyyytoDateTime(prop.dtValidTo);
if (prop.IsSponsoredYes == false && prop.IsSponsoredNo == false)
{
eobj.IsSponsored = null;
}
else
{
eobj.IsSponsored = prop.IsSponsoredYes;
}
eobj.IsRateDisparity = prop.IsRateDisparity;
if (prop.IsSponsoredNo == false)
{
eobj.iNewRank = null;
eobj.iOldRank = Convert.ToInt32(0);
}
else
{
eobj.iNewRank = prop.iNewRank;
eobj.iOldRank = prop.iOldRank;
}
eobj.cStatus = "A";
eobj.dtActionDate = DateTime.Now;
eobj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)(Session["UserDetails"])).iUserId;
val = BL_tblRankManagement.AddRecord(eobj);
if (val == 1)
{
strReturn = "Added successfully.";
return(Json(new { st = 1, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
else if (val == 2)
{
strReturn = "Property within same validity already exists";
return(Json(new { st = 0, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
else
{
strReturn = "Kindly try after some time.";
return(Json(new { st = 0, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
}
#endregion
#region Update Rank
if (prop.Mode == "Update")
{
prop.dtStartdate = clsUtils.ConvertddmmyyyytoDateTime(prop.dtValidFrom);
prop.dtEndDate = clsUtils.ConvertddmmyyyytoDateTime(prop.dtValidTo);
if (prop.IsSponsoredYes == false && prop.IsSponsoredNo == false)
{
prop.IsSponsored = null;
}
else
{
prop.IsSponsored = prop.IsSponsoredYes;
}
if (prop.IsSponsoredNo == false)
{
prop.iNewRank = null;
prop.iOldRank = Convert.ToInt32(0);
}
val = BL_tblRankManagement.UpdateRecord(prop);
if (val == 1)
{
strReturn = "Updated successfully.";
return(Json(new { st = 1, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
else if (val == 2)
{
strReturn = "Property within same validity already exists";
return(Json(new { st = 0, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
else
{
strReturn = "Kindly try after some time.";
return(Json(new { st = 0, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
}
#endregion
}
else
{
strReturn = "Kindly try after some time.";
}
return(Json(new { st = 0, msg = strReturn }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
etblRankManagement obj = new etblRankManagement();
return(View(obj));
}
