public ActionResult EditWellClass(int id)
{
var wellClass = new WellClass();
try
{
if (id < 1)
{
wellClass.Error = "Invalid Selection!";
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
var myViewObj = new WellClasServices().GetWellClass(id);
if (myViewObj == null || myViewObj.WellClassId < 1)
{
wellClass.Error = "Well Class Information could not be retrieved.";
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
Session["_wellClass"] = myViewObj;
myViewObj.ErrorCode = myViewObj.WellClassId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellClass.Error = "An unknown error was Well Class Information could not be retrieved.";
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
}
public int UpdateWellClassCheckDuplicate(WellClass wellClass)
{
try
{
if (wellClass == null)
{
return(-2);
}
using (var db = new DPRDataMigrationEngineDBEntities())
{
if (db.WellClasses.Any())
{
if (db.WellClasses.Count(m => m.Name.ToLower().Replace(" ", string.Empty) == wellClass.Name.ToLower().Replace(" ", string.Empty) && m.WellClassId != wellClass.WellClassId) > 0)
{
return(-3);
}
}
db.WellClasses.Attach(wellClass);
db.Entry(wellClass).State = EntityState.Modified;
return(db.SaveChanges());
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult DeleteWellClass(int id)
{
var wellClass = new WellClass();
try
{
if (id < 1)
{
wellClass.Error = "Invalid Selection";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
if (new WellClasServices().DeleteWellClassCheckReferences(id))
{
wellClass.Error = "Well Class Information was successfully deleted.";
wellClass.ErrorCode = 1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
wellClass.Error = "Process Failed! Please try again later";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellClass.Error = "An unknown error was encountered. Please contact the Administrator or try again later.";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddWellClass(WellClass wellClass)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
wellClass.Error = "Please supply all required fields and try again";
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellClass);
if (wx.Code < 1)
{
wellClass.Error = wx.Error;
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
var k = new WellClasServices().AddWellClassCheckDuplicate(wellClass);
if (k < 1)
{
if (k == -3)
{
wellClass.Error = "Well Class already exists";
wellClass.ErrorCode = -3;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
wellClass.Error = "Process Failed! Please contact the Admin or try again later";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
wellClass.Error = "Record was added successfully";
wellClass.ErrorCode = 1;
wellClass.WellClassId = k;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellClass.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
}
public int CreateWellClassAddClassification(string wellClassName, int wellId)
{
try
{
using (var db = new DPRDataMigrationEngineDBEntities())
{
var myObj = db.WellClasses.Where(s => s.Name.ToLower().Replace(" ", string.Empty).Trim() == wellClassName.ToLower().Replace(" ", string.Empty).Trim()).ToList();
if (!myObj.Any())
{
var wellClass = new WellClass {
Name = wellClassName.Trim()
};
var processedWellClass = db.WellClasses.Add(wellClass);
db.SaveChanges();
if (processedWellClass.WellClassId > 0)
{
var newWellClassification = new WellClassification
{
WellClassId = processedWellClass.WellClassId,
WellId = wellId
};
var processedWellClassification = new WellClassificationServices().AddWellClassificationCheckDuplicate(newWellClassification);
return(processedWellClassification);
}
}
var edt = new WellClassification
{
WellClassId = myObj[0].WellClassId,
WellId = wellId
};
var dsx = new WellClassificationServices().AddWellClassificationCheckDuplicate(edt);
return(dsx);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
private static GenericValidator ValidateControl(WellClass model)
{
var gVal = new GenericValidator();
try
{
if (string.IsNullOrEmpty(model.Name.Trim()))
{
gVal.Error = "Please enter WellClass 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 EditWellClass(WellClass wellClass)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (Session["_wellClass"] == null)
{
wellClass.Error = "Session has expired";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
var oldWellClass = Session["_wellClass"] as WellClass;
if (oldWellClass == null || oldWellClass.WellClassId < 1)
{
wellClass.Error = "Session has expired";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
if (!ModelState.IsValid)
{
wellClass.Error = "Please supply all required fields and try again";
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellClass);
if (wx.Code < 1)
{
wellClass.Error = wx.Error;
wellClass.ErrorCode = -1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
oldWellClass.Name = wellClass.Name;
oldWellClass.Description = wellClass.Description;
var k = new WellClasServices().UpdateWellClassCheckDuplicate(oldWellClass);
if (k < 1)
{
if (k == -3)
{
wellClass.Error = "Well Class already exists";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
wellClass.Error = "Process Failed! Please contact the Admin or try again later";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
wellClass.Error = "Well Class Information was successfully updated";
wellClass.ErrorCode = 1;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellClass.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellClass.ErrorCode = 0;
return(Json(wellClass, JsonRequestBehavior.AllowGet));
}
}
