Example #1
0
 public static tbl_AgentProductVariable GetByID(int ID)
 {
     using (var dbe = new inventorymanagementEntities())
     {
         tbl_AgentProductVariable ai = dbe.tbl_AgentProductVariable.Where(a => a.ID == ID).SingleOrDefault();
         if (ai != null)
         {
             return(ai);
         }
         else
         {
             return(null);
         }
     }
 }
Example #2
0
 public static string Insert(int AgentID, int ProductVariableID, double Quantity, bool IsHidden, DateTime CreatedDate, string CreatedBy)
 {
     using (var dbe = new inventorymanagementEntities())
     {
         tbl_AgentProductVariable ui = new tbl_AgentProductVariable();
         ui.AgentID           = AgentID;
         ui.ProductVariableID = ProductVariableID;
         ui.Quantity          = Quantity;
         ui.IsHidden          = IsHidden;
         ui.CreatedDate       = CreatedDate;
         ui.CreatedBy         = CreatedBy;
         dbe.tbl_AgentProductVariable.Add(ui);
         int kq = dbe.SaveChanges();
         return(kq.ToString());
     }
 }
Example #3
0
 public static string Update(int ID, int AgentID, int ProductVariableID, double Quantity, bool IsHidden, DateTime ModifiedDate, string ModifiedBy)
 {
     using (var dbe = new inventorymanagementEntities())
     {
         tbl_AgentProductVariable ui = dbe.tbl_AgentProductVariable.Where(a => a.ID == ID).SingleOrDefault();
         if (ui != null)
         {
             ui.AgentID           = AgentID;
             ui.ProductVariableID = ProductVariableID;
             ui.Quantity          = Quantity;
             ui.IsHidden          = IsHidden;
             ui.ModifiedBy        = ModifiedBy;
             ui.ModifiedDate      = ModifiedDate;
             int kq = dbe.SaveChanges();
             return(kq.ToString());
         }
         else
         {
             return(null);
         }
     }
 }