public ActionResult EditWellCompletionType(int id)
{
var wellCompletionType = new WellCompletionType();
try
{
if (id < 1)
{
wellCompletionType.Error = "Invalid Selection!";
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
var myViewObj = new WellCompletionTypeServices().GetWellCompletionType(id);
if (myViewObj == null || myViewObj.WellCompletionTypeId < 1)
{
wellCompletionType.Error = "Well Completion Type Information could not be retrieved.";
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
Session["_wellCompletionType"] = myViewObj;
myViewObj.ErrorCode = myViewObj.WellCompletionTypeId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellCompletionType.Error = "An unknown error was Well Completion Type Information could not be retrieved.";
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteWellCompletionType(int id)
{
var wellCompletionType = new WellCompletionType();
try
{
if (id < 1)
{
wellCompletionType.Error = "Invalid Selection";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
if (new WellCompletionTypeServices().DeleteWellCompletionTypeCheckReferences(id))
{
wellCompletionType.Error = "Well Completion Type Information was successfully deleted.";
wellCompletionType.ErrorCode = 1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
wellCompletionType.Error = "Process Failed! Please try again later";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellCompletionType.Error = "An unknown error was encountered. Please contact the Administrator or try again later.";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
}
public int UpdateWellCompletionTypeCheckDuplicate(WellCompletionType wellCompletionType)
{
try
{
if (wellCompletionType == null)
{
return(-2);
}
using (var db = new DPRDataMigrationEngineDBEntities())
{
if (db.WellCompletionTypes.Any())
{
if (db.WellCompletionTypes.Count(m => m.Type.ToLower().Replace(" ", string.Empty) == wellCompletionType.Type.ToLower().Replace(" ", string.Empty) && m.WellCompletionTypeId != wellCompletionType.WellCompletionTypeId) > 0)
{
return(-3);
}
}
db.WellCompletionTypes.Attach(wellCompletionType);
db.Entry(wellCompletionType).State = EntityState.Modified;
return(db.SaveChanges());
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult AddWellCompletionType(WellCompletionType wellCompletionType)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
wellCompletionType.Error = "Please supply all required fields and try again";
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellCompletionType);
if (wx.Code < 1)
{
wellCompletionType.Error = wx.Error;
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
var k = new WellCompletionTypeServices().AddWellCompletionTypeCheckDuplicate(wellCompletionType);
if (k < 1)
{
if (k == -3)
{
wellCompletionType.Error = "Well Completion Type already exists";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
wellCompletionType.Error = "Process Failed! Please contact the Admin or try again later";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
wellCompletionType.Error = "Record was added successfully";
wellCompletionType.ErrorCode = 1;
wellCompletionType.WellCompletionTypeId = k;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellCompletionType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
}
private static GenericValidator ValidateControl(WellCompletionType model)
{
var gVal = new GenericValidator();
try
{
if (string.IsNullOrEmpty(model.Type.Trim()))
{
gVal.Error = "Please enter Well Completion Type 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);
}
}
public ActionResult EditWellCompletionType(WellCompletionType wellCompletionType)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (Session["_wellCompletionType"] == null)
{
wellCompletionType.Error = "Session has expired";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
var oldWellCompletionType = Session["_wellCompletionType"] as WellCompletionType;
if (oldWellCompletionType == null || oldWellCompletionType.WellCompletionTypeId < 1)
{
wellCompletionType.Error = "Session has expired";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
if (!ModelState.IsValid)
{
wellCompletionType.Error = "Please supply all required fields and try again";
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellCompletionType);
if (wx.Code < 1)
{
wellCompletionType.Error = wx.Error;
wellCompletionType.ErrorCode = -1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
oldWellCompletionType.Type = wellCompletionType.Type;
var k = new WellCompletionTypeServices().UpdateWellCompletionTypeCheckDuplicate(oldWellCompletionType);
if (k < 1)
{
if (k == -3)
{
wellCompletionType.Error = "Well Completion Type already exists";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
wellCompletionType.Error = "Process Failed! Please contact the Admin or try again later";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
wellCompletionType.Error = "Well Completion Type Information was successfully updated";
wellCompletionType.ErrorCode = 1;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellCompletionType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellCompletionType.ErrorCode = 0;
return(Json(wellCompletionType, JsonRequestBehavior.AllowGet));
}
}
