public int GetWellTypeId(string wellTypeName)
{
try
{
using (var db = new DPRDataMigrationEngineDBEntities())
{
var myObj = db.WellTypes.Where(s => s.Title.ToLower().Trim().Replace(" ", string.Empty) == wellTypeName.ToLower().Trim().Replace(" ", string.Empty)).ToList();
if (!myObj.Any())
{
var wellType = new WellType {
Title = wellTypeName.Trim()
};
var processedWellType = db.WellTypes.Add(wellType);
db.SaveChanges();
return(processedWellType.WellTypeId);
}
var ttd = myObj[0];
return(ttd.WellTypeId);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);;
}
}
public int UpdateWellTypeCheckDuplicate(WellType wellType)
{
try
{
if (wellType == null)
{
return(-2);
}
using (var db = new DPRDataMigrationEngineDBEntities())
{
if (db.WellTypes.Any())
{
if (db.WellTypes.Count(m => m.Title.ToLower().Replace(" ", string.Empty) == wellType.Title.ToLower().Replace(" ", string.Empty) && m.WellTypeId != wellType.WellTypeId) > 0)
{
return(-3);
}
}
db.WellTypes.Attach(wellType);
db.Entry(wellType).State = EntityState.Modified;
return(db.SaveChanges());
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult EditWellType(int id)
{
var wellType = new WellType();
try
{
if (id < 1)
{
wellType.Error = "Invalid Selection!";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
var myViewObj = new WellTypeServices().GetWellType(id);
if (myViewObj == null || myViewObj.WellTypeId < 1)
{
wellType.Error = "Well Type Information could not be retrieved.";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
Session["_wellType"] = myViewObj;
myViewObj.ErrorCode = myViewObj.WellTypeId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellType.Error = "An unknown error was Well Type Information could not be retrieved.";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteWellType(int id)
{
var wellType = new WellType();
try
{
if (id < 1)
{
wellType.Error = "Invalid Selection";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
if (new WellTypeServices().DeleteWellTypeCheckReferences(id))
{
wellType.Error = "Well Type Information was successfully deleted.";
wellType.ErrorCode = 1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Error = "Process Failed! Please try again later";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellType.Error = "An unknown error was encountered. Please contact the Administrator or try again later.";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddWellType(WellType wellType)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
wellType.Error = "Please supply all required fields and try again";
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(wellType);
if (wx.Code < 1)
{
wellType.Error = wx.Error;
wellType.ErrorCode = -1;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Title = wellType.Title;
var k = new WellTypeServices().AddWellTypeCheckDuplicate(wellType);
if (k < 1)
{
if (k == -3)
{
wellType.Error = "Well Type already exists";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Error = "Process Failed! Please contact the Admin or try again later";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
wellType.Error = "Record was added successfully";
wellType.ErrorCode = 1;
wellType.WellTypeId = k;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
wellType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
wellType.ErrorCode = 0;
return(Json(wellType, JsonRequestBehavior.AllowGet));
}
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
WellType wt = (WellType)value;
switch (wt)
{
case WellType.W:
return(Colors.Blue.ToString());
case WellType.Y:
return(Colors.Red.ToString());
default:
return(null);
}
}
private static GenericValidator ValidateControl(WellType model)
{
var gVal = new GenericValidator();
try
{
if (string.IsNullOrEmpty(model.Title.Trim()))
{
gVal.Error = "Please enter Well 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);
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.ApplyConfiguration(new CompanyMap());
modelBuilder.ApplyConfiguration(new ShopMap());
modelBuilder.ApplyConfiguration(new FieldMap());
modelBuilder.ApplyConfiguration(new WellMap());
modelBuilder.ApplyConfiguration(new WellTypeMap());
var company1 = new Company {
Id = 1, Name = "ПАО \"Газпром\"", ShortName = "ГПН"
};
var company2 = new Company {
Id = 2, Name = "ПАО \"Лукойл\"", ShortName = "ЛК"
};
var company3 = new Company {
Id = 3, Name = "ПАО \"БашНефть\"", ShortName = "БН"
};
var company4 = new Company {
Id = 4, Name = "ЗАО \"Турсунт\"", ShortName = "ТУР"
};
modelBuilder.Entity <Company>().HasData(company1, company2, company3, company4);
var shop1 = new Shop {
Id = 1, CompanyId = company2.Id, Name = "ЦДНГ-1"
};
var shop2 = new Shop {
Id = 2, CompanyId = company2.Id, Name = "ЦДНГ-2"
};
var shop3 = new Shop {
Id = 3, CompanyId = company1.Id, Name = "ЦДНГ-10"
};
var shop4 = new Shop {
Id = 4, CompanyId = company1.Id, Name = "ЦДНГ-11"
};
var shop5 = new Shop {
Id = 5, CompanyId = company3.Id, Name = "ЦДНГ-1"
};
var shop6 = new Shop {
Id = 6, CompanyId = company4.Id, Name = "ЦДНГ-1"
};
modelBuilder.Entity <Shop>().HasData(shop1, shop2, shop3, shop4, shop5, shop6);
var field1 = new Field {
Id = 1, CompanyId = company1.Id, Name = "Яхлинское м."
};
var field2 = new Field {
Id = 2, CompanyId = company1.Id, Name = "Тальниковое м."
};
var field3 = new Field {
Id = 3, CompanyId = company1.Id, Name = "Шушминское м."
};
var field4 = new Field {
Id = 4, CompanyId = company2.Id, Name = "Тугровское м."
};
var field5 = new Field {
Id = 5, CompanyId = company2.Id, Name = "Шаимское м."
};
var field6 = new Field {
Id = 6, CompanyId = company2.Id, Name = "Сыморьяхское м."
};
var field7 = new Field {
Id = 7, CompanyId = company4.Id, Name = "Толумское м."
};
var field8 = new Field {
Id = 8, CompanyId = company4.Id, Name = "Ловинское м."
};
modelBuilder.Entity <Field>().HasData(field1, field2, field3, field4, field5, field6, field7, field8);
var wellType1 = new WellType {
Id = 1, Name = "Нефтяная"
};
var wellType2 = new WellType {
Id = 2, Name = "Нагнетательная"
};
var wellType3 = new WellType {
Id = 3, Name = "Водозаборная"
};
modelBuilder.Entity <WellType>().HasData(wellType1, wellType2, wellType3);
//var well1 = new Well { Id = 1, FieldId = field1.Id, Name = "10010", ShopId = shop3.Id };
//var well2 = new Well { Id = 2, FieldId = field1.Id, Name = "100Р", ShopId = shop3.Id };
//var well3 = new Well { Id = 3, FieldId = field2.Id, Name = "101Р", ShopId = shop4.Id };
//var well4 = new Well { Id = 4, FieldId = field4.Id, Name = "1В", ShopId = shop1.Id };
//var well5 = new Well { Id = 5, FieldId = field4.Id, Name = "456", ShopId = shop2.Id };
//var well6 = new Well { Id = 6, FieldId = field5.Id, Name = "111", ShopId = shop1.Id };
//var well7 = new Well { Id = 7, FieldId = field5.Id, Name = "20089", ShopId = shop1.Id };
//var well8 = new Well { Id = 8, FieldId = field6.Id, Name = "49", ShopId = shop2.Id };
//var well9 = new Well { Id = 9, FieldId = field7.Id, Name = "1011", ShopId = shop6.Id };
//var well10 = new Well { Id = 10, FieldId = field8.Id, Name = "2345", ShopId = shop6.Id };
//var well11 = new Well { Id = 11, FieldId = field8.Id, Name = "99Н", ShopId = shop6.Id };
var well1 = new Well {
Id = 1, FieldId = field1.Id, Name = "10010", CompanyId = company1.Id, ShopId = shop3.Id, Altitude = 100, ZabI = 1300, ZabF = 1315, WellTypeId = wellType1.Id
};
var well2 = new Well {
Id = 2, FieldId = field1.Id, Name = "100Р", CompanyId = company1.Id, ShopId = shop3.Id, Altitude = 55, ZabI = 1988, ZabF = 2002, WellTypeId = wellType2.Id
};
var well3 = new Well {
Id = 3, FieldId = field2.Id, Name = "101Р", CompanyId = company1.Id, ShopId = shop4.Id, Altitude = 232, ZabI = 1911, ZabF = 2002, WellTypeId = wellType2.Id
};
var well4 = new Well {
Id = 4, FieldId = field4.Id, Name = "1В", CompanyId = company2.Id, ShopId = shop1.Id, Altitude = 1, ZabI = 1911, ZabF = 2002, WellTypeId = wellType2.Id
};
var well5 = new Well {
Id = 5, FieldId = field4.Id, Name = "456", CompanyId = company2.Id, ShopId = shop2.Id, Altitude = 23, ZabI = 1922, ZabF = 2002, WellTypeId = wellType2.Id
};
var well6 = new Well {
Id = 6, FieldId = field5.Id, Name = "111", CompanyId = company2.Id, ShopId = shop1.Id, Altitude = 33, ZabI = 1933, ZabF = 2002, WellTypeId = wellType2.Id
};
var well7 = new Well {
Id = 7, FieldId = field5.Id, Name = "20089", CompanyId = company2.Id, ShopId = shop1.Id, Altitude = 44, ZabI = 1944, ZabF = 2002, WellTypeId = wellType2.Id
};
var well8 = new Well {
Id = 8, FieldId = field6.Id, Name = "49", CompanyId = company2.Id, ShopId = shop2.Id, Altitude = 55, ZabI = 1955, ZabF = 2002, WellTypeId = wellType2.Id
};
var well9 = new Well {
Id = 9, FieldId = field7.Id, Name = "1011", CompanyId = company4.Id, ShopId = shop6.Id, Altitude = 66, ZabI = 1966, ZabF = 2002, WellTypeId = wellType2.Id
};
var well10 = new Well {
Id = 10, FieldId = field8.Id, Name = "2345", CompanyId = company4.Id, ShopId = shop6.Id, Altitude = 77, ZabI = 1966, ZabF = 2002, WellTypeId = wellType2.Id
};
var well11 = new Well {
Id = 11, FieldId = field8.Id, Name = "99Н", CompanyId = company4.Id, ShopId = shop6.Id, Altitude = 88, ZabI = 1977, ZabF = 2002, WellTypeId = wellType2.Id
};
modelBuilder.Entity <Well>().HasData(well1, well2, well3, well4, well5, well6, well7, well8, well9, well10, well11);
}
