public static IEnumerable<Price> GetAllPrice(int InquiryID) { using (var context = new OpenMapDBEntities()) { return (from t in context.PriceListEstimation where t.InquiryID == InquiryID select new Price { // ID = t.InquiryID, InquiryID = t.InquiryID, ItemNo = t.ItemNo, Description = t.Description, MaterialSpec = t.MaterialSpec, Qty = t.Qty, UnitWeight = t.UnitWeight, TotalWeight = t.TotalWeight, UnitPrice = t.UnitPrice, TotalPrice = t.TotalPrice, SPFCC = t.SPFCC, SPF2Y = t.SPF2Y, Remark = t.Remark, Margin = t.Margin }).ToList(); } }
public static User Login(string PostNIK, string PostPassword ) { OpenMapDBEntities openMapDB = new OpenMapDBEntities(); try { User user = openMapDB.User.Single(u => u.NIK == PostNIK); if (user != null) { string hashedPassword = EncryptPassword(PostPassword); if (user.Password == hashedPassword) { return user; } } } catch (InvalidOperationException e) { } return null; }