//Update a record
public static int UpdateRecord(int PropId, int Channelmgr, int user)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblPropertyChannelMgrMaps.SingleOrDefault(u => u.iPropId == PropId);
if (obj != null)
{
db.tblPropertyChannelMgrMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
tblPropertyChannelMgrMap CM = new tblPropertyChannelMgrMap();
CM.dtActionDate = DateTime.Now;
CM.iActionBy = user;
CM.iChannelMgr = Channelmgr;
CM.iPropId = PropId;
db.tblPropertyChannelMgrMaps.Attach(CM);
db.Entry(CM).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update Rank
public static int UpdateRecord(etblRankManagement eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
bool checkExists = false;
checkExists = db.tblRankManagements.Any(
p => p.iPropId == eobj.iPropId &&
p.iID != eobj.iID &&
(((p.dtStartdate <= eobj.dtStartdate && p.dtEndDate >= eobj.dtStartdate) || (p.dtStartdate <= eobj.dtEndDate && p.dtEndDate >= eobj.dtEndDate)) ||
((eobj.dtStartdate <= p.dtStartdate && eobj.dtEndDate >= p.dtStartdate) || (eobj.dtStartdate <= p.dtEndDate && eobj.dtEndDate >= p.dtEndDate)))
);
if (checkExists != true)
{
OneFineRate.tblRankManagement obj = (OneFineRate.tblRankManagement)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRankManagement());
db.tblRankManagements.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static KeyValuePair <int, string> ToggleStatus(int companyId, bool enable)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
var comp = db.tblCorporateCompanyMs.Where(x => x.iCompanyId == companyId).FirstOrDefault();
if (comp != null)
{
if (enable)
{
comp.cStatus = "A";
}
else
{
comp.cStatus = "I";
}
db.tblCorporateCompanyMs.Attach(comp);
db.Entry(comp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new KeyValuePair <int, string>(1, "Record has been updated successfully!"));
}
return(new KeyValuePair <int, string>(-1, "An error occured while updating the record."));
}
}
//Update a record
public static int UpdateRecord(eCustomerPointsMap eobj)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblCustomerPointsMap obj = (OneFineRate.tblCustomerPointsMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblCustomerPointsMap());
db.tblCustomerPointsMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw e;
}
catch (Exception ex)
{
throw ex;
}
}
}
//Delete a record
public static int DeleteRecord(etblPropertyPromotionMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
using (OneFineRateEntities db1 = new OneFineRateEntities())
{
var PP = db1.tblPropertyPromotionMaps.Where(a => a.iID == eobj.iID).ToList();
if (eobj.iPromoId != Convert.ToInt32(Promotions.OFRFreebies))
{
eobj.bParentActive = (bool)PP[0].bParentActive;
}
eobj.iPromoId = PP[0].iPromoId;
}
OneFineRate.tblPropertyPromotionMap obj = (OneFineRate.tblPropertyPromotionMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyPromotionMap());
db.tblPropertyPromotionMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Delete a record
public static int DeleteRecord(int id)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
try
{
var obj1 = db.tblGroupMenuMs.Where(u => u.iGroupId == id);
db.tblGroupMenuMs.RemoveRange(obj1);
}
catch (Exception) { }
try
{
var obj1 = db.tblUserGroupMs.Where(u => u.iUserId == id);
db.tblUserGroupMs.RemoveRange(obj1);
}
catch (Exception) { }
var obj = db.tblGroupMs.SingleOrDefault(u => u.iGroupId == id);
db.tblGroupMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(eRatePlan eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
int dbobj = (from s in db.tblRatePlanMs.Where(u => u.sRatePlan == eobj.sRatePlan.Trim() && u.iRatePlanId != eobj.iRatePlanId)
select new
{
s.iRatePlanId,
}).Count();
if (dbobj > 0)
{
return(retval = 2);
}
OneFineRate.tblRatePlanM obj = (OneFineRate.tblRatePlanM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRatePlanM());
db.tblRatePlanMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static int UpdateRecord(eTblPurchaseHistory eobj)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblPurchaseHistory obj = (OneFineRate.tblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPurchaseHistory());
db.tblPurchaseHistories.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
throw;
}
catch (Exception)
{
throw;
}
}
}
//Update a record
public static int UpdateRecord(etblPropertyRoomMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var CheckRoomCodeExists = db.tblPropertyRoomMaps.Any(
p => p.iPropId == eobj.iPropId &&
p.iRoomId != eobj.iRoomId &&
p.sRoomCode == eobj.sRoomCode);
if (CheckRoomCodeExists == false)
{
OneFineRate.tblPropertyRoomMap obj = (OneFineRate.tblPropertyRoomMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomMap());
db.tblPropertyRoomMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static KeyValuePair <int, string> ToggleStatus(int RateRangeId, bool enable)
{
try
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
var comp = db.tblRoomRateRangeMs.Where(x => x.iRangeId == RateRangeId).FirstOrDefault();
if (comp != null)
{
if (enable)
{
comp.cStatus = "A";
}
else
{
comp.cStatus = "I";
}
db.Entry(comp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new KeyValuePair <int, string>(1, "Status updated successfully!"));
}
return(new KeyValuePair <int, string>(-1, "An error occured while updating the record."));
}
}
catch (Exception)
{
return(new KeyValuePair <int, string>(-1, "An error occured while updating the record."));
}
}
//Update a record
public static int UpdateRecord(etblPropertySpaMap eobj, bool Type)
{
int retval = 0;
using (OneFineRateEntities dbnew = new OneFineRateEntities())
{
try
{
OneFineRate.tblPropertySpaMap obj = (OneFineRate.tblPropertySpaMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertySpaMap());
if (Type)
{
dbnew.tblPropertySpaMaps.Attach(obj);
dbnew.Entry(obj).State = System.Data.Entity.EntityState.Modified;
dbnew.SaveChanges();
retval = 1;
}
else
{
dbnew.tblPropertySpaMaps.Add(obj);
dbnew.SaveChanges();
retval = 1;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(etblPropertyDiningMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblPropertyDiningMap obj = (OneFineRate.tblPropertyDiningMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyDiningMap());
db.tblPropertyDiningMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
//var checkExistsRestaurantName = db.tblPropertyDiningMaps.Any(
// p => p.iPropId == eobj.iPropId
// && p.iRestaurantID != eobj.iRestaurantID
// && p.sRestaurantName == eobj.sRestaurantName);
//if (checkExistsRestaurantName == false)
//{
//}
//else
//{
// retval = 2;
//}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public void Update(TUser user)
{
using (var db = new OneFineRateEntities())
{
var tblUser = (tblWebsiteUserMater)OneFineRateAppUtil.clsUtils.ConvertToObject(user, new tblWebsiteUserMater());
db.tblWebsiteUserMaters.Attach(tblUser);
db.Entry(tblUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//Update a record
public static int UpdateRecord(etblPropertyRoomTypeRoomAmentiesMap eobj)
{
bool Type = false;
int retval = 0;
using (OneFineRateEntities dbnew = new OneFineRateEntities())
{
try
{
var dbobj = dbnew.tblPropertyRoomTypeRoomAmentiesMaps.SingleOrDefault(u => u.iPropId == eobj.iPropId && u.iRoomId == eobj.iRoomId);
if (dbobj != null)
{
Type = true;
}
}
catch (Exception)
{
throw;
}
}
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
if (Type)
{
OneFineRate.tblPropertyRoomTypeRoomAmentiesMap obj = (OneFineRate.tblPropertyRoomTypeRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomTypeRoomAmentiesMap());
db.tblPropertyRoomTypeRoomAmentiesMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.uspUpdateAmenitiesInLookup(eobj.iPropId, eobj.iRoomId);
retval = 1;
}
else
{
OneFineRate.tblPropertyRoomTypeRoomAmentiesMap dbuser = (OneFineRate.tblPropertyRoomTypeRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomTypeRoomAmentiesMap());
db.tblPropertyRoomTypeRoomAmentiesMaps.Add(dbuser);
db.SaveChanges();
db.uspUpdateAmenitiesInLookup(eobj.iPropId, eobj.iRoomId);
retval = 1;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(eUsers eobj, string Groups)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblUserM dbuser = (OneFineRate.tblUserM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserM());
var dbobj = db.tblUserMs.SingleOrDefault(u => u.sUserName != dbuser.sUserName && u.sEmail == dbuser.sEmail);
if (dbobj != null)
{
return(3);
}
OneFineRate.tblUserM obj = (OneFineRate.tblUserM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserM());
db.tblUserMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
try
{
var obj1 = db.tblUserGroupMs.Where(u => u.iUserId == dbuser.iUserId);
db.tblUserGroupMs.RemoveRange(obj1);
}
catch (Exception) { }
var grps = Groups.Split(',').ToList();
db.tblUserGroupMs.AddRange(grps.Select(x => new tblUserGroupM()
{
cStatus = "A",
dtActionDate = DateTime.Now,
dtCreationDate = DateTime.Now,
iActionBy = dbuser.iActionBy,
iCreatedBy = dbuser.iActionBy,
iGroupId = Convert.ToInt32(x),
iUserId = dbuser.iUserId
}));
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(eGroups eobj, string Menus)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var mns = Menus.Split(',').ToList();
if (mns.Count > 1)
{
OneFineRate.tblGroupM obj = (OneFineRate.tblGroupM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblGroupM());
db.tblGroupMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
try
{
var obj1 = db.tblGroupMenuMs.Where(u => u.iGroupId == obj.iGroupId);
db.tblGroupMenuMs.RemoveRange(obj1);
}
catch (Exception) { }
db.tblGroupMenuMs.AddRange(mns.Select(menu => new tblGroupMenuM
{
cStatus = "A",
dtActionDate = DateTime.Now,
dtCreationDate = DateTime.Now,
iActionBy = obj.iActionBy,
iCreatedBy = obj.iActionBy,
iMenuId = Convert.ToInt32(menu),
iGroupId = obj.iGroupId
}));
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static int DeleteRecord(string sModule)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblEmailSettingsMs.SingleOrDefault(u => u.sModule == sModule);
db.tblEmailSettingsMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
return(db.SaveChanges());
}
catch (Exception)
{
throw;
}
}
}
public static int UpdateRecord(etblEmailSettingsM eobj)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblEmailSettingsM obj = (OneFineRate.tblEmailSettingsM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblEmailSettingsM());
db.tblEmailSettingsMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
catch (Exception)
{
throw;
}
}
}
public static int DeleteRecord(int purchaseId)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblPurchaseHistories.Find(purchaseId);
db.tblPurchaseHistories.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
return(db.SaveChanges());
}
catch (Exception)
{
throw;
}
}
}
public static int UpdatePassword(int iUserId, string OldPassword, string NewPassword)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
byte[] b = new byte[1];
string pass = SimpleHash.ComputeHash(OldPassword, "SHA1", b);
var dbobj = (from s in db.tblUserMs
select new
{
s.iUserId,
s.sFirstName,
s.sLastName,
s.sUserName,
s.sPassword,
s.cStatus,
s.dtActionDate,
s.dtCreatedOn,
s.iActionBy,
s.sContact,
s.sEmail
}).Where(u => u.iUserId == iUserId && u.sPassword == pass).AsQueryable();
var list = dbobj.ToList();
if (list.Count == 0)
{
return(0);
}
else
{
OneFineRate.tblUserM obj = (OneFineRate.tblUserM)OneFineRateAppUtil.clsUtils.ConvertToObject(list[0], new OneFineRate.tblUserM());
obj.sPassword = SimpleHash.ComputeHash(NewPassword, "SHA1", b);
obj.dtActionDate = DateTime.Now;
obj.iActionBy = iUserId;
db.tblUserMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(1);
}
}
public static KeyValuePair <int, string> ToggleStatus(int serviceChargeId, bool enable)
{
try
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
var model = db.tblServiceChargeMs.Where(x => x.iServiceChargeId == serviceChargeId).FirstOrDefault();
var duplicateCount = db.tblServiceChargeMs.Any(x => x.iServiceChargeId != serviceChargeId &&
((model.dtFrom >= x.dtFrom && model.dtFrom <= x.dtTo) ||
(model.dtTo >= x.dtFrom && model.dtTo <= x.dtTo) ||
(model.dtFrom <= x.dtFrom && model.dtTo >= x.dtTo)) && x.cStatus == "A");
if (duplicateCount)
{
return(new KeyValuePair <int, string>(-1, "Overlapping date range can not be assigned!"));
}
if (model != null)
{
if (enable)
{
model.cStatus = "A";
}
else
{
model.cStatus = "I";
}
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new KeyValuePair <int, string>(1, "Status updated successfully!"));
}
return(new KeyValuePair <int, string>(-1, "An error occured while updating the record."));
}
}
catch (Exception)
{
return(new KeyValuePair <int, string>(-1, "An error occured while updating the record."));
}
}
//Update a record
public static int UpdateRecord(etblUserFeedbackTripAdvisor eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblUserFeedbackTripAdvisor obj = (OneFineRate.tblUserFeedbackTripAdvisor)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserFeedbackTripAdvisor());
db.tblUserFeedbackTripAdvisors.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(etblPropertyM eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblBankDetailM obj = (OneFineRate.tblBankDetailM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblBankDetailM());
db.tblBankDetailMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Delete a record
public static int DeleteRecord(string sPosition)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblPromotionalHotelsMs.SingleOrDefault(u => u.sPosition == sPosition);
db.tblPromotionalHotelsMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Delete a record
public static int DeleteRecord(int id)
{
int operationStatus = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblWebsiteUserMaters.SingleOrDefault(u => u.Id == id);
db.tblWebsiteUserMaters.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
operationStatus = 1;
}
catch (Exception)
{
throw;
}
}
return(operationStatus);
}
//Delete a record
public static int DeleteRecord(int id)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblStateMs.SingleOrDefault(u => u.iStateId == id);
db.tblStateMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(WebsiteUserMaster eobj)
{
int operationStatus = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblWebsiteUserMater obj = (OneFineRate.tblWebsiteUserMater)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblWebsiteUserMater());
db.tblWebsiteUserMaters.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
operationStatus = 1;
}
catch (Exception)
{
throw;
}
}
return(operationStatus);
}
//Update a record
public static int UpdateLoyalityPoints(eLoyalityPoints eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblLoyalityPointsM obj = (OneFineRate.tblLoyalityPointsM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblLoyalityPointsM());
db.tblLoyalityPointsMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Delete Rank
public static int DeleteRecord(etblRankManagement eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblRankManagement obj = (OneFineRate.tblRankManagement)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRankManagement());
db.tblRankManagements.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Delete a record
public static int DeleteRecord(string from, string to)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var obj = db.tblExchangeRatesMs.SingleOrDefault(u => u.sCurrencyCodeFrom == from && u.sCurrencyCodeTo == to);
db.tblExchangeRatesMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}