/// <summary>
/// Initializes a new instance of the <see cref="FieldChange"/> class.
/// </summary>
/// <param name="a">A.</param>
/// <param name="property">The property.</param>
/// <param name="foreignTable">The foreign table.</param>
/// <param name="foreignFeildName">Name of the foreign feild.</param>
/// <param name="foreignFeildKey">The foreign feild key.</param>
public FieldChange(Audit a, string property, string foreignTable, string foreignFeildName, string foreignFeildKey)
{
//FieldChange x = new FieldChange(a, property);
CTSContext db = new CTSContext();
// this.ChangeDate = a.DateTime;
BLL.UserProfile user = BLL.UserProfile.GetUserById(a.LoginID);
this.ChangedBy = (user != null) ? user.UserName : "******";
this.FieldName = property;
this.PreviousValue = a.OldValue;
this.ChangedValue = a.NewValue;
this.FieldName = property;
var prevKey = Convert.ToInt32(this.PreviousValue);
var CurrentKey = Convert.ToInt32(this.ChangedValue);
//modified Banty:24/5/2013 from db.ExecuteStoreQuery to (db as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery
var Prev = (db as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery <string>(" SELECT " + foreignFeildName + " as field FROM " + foreignTable + " WHERE " + foreignFeildKey + " = " + prevKey).FirstOrDefault();
var now = (db as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery <string>(" SELECT " + foreignFeildName + " as field FROM " + foreignTable + " WHERE " + foreignFeildKey + " = " + CurrentKey).FirstOrDefault();;
// var Prev = db.AuditForeignFeild(foreignTable,foreignFeildName,prevKey,foreignFeildKey).SingleOrDefault();
// var now = db.AuditForeignFeild(foreignTable, foreignFeildName, CurrentKey, foreignFeildKey).SingleOrDefault();
if (Prev != null)
{
this.PreviousValue = Prev.ToString();
//this.PreviousValue = Prev.field;
}
if (now != null)
{
this.ChangedValue = now.ToString();
}
}
public static bool RoleExists(string name)
{
CTSContext entities = new CTSContext();
var count = entities.Roles.Where(p => p.Name == name).Count();
return(count > 0);
}
/// <summary>
/// Initializes a new instance of the <see cref="FieldChange"/> class.
/// </summary>
/// <param name="a">A.</param>
/// <param name="property">The property.</param>
/// <param name="foreignTable">The foreign table.</param>
/// <param name="foreignFeildName">Name of the foreign feild.</param>
/// <param name="foreignFeildKey">The foreign feild key.</param>
public FieldChange(Audit a, string property, string foreignTable, string foreignFeildName, string foreignFeildKey)
{
//FieldChange x = new FieldChange(a, property);
CTSContext db = new CTSContext();
// this.ChangeDate = a.DateTime;
BLL.UserProfile user = BLL.UserProfile.GetUserById(a.LoginID);
this.ChangedBy = (user != null) ? user.UserName : "******";
this.FieldName = property;
this.PreviousValue = a.OldValue;
this.ChangedValue = a.NewValue;
this.FieldName = property;
var prevKey = Convert.ToInt32(this.PreviousValue);
var CurrentKey = Convert.ToInt32(this.ChangedValue);
//modified Banty:24/5/2013 from db.ExecuteStoreQuery to (db as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery
var Prev = (db as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery<string>(" SELECT " + foreignFeildName + " as field FROM " + foreignTable + " WHERE " + foreignFeildKey + " = " + prevKey).FirstOrDefault();
var now = (db as IObjectContextAdapter).ObjectContext.ExecuteStoreQuery<string>(" SELECT " + foreignFeildName + " as field FROM " + foreignTable + " WHERE " + foreignFeildKey + " = " + CurrentKey).FirstOrDefault(); ;
// var Prev = db.AuditForeignFeild(foreignTable,foreignFeildName,prevKey,foreignFeildKey).SingleOrDefault();
// var now = db.AuditForeignFeild(foreignTable, foreignFeildName, CurrentKey, foreignFeildKey).SingleOrDefault();
if(Prev != null)
{
this.PreviousValue = Prev.ToString();
//this.PreviousValue = Prev.field;
}
if(now != null)
{
this.ChangedValue = now.ToString();
}
}
public static void AddRole(Role role)
{
CTSContext entities = new CTSContext();
entities.Roles.Add(role);
entities.SaveChanges();
}
public static Role GetRole(string name)
{
CTSContext entities = new CTSContext();
return(entities.Roles.Where(p => p.Name == name).SingleOrDefault());
;
}
/// <summary>
/// Determines whether the specified id has updated.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="table">The table.</param>
/// <returns>
/// <c>true</c> if the specified id has updated; otherwise, <c>false</c>.
/// </returns>
public static bool HasUpdated(int id, string table)
{
CTSContext db = new CTSContext();
var count = (from audit in db.Audits
where audit.TableName == table && audit.PrimaryKey == id.ToString()
select audit).Count();
return(count > 0);
}
public void RemoveRole(string roleName, string userName)
{
BLL.CTSContext entities = new CTSContext();
UserRole role = entities.UserRoles.Where(r => r.Role.Name == roleName && r.UserProfile.UserName == userName).SingleOrDefault();
if (role != null)
{
entities.UserRoles.Remove(role);
entities.SaveChanges();
}
}
public void RemoveRole(string roleName, string userName)
{
BLL.CTSContext entities = new CTSContext();
UserRole role = entities.UserRoles.Where(r => r.Role.Name == roleName && r.UserProfile.UserName == userName).SingleOrDefault();
if (role != null)
{
entities.UserRoles.Remove(role);
entities.SaveChanges();
}
}
/// <summary>
/// Determines whether the specified id has updated.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="table">The table.</param>
/// <param name="property">The property.</param>
/// <returns>
/// <c>true</c> if the specified id has updated; otherwise, <c>false</c>.
/// </returns>
public static bool HasUpdated(object id, string table, string property)
{
if (id != null)
{
string stringId = id.ToString();
CTSContext db = new CTSContext();
var count = (from audit in db.Audits
where audit.TableName == table && audit.PrimaryKey.Equals(stringId) && audit.NewValue.Contains(property)
select audit).Count();
return(count > 0);
}
return(false);
}
public void AddUserToRole(int roleId, string userName)
{
BLL.CTSContext entities = new CTSContext();
UserProfile user = entities.UserProfiles.Where(p => p.UserName == userName).FirstOrDefault();
if (user != null)
{
UserRole role = new UserRole();
role.RoleID = roleId;
role.UserProfileID = user.UserProfileID;
entities.UserRoles.Add(role);
entities.SaveChanges();
}
}
public void AddUserToRole(int roleId, string userName)
{
BLL.CTSContext entities = new CTSContext();
UserProfile user = entities.UserProfiles.Where(p => p.UserName == userName).FirstOrDefault();
if (user != null)
{
UserRole role = new UserRole();
role.RoleID = roleId;
role.UserProfileID = user.UserProfileID;
entities.UserRoles.Add(role);
entities.SaveChanges();
}
}
/// <summary>
/// Updates the specified inserted.
/// </summary>
/// <param name="inserted">The inserted.</param>
/// <param name="updated">The updated.</param>
/// <param name="deleted">The deleted.</param>
public void Update(List <BLL.DispatchDetail> inserted, List <BLL.DispatchDetail> updated,
List <BLL.DispatchDetail> deleted)
{
CTSContext db = new CTSContext();
BLL.Dispatch orginal = db.Dispatches.Where(p => p.DispatchID == this.DispatchID).SingleOrDefault();
if (orginal != null)
{
orginal.BidNumber = this.BidNumber;
orginal.DispatchDate = this.DispatchDate;
orginal.DriverName = this.DriverName;
orginal.FDPID = this.FDPID;
orginal.GIN = this.GIN;
orginal.PeriodYear = this.PeriodYear;
orginal.PeriodMonth = this.PeriodMonth;
orginal.PlateNo_Prime = this.PlateNo_Prime;
orginal.PlateNo_Trailer = this.PlateNo_Trailer;
//orginal.ProgramID = this.ProgramID;
orginal.RequisitionNo = this.RequisitionNo;
orginal.Round = this.Round;
//orginal.StackNumber = this.StackNumber;
//orginal.StoreID = this.StoreID;
orginal.TransporterID = this.TransporterID;
orginal.UserProfileID = this.UserProfileID;
//orginal.WarehouseID = this.WarehouseID;
orginal.WeighBridgeTicketNumber = this.WeighBridgeTicketNumber;
orginal.Remark = this.Remark;
orginal.DispatchedByStoreMan = this.DispatchedByStoreMan;
//orginal.ProjectNumber = this.ProjectNumber;
//orginal.SINumber = this.SINumber;
foreach (BLL.DispatchDetail update in updated)
{
BLL.DispatchDetail updatedCommodity = db.DispatchDetails.Where(p => p.DispatchDetailID == update.DispatchDetailID).SingleOrDefault();
if (updatedCommodity != null)
{
updatedCommodity.CommodityID = update.CommodityID;
updatedCommodity.Description = update.Description;
//updatedCommodity.DispatchedQuantityInUnit = update.DispatchedQuantityInUnit;
//updatedCommodity.DispatchedQuantityInMT = update.DispatchedQuantityInMT;
updatedCommodity.RequestedQunatityInUnit = update.RequestedQunatityInUnit;
updatedCommodity.RequestedQuantityInMT = update.RequestedQuantityInMT;
updatedCommodity.UnitID = update.UnitID;
}
}
db.SaveChanges();
}
}
/// <summary>
/// Updates the specified inserted.
/// </summary>
/// <param name="inserted">The inserted.</param>
/// <param name="updated">The updated.</param>
/// <param name="deleted">The deleted.</param>
public void Update(List<BLL.DispatchDetail> inserted, List<BLL.DispatchDetail> updated,
List<BLL.DispatchDetail> deleted)
{
CTSContext db = new CTSContext();
BLL.Dispatch orginal = db.Dispatches.Where(p => p.DispatchID == this.DispatchID).SingleOrDefault();
if (orginal != null)
{
orginal.BidNumber = this.BidNumber;
orginal.DispatchDate = this.DispatchDate;
orginal.DriverName = this.DriverName;
orginal.FDPID = this.FDPID;
orginal.GIN = this.GIN;
orginal.PeriodYear = this.PeriodYear;
orginal.PeriodMonth = this.PeriodMonth;
orginal.PlateNo_Prime = this.PlateNo_Prime;
orginal.PlateNo_Trailer = this.PlateNo_Trailer;
//orginal.ProgramID = this.ProgramID;
orginal.RequisitionNo = this.RequisitionNo;
orginal.Round = this.Round;
//orginal.StackNumber = this.StackNumber;
//orginal.StoreID = this.StoreID;
orginal.TransporterID = this.TransporterID;
orginal.UserProfileID = this.UserProfileID;
//orginal.WarehouseID = this.WarehouseID;
orginal.WeighBridgeTicketNumber = this.WeighBridgeTicketNumber;
orginal.Remark = this.Remark;
orginal.DispatchedByStoreMan = this.DispatchedByStoreMan;
//orginal.ProjectNumber = this.ProjectNumber;
//orginal.SINumber = this.SINumber;
foreach (BLL.DispatchDetail update in updated)
{
BLL.DispatchDetail updatedCommodity = db.DispatchDetails.Where(p => p.DispatchDetailID == update.DispatchDetailID).SingleOrDefault();
if (updatedCommodity != null)
{
updatedCommodity.CommodityID = update.CommodityID;
updatedCommodity.Description = update.Description;
//updatedCommodity.DispatchedQuantityInUnit = update.DispatchedQuantityInUnit;
//updatedCommodity.DispatchedQuantityInMT = update.DispatchedQuantityInMT;
updatedCommodity.RequestedQunatityInUnit = update.RequestedQunatityInUnit;
updatedCommodity.RequestedQuantityInMT = update.RequestedQuantityInMT;
updatedCommodity.UnitID = update.UnitID;
}
}
db.SaveChanges();
}
}
/// <summary>
/// Gets the changes.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="table">The table.</param>
/// <param name="property">The property.</param>
/// <returns></returns>
public static List <FieldChange> GetChanges(int id, string table, string property)
{
string key = id.ToString();
CTSContext db = new CTSContext();
var changes = (from audit in db.Audits
where audit.TableName == table && audit.PrimaryKey == key && audit.NewValue.Contains(property)
orderby audit.DateTime descending
select audit);
List <FieldChange> filedsList = new List <FieldChange>();
foreach (Audit a in changes)
{
filedsList.Add(new FieldChange(a, property));
}
return(filedsList);
}
/// <summary>
/// Gets the SMS text.
/// </summary>
/// <returns></returns>
public string GetSMSText()
{
StringBuilder builder = new StringBuilder();
CTSContext entities = new CTSContext();
BLL.Dispatch dispatch = entities.Dispatches.Where(d => d.DispatchID == this.DispatchID).SingleOrDefault();
if (dispatch != null)
{
BLL.DispatchDetail com = dispatch.DispatchDetails.FirstOrDefault();
if (com != null)
{
builder.Append(string.Format("There is a Dispatch with an ammount of {0}(MT) - {1} to your FDP({2}) ", com.RequestedQuantityInMT, com.Commodity.Name, dispatch.FDP.Name));
builder.Append(string.Format("on a car with plate no - {0}", dispatch.PlateNo_Prime));
}
}
return builder.ToString();
}
/// <summary>
/// Gets the SMS text.
/// </summary>
/// <returns></returns>
public string GetSMSText()
{
StringBuilder builder = new StringBuilder();
CTSContext entities = new CTSContext();
BLL.Dispatch dispatch = entities.Dispatches.Where(d => d.DispatchID == this.DispatchID).SingleOrDefault();
if (dispatch != null)
{
BLL.DispatchDetail com = dispatch.DispatchDetails.FirstOrDefault();
if (com != null)
{
builder.Append(string.Format("There is a Dispatch with an ammount of {0}(MT) - {1} to your FDP({2}) ", com.RequestedQuantityInMT, com.Commodity.Name, dispatch.FDP.Name));
builder.Append(string.Format("on a car with plate no - {0}", dispatch.PlateNo_Prime));
}
}
return(builder.ToString());
}
public static void SendSMS(int fdpId, string text)
{
CTSContext db = new CTSContext();
var contacts = (from contact in db.Contacts
where contact.FDPID == fdpId
select contact).ToList();
foreach (Contact contact in contacts)
{
// INSERT SMS (InOutInd, MobileNumber, Text, RequestDate, SendAfterDate, Status, StatusDate, Attempts, EventTag)
//VALUES ('O', @MobileNumber, @SMSMessage, @Today, @SendAfterDate, 'pending', @Today, 0, 'SEND_SMS')
SMS sms = new DRMFSS.BLL.SMS();
sms.Attempts = 0;
sms.EventTag = "SEND_SMS";
sms.InOutInd = "O";
sms.LastAttemptDate = null;
sms.MobileNumber = contact.PhoneNo;
sms.Text = text;
sms.RequestDate = DateTime.Today;
sms.SendAfterDate = DateTime.Today;
sms.Status = "pending";
sms.StatusDate = DateTime.Today;
db.SMS.Add(sms);
//try
//{
//}
//catch (Exception e)
//{
//}
}
db.SaveChanges();
}
public static void SendSMS(int fdpId, string text)
{
CTSContext db = new CTSContext();
var contacts = (from contact in db.Contacts
where contact.FDPID == fdpId
select contact).ToList();
foreach (Contact contact in contacts)
{
// INSERT SMS (InOutInd, MobileNumber, Text, RequestDate, SendAfterDate, Status, StatusDate, Attempts, EventTag)
//VALUES ('O', @MobileNumber, @SMSMessage, @Today, @SendAfterDate, 'pending', @Today, 0, 'SEND_SMS')
SMS sms = new DRMFSS.BLL.SMS();
sms.Attempts = 0;
sms.EventTag = "SEND_SMS";
sms.InOutInd = "O";
sms.LastAttemptDate = null;
sms.MobileNumber = contact.PhoneNo;
sms.Text = text;
sms.RequestDate = DateTime.Today;
sms.SendAfterDate = DateTime.Today;
sms.Status = "pending";
sms.StatusDate = DateTime.Today;
db.SMS.Add(sms);
//try
//{
//}
//catch (Exception e)
//{
//}
}
db.SaveChanges();
}
/// <summary>
/// Gets the changes.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="table">The table.</param>
/// <param name="property">The property.</param>
/// <returns></returns>
public static List<FieldChange> GetChanges(int id, string table, string property)
{
string key = id.ToString();
CTSContext db = new CTSContext();
var changes = (from audit in db.Audits
where audit.TableName == table && audit.PrimaryKey == key && audit.NewValue.Contains(property)
orderby audit.DateTime descending
select audit);
List<FieldChange> filedsList = new List<FieldChange>();
foreach (Audit a in changes)
{
filedsList.Add(new FieldChange(a,property));
}
return filedsList;
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
var entities = new CTSContext();
UserProfile user = (from u in entities.UserProfiles
where u.UserName == username
select u).SingleOrDefault();
return (user != null) ? GetMembershipUser(user) : null;
}
/// <summary>
/// Updates the specified inserted.
/// </summary>
/// <param name="inserted">The inserted.</param>
/// <param name="updated">The updated.</param>
/// <param name="deleted">The deleted.</param>
public void Update(List <BLL.ReceiveDetail> inserted, List <BLL.ReceiveDetail> updated,
List <BLL.ReceiveDetail> deleted)
{
CTSContext db = new CTSContext();
BLL.Receive orginal = db.Receives.SingleOrDefault(p => p.ReceiveID == this.ReceiveID);
if (orginal != null)
{
// CreatedDate = DateTime.Now,
orginal.ReceiptDate = this.ReceiptDate;
// orginal.ReceiveID = this.ReceiveID;
orginal.DriverName = this.DriverName;
orginal.GRN = this.GRN;
orginal.PlateNo_Prime = this.PlateNo_Prime;
orginal.PlateNo_Trailer = this.PlateNo_Trailer;
//orginal.StackNumber = this.StackNumber;
orginal.TransporterID = this.TransporterID;
orginal.HubID = this.HubID;
// orginal.SINumber = this.SINumber;
//orginal.CommodityTypeID = this.CommodityTypeID;
orginal.WayBillNo = this.WayBillNo;
orginal.ResponsibleDonorID = this.ResponsibleDonorID;
orginal.SourceDonorID = this.SourceDonorID;
//orginal.ReceivedByStoreMan = this.ReceivedByStoreMan;
//orginal.CommoditySourceID = this.CommoditySourceID;
orginal.WeightBeforeUnloading = this.WeightBeforeUnloading;
orginal.WeightAfterUnloading = this.WeightAfterUnloading;
orginal.Remark = this.Remark;
orginal.VesselName = this.VesselName;
orginal.PortName = this.PortName;
orginal.WeightBridgeTicketNumber = this.WeightBridgeTicketNumber;
foreach (BLL.ReceiveDetail insert in inserted)
{
//TODO THIS should be in transaction
//orginal.ReceiveDetails.Add(insert);
}
foreach (BLL.ReceiveDetail delete in deleted)
{
BLL.ReceiveDetail deletedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == delete.ReceiveDetailID);
if (deletedCommodity != null)
{
// db.ReceiveDetails.DeleteObject(deletedCommodity);
}
}
foreach (BLL.ReceiveDetail update in updated)
{
BLL.ReceiveDetail updatedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == update.ReceiveDetailID);
if (updatedCommodity != null)
{
//updatedCommodity.CommodityID = update.CommodityID;
updatedCommodity.Description = update.Description;
//updatedCommodity.ReceiveDetailID = update.ReceiveDetailID;
//updatedCommodity.SentQuantityInMT = update.SentQuantityInMT;
//updatedCommodity.ReceivedQuantityInMT = updatedCommodity.ReceivedQuantityInMT;
//updatedCommodity.SentQuantityInUnit = update.SentQuantityInUnit;
//updatedCommodity.UnitID = update.UnitID;
}
}
db.SaveChanges();
}
}
/// <summary>
/// Gets the receive by GRN.
/// </summary>
/// <param name="grnNo">The GRN no.</param>
/// <returns></returns>
public static Receive GetReceiveByGRN(string grnNo)
{
CTSContext entities = new CTSContext();
return(entities.Receives.FirstOrDefault(p => p.GRN == grnNo));
}
//TODO: remove the context here.
public override string GetUserNameByEmail(string email)
{
var entities = new CTSContext() ;
UserProfile user = (from u in entities.UserProfiles
where u.Email == email
select u).SingleOrDefault();
return user.UserName;
}
// TODO: Remove the context here.
public override bool ValidateUser(string username, string password)
{
var entities = new CTSContext();
string pass = MD5Hashing.MD5Hash(password);
UserProfile user = (from u in entities.UserProfiles
where u.UserName == username && u.Password == pass &&
!u.LockedInInd && u.ActiveInd
select u).SingleOrDefault();
return (user != null) ? true : false;
}
public override bool ChangePassword(string username, string oldPassword, string newPassword)
{
if (ValidateUser(username, oldPassword))
{
var context = new CTSContext();
UserProfile user = context.UserProfiles.Where(p => p.UserName == username).SingleOrDefault();
if (user != null)
{
user.Password = MD5Hashing.MD5Hash(newPassword);
context.SaveChanges();
return true;
}
}
return false;
}
public static void AddRole(Role role)
{
CTSContext entities = new CTSContext();
entities.Roles.Add(role);
entities.SaveChanges();
}
public static Role GetRole(string name)
{
CTSContext entities = new CTSContext();
return entities.Roles.Where(p => p.Name == name).SingleOrDefault();
;
}
public UnitOfWork()
{
_context= new CTSContext();
}
public static bool RoleExists(string name)
{
CTSContext entities = new CTSContext();
var count = entities.Roles.Where(p => p.Name == name).Count();
return (count > 0);
}
/// <summary>
/// Gets the receive by GRN.
/// </summary>
/// <param name="grnNo">The GRN no.</param>
/// <returns></returns>
public static Receive GetReceiveByGRN(string grnNo)
{
CTSContext entities = new CTSContext();
return entities.Receives.FirstOrDefault(p => p.GRN == grnNo);
}
/// <summary>
/// Updates the specified inserted.
/// </summary>
/// <param name="inserted">The inserted.</param>
/// <param name="updated">The updated.</param>
/// <param name="deleted">The deleted.</param>
public void Update(List<BLL.ReceiveDetail> inserted, List<BLL.ReceiveDetail> updated,
List<BLL.ReceiveDetail> deleted)
{
CTSContext db = new CTSContext();
BLL.Receive orginal = db.Receives.SingleOrDefault(p => p.ReceiveID == this.ReceiveID);
if (orginal != null)
{
// CreatedDate = DateTime.Now,
orginal.ReceiptDate = this.ReceiptDate;
// orginal.ReceiveID = this.ReceiveID;
orginal.DriverName = this.DriverName;
orginal.GRN = this.GRN;
orginal.PlateNo_Prime = this.PlateNo_Prime;
orginal.PlateNo_Trailer = this.PlateNo_Trailer;
//orginal.StackNumber = this.StackNumber;
orginal.TransporterID = this.TransporterID;
orginal.HubID = this.HubID;
// orginal.SINumber = this.SINumber;
//orginal.CommodityTypeID = this.CommodityTypeID;
orginal.WayBillNo = this.WayBillNo;
orginal.ResponsibleDonorID = this.ResponsibleDonorID;
orginal.SourceDonorID = this.SourceDonorID;
//orginal.ReceivedByStoreMan = this.ReceivedByStoreMan;
//orginal.CommoditySourceID = this.CommoditySourceID;
orginal.WeightBeforeUnloading = this.WeightBeforeUnloading;
orginal.WeightAfterUnloading = this.WeightAfterUnloading;
orginal.Remark = this.Remark;
orginal.VesselName = this.VesselName;
orginal.PortName = this.PortName;
orginal.WeightBridgeTicketNumber = this.WeightBridgeTicketNumber;
foreach (BLL.ReceiveDetail insert in inserted)
{
//TODO THIS should be in transaction
//orginal.ReceiveDetails.Add(insert);
}
foreach (BLL.ReceiveDetail delete in deleted)
{
BLL.ReceiveDetail deletedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == delete.ReceiveDetailID);
if (deletedCommodity != null)
{
// db.ReceiveDetails.DeleteObject(deletedCommodity);
}
}
foreach (BLL.ReceiveDetail update in updated)
{
BLL.ReceiveDetail updatedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == update.ReceiveDetailID);
if (updatedCommodity != null)
{
//updatedCommodity.CommodityID = update.CommodityID;
updatedCommodity.Description = update.Description;
//updatedCommodity.ReceiveDetailID = update.ReceiveDetailID;
//updatedCommodity.SentQuantityInMT = update.SentQuantityInMT;
//updatedCommodity.ReceivedQuantityInMT = updatedCommodity.ReceivedQuantityInMT;
//updatedCommodity.SentQuantityInUnit = update.SentQuantityInUnit;
//updatedCommodity.UnitID = update.UnitID;
}
}
db.SaveChanges();
}
}
/// <summary>
/// Determines whether the specified id has updated.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="table">The table.</param>
/// <param name="property">The property.</param>
/// <returns>
/// <c>true</c> if the specified id has updated; otherwise, <c>false</c>.
/// </returns>
public static bool HasUpdated(object id, string table, string property)
{
if(id != null)
{
string stringId = id.ToString();
CTSContext db = new CTSContext();
var count = (from audit in db.Audits
where audit.TableName == table && audit.PrimaryKey.Equals(stringId) && audit.NewValue.Contains(property)
select audit).Count();
return (count > 0);
}
return false;
}
public UnitOfWork()
{
_context = new CTSContext();
}
/// <summary>
/// Determines whether the specified id has updated.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="table">The table.</param>
/// <returns>
/// <c>true</c> if the specified id has updated; otherwise, <c>false</c>.
/// </returns>
public static bool HasUpdated(int id, string table)
{
CTSContext db = new CTSContext();
var count = (from audit in db.Audits
where audit.TableName == table && audit.PrimaryKey == id.ToString()
select audit).Count();
return (count > 0);
}
