public BSEntityFramework_ResultType InsertShopMapDetails(TBL_ShopMapDetails shopsMapDetails)
{
try
{
BSEntityFramework_ResultType result;
using (BSDBEntities EF = new BSDBEntities())
{
using (var transaction = EF.Database.BeginTransaction())
{
try
{
EF.Database.CommandTimeout = 180;
if (shopsMapDetails.CreateDate == DateTime.MinValue)
{
shopsMapDetails.CreateDate = DateTime.Now;
EF.TBL_ShopMapDetails.Add(shopsMapDetails);
}
else
{
EF.TBL_ShopMapDetails.Attach(shopsMapDetails);
EF.Entry(shopsMapDetails).Property(x => x.Latitude).IsModified = true;
EF.Entry(shopsMapDetails).Property(x => x.Longitude).IsModified = true;
EF.Entry(shopsMapDetails).Property(x => x.UpdateDate).IsModified = true;
EF.Entry(shopsMapDetails).Property(x => x.UpdatedBy).IsModified = true;
}
EF.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
var logact = new LoggerActivity();
result = new BSEntityFramework_ResultType(BSResult.Fail, shopsMapDetails, null, "Technical issue");
logact.SaveLog(logact.ErrorSetup("WebApp", "shops Map Details Failed", "", "", "", ex.Message));
return(result);
}
}
}
result = new BSEntityFramework_ResultType(BSResult.Success, shopsMapDetails, null,
"Created Sucessfully");
return(result);
}
catch (DbEntityValidationException dbValidationEx)
{
return(FormatException(dbValidationEx, shopsMapDetails));
}
catch (Exception ex)
{
var logact = new LoggerActivity();
var result = new BSEntityFramework_ResultType(BSResult.Fail, shopsMapDetails, null, "Technical issue");
logact.SaveLog(logact.ErrorSetup("WebApp", "shops Map Details Failed", "", "", "", ex.Message));
return(result);
}
}
public BSEntityFramework_ResultType InsertShopInPostal(TBL_ShopsInPostalCodes shopsInPostal, int shopID)
{
try
{
BSEntityFramework_ResultType result;
using (BSDBEntities EF = new BSDBEntities())
{
using (var transaction = EF.Database.BeginTransaction())
{
try
{
EF.Database.CommandTimeout = 180;
shopsInPostal.ShopID = shopID;
EF.TBL_ShopsInPostalCodes.Add(shopsInPostal);
EF.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
var logact = new LoggerActivity();
result = new BSEntityFramework_ResultType(BSResult.Fail, shopsInPostal, null, "Technical issue");
logact.SaveLog(logact.ErrorSetup("WebApp", "InsertShopPostalDetails Failed", "", "", "", ex.Message));
return(result);
}
}
}
result = new BSEntityFramework_ResultType(BSResult.Success, shopsInPostal, null,
"Created Sucessfully");
return(result);
}
catch (DbEntityValidationException dbValidationEx)
{
return(FormatException(dbValidationEx, shopsInPostal));
}
catch (Exception ex)
{
var logact = new LoggerActivity();
var result = new BSEntityFramework_ResultType(BSResult.Fail, shopsInPostal, null, "Technical issue");
logact.SaveLog(logact.ErrorSetup("WebApp", "InsertShopPostalDetails Failed", "", "", "", ex.Message));
return(result);
}
}
