public int UpdateMilestoneStatusCheckDuplicate(MilestoneStatu milestoneStatus)
{
try
{
if (milestoneStatus == null)
{ return -2; }
using (var db = new DPRDataMigrationEngineDBEntities())
{
if (db.MilestoneStatus.Any())
{
if (db.MilestoneStatus.Count(m => m.Name.ToLower().Replace(" ", string.Empty) == milestoneStatus.Name.ToLower().Replace(" ", string.Empty) && m.MilestoneStatusId != milestoneStatus.MilestoneStatusId) > 0)
{
return -3;
}
}
db.MilestoneStatus.Attach(milestoneStatus);
db.Entry(milestoneStatus).State = EntityState.Modified;
return db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return 0;
}
}
public int AddMilestoneStatusCheckDuplicate(MilestoneStatu milestoneStatus)
{
try
{
if (milestoneStatus == null)
{ return -2; }
using (var db = new DPRDataMigrationEngineDBEntities())
{
if (db.MilestoneStatus.Any())
{
if (db.MilestoneStatus.Count(m => m.Name.ToLower().Replace(" ", string.Empty) == milestoneStatus.Name.ToLower().Replace(" ", string.Empty)) > 0)
{
return -3;
}
}
var processedItem = db.MilestoneStatus.Add(milestoneStatus);
db.SaveChanges();
return processedItem.MilestoneStatusId;
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return 0;
}
}
public ActionResult EditMilestoneStatu(int id)
{
var milestoneStatus = new MilestoneStatu();
try
{
if (id < 1)
{
milestoneStatus.Error = "Invalid Selection!";
milestoneStatus.ErrorCode = -1;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
var myViewObj = new MilestoneStatusServices().GetMilestoneStatus(id);
if (myViewObj == null || myViewObj.MilestoneStatusId < 1)
{
milestoneStatus.Error = "Milestone Status Information could not be retrieved.";
milestoneStatus.ErrorCode = -1;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
Session["_milestoneStatus"] = myViewObj;
myViewObj.ErrorCode = myViewObj.MilestoneStatusId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
milestoneStatus.Error = "An unknown error was Milestone Status Information could not be retrieved.";
milestoneStatus.ErrorCode = -1;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteMilestoneStatu(int id)
{
var milestoneStatus = new MilestoneStatu();
try
{
if (id < 1)
{
milestoneStatus.Error = "Invalid Selection";
milestoneStatus.ErrorCode = 0;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
if (new MilestoneStatusServices().DeleteMilestoneStatuCheckReferences(id))
{
milestoneStatus.Error = "Milestone Status Information was successfully deleted.";
milestoneStatus.ErrorCode = 1;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
milestoneStatus.Error = "Process Failed! Please try again later";
milestoneStatus.ErrorCode = 0;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
milestoneStatus.Error = "An unknown error was encountered. Please contact the Administrator or try again later.";
milestoneStatus.ErrorCode = 0;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddMilestoneStatu(MilestoneStatu milestoneStatus)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
milestoneStatus.Error = "Please supply all required fields and try again";
milestoneStatus.ErrorCode = -1;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(milestoneStatus);
if (wx.Code < 1)
{
milestoneStatus.Error = wx.Error;
milestoneStatus.ErrorCode = -1;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
milestoneStatus.Name = milestoneStatus.Name;
var k = new MilestoneStatusServices().AddMilestoneStatusCheckDuplicate(milestoneStatus);
if (k < 1)
{
if (k == -3)
{
milestoneStatus.Error = "Milestone Status already exists";
milestoneStatus.ErrorCode = -3;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
milestoneStatus.Error = "Process Failed! Please contact the Admin or try again later";
milestoneStatus.ErrorCode = 0;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
milestoneStatus.Error = "Record was successfully added";
milestoneStatus.ErrorCode = 1;
milestoneStatus.MilestoneStatusId = k;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
milestoneStatus.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
milestoneStatus.ErrorCode = 0;
return(Json(milestoneStatus, JsonRequestBehavior.AllowGet));
}
}
private static GenericValidator ValidateControl(MilestoneStatu model)
{
var gVal = new GenericValidator();
try
{
if (string.IsNullOrEmpty(model.Name.Trim()))
{
gVal.Error = "Please enter Milestone Status Name.";
gVal.Code = 0;
return(gVal);
}
gVal.Code = 1;
return(gVal);
}
catch (Exception ex)
{
gVal.Error = "Process validation failed. Please supply all required fields and try again.";
gVal.Code = 0;
return(gVal);
}
}
