private static GenericValidator ValidateControl(WellWorkOverReason model)
{
var gVal = new GenericValidator();
try
{
if (string.IsNullOrEmpty(model.Title.Trim()))
{
gVal.Error = "Please provide Well Workover Reason.";
gVal.Code = 0;
return(gVal);
}
//if (string.IsNullOrEmpty(model.Description.Trim()))
//{
// gVal.Error = "Please provide Description.";
// 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);
}
}
public ActionResult EditWellWorkOverReason(int id)
{
var wellWorkOverReason = new WellWorkOverReason();
try
{
if (id < 1)
{
wellWorkOverReason.Error = "Invalid Selection!";
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
var myViewObj = new WellWorkOverReasonServices().GetWellWorkOverReason(id);
if (myViewObj == null || myViewObj.WellWorkOverReasonId < 1)
{
wellWorkOverReason.Error = "Well Workover Reason Information could not be retrieved.";
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
Session["_wellWorkOverReason"] = myViewObj;
myViewObj.ErrorCode = myViewObj.WellWorkOverReasonId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellWorkOverReason.Error = "An unknown error was Well Workover Reason Information could not be retrieved.";
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteWellWorkOverReason(int id)
{
var wellWorkOverReason = new WellWorkOverReason();
try
{
if (id < 1)
{
wellWorkOverReason.Error = "Invalid Selection";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
if (new WellWorkOverReasonServices().DeleteWellWorkOverReasonCheckReferences(id))
{
wellWorkOverReason.Error = "Well Workover Reason Information was successfully deleted.";
wellWorkOverReason.ErrorCode = 1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
wellWorkOverReason.Error = "Process Failed! Please try again later";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellWorkOverReason.Error = "An unknown error was encountered. Please contact the Administrator or try again later.";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
}
public int AddWellWorkOverReason(WellWorkOverReason wellWorkOverReason)
{
try
{
if (wellWorkOverReason == null)
{
return(-2);
}
using (var db = new DPRDataMigrationEngineDBEntities())
{
var myObj = db.WellWorkOverReasons.Where(s => s.Title.Trim().ToLower().Replace(" ", "") == wellWorkOverReason.Title.Trim().ToLower().Replace(" ", "")).ToList();
if (!myObj.Any())
{
return(-3);
}
var processedItem = db.WellWorkOverReasons.Add(wellWorkOverReason);
db.SaveChanges();
return(processedItem.WellWorkOverReasonId);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public int GetWellWorkOverReasonIdByName(string wellWorkOverReason)
{
try
{
using (var db = new DPRDataMigrationEngineDBEntities())
{
var myObj = db.WellWorkOverReasons.Where(s => s.Title.Trim().ToLower().Replace(" ", "") == wellWorkOverReason.Trim().ToLower().Replace(" ", "")).ToList();
if (!myObj.Any())
{
var reason = new WellWorkOverReason
{
Title = wellWorkOverReason.Trim()
};
var processedItem = db.WellWorkOverReasons.Add(reason);
db.SaveChanges();
return(processedItem.WellWorkOverReasonId);
}
return(myObj[0].WellWorkOverReasonId);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult AddWellWorkOverReason(WellWorkOverReason wellWorkOverReason)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
wellWorkOverReason.Error = "Please supply all required fields and try again";
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellWorkOverReason);
if (wx.Code < 1)
{
wellWorkOverReason.Error = wx.Error;
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
var k = new WellWorkOverReasonServices().AddWellWorkOverReason(wellWorkOverReason);
if (k < 1)
{
if (k == -3)
{
wellWorkOverReason.Error = "Well Workover Reason already exists";
wellWorkOverReason.ErrorCode = -3;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
wellWorkOverReason.Error = "Process Failed! Please contact the Admin or try again later";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
wellWorkOverReason.Error = "Record was added successfully";
wellWorkOverReason.ErrorCode = 1;
wellWorkOverReason.WellWorkOverReasonId = k;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellWorkOverReason.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
}
public int UpdateWellWorkOverReason(WellWorkOverReason wellWorkOverReason)
{
try
{
if (wellWorkOverReason == null)
{
return(-2);
}
using (var db = new DPRDataMigrationEngineDBEntities())
{
db.WellWorkOverReasons.Attach(wellWorkOverReason);
db.Entry(wellWorkOverReason).State = EntityState.Modified;
return(db.SaveChanges());
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult EditWellWorkOverReason(WellWorkOverReason wellWorkOverReason)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (Session["_wellWorkOverReason"] == null)
{
wellWorkOverReason.Error = "Session has expired";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
var oldWellWorkOverReason = Session["_wellWorkOverReason"] as WellWorkOverReason;
if (oldWellWorkOverReason == null || oldWellWorkOverReason.WellWorkOverReasonId < 1)
{
wellWorkOverReason.Error = "Session has expired";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
if (!ModelState.IsValid)
{
wellWorkOverReason.Error = "Please supply all required fields and try again";
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellWorkOverReason);
if (wx.Code < 1)
{
wellWorkOverReason.Error = wx.Error;
wellWorkOverReason.ErrorCode = -1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
oldWellWorkOverReason.Title = wellWorkOverReason.Title;
oldWellWorkOverReason.Description = wellWorkOverReason.Description;
var k = new WellWorkOverReasonServices().UpdateWellWorkOverReason(oldWellWorkOverReason);
if (k < 1)
{
if (k == -3)
{
wellWorkOverReason.Error = "Well Workover Reason already exists";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
wellWorkOverReason.Error = "Process Failed! Please contact the Admin or try again later";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
wellWorkOverReason.Error = "Well Workover Reason Information was successfully updated";
wellWorkOverReason.ErrorCode = 1;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellWorkOverReason.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellWorkOverReason.ErrorCode = 0;
return(Json(wellWorkOverReason, JsonRequestBehavior.AllowGet));
}
}
