public int AddBill(BillModel bill)
        {
            try
            {
                bill_t_test billDB = new bill_t_test();
                billDB.BILL_T_TEST_ID             = bill.BILL_T_TEST_ID;
                billDB.EMP_T_TEST_ID              = bill.EMP_T_TEST_ID;
                billDB.EMP_T_TEST_NAME            = bill.EMP_T_TEST_NAME;
                billDB.TYPE_M_TEST_ID             = bill.TYPE_M_TEST_ID;
                billDB.STAT_M_TEST_ID             = bill.STAT_M_TEST_ID;
                billDB.BILL_T_TES_VALUES          = bill.BILL_T_TES_VALUES;
                billDB.BILL_T_TEST_DATE           = bill.BILL_T_TEST_DATE;
                billDB.BILL_T_TEST_TIMESTMP       = bill.BILL_T_TEST_TIMESTMP;
                billDB.BILL_T_TEST_ACTINE         = bill.BILL_T_TEST_ACTINE;
                billDB.BILL_T_TEST_APPROVE_IDNAME = bill.BILL_T_TEST_APPROVE_IDNAME;

                db.bill_t_test.Add(billDB);
                db.SaveChanges();
                int idBill = billDB.BILL_T_TEST_ID;
                return(idBill);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
 public bool DeleteRequestWithdraw(List <BillModel> delUniqueID)
 {
     try
     {
         List <bill_t_test> b = new List <bill_t_test>();
         foreach (BillModel billT in delUniqueID)
         {
             bill_t_test bt = new bill_t_test();
             bt.BILL_T_TEST_ID             = billT.BILL_T_TEST_ID;
             bt.BILL_T_TEST_ACTINE         = billT.BILL_T_TEST_ACTINE;
             bt.BILL_T_TEST_APPROVE_IDNAME = billT.BILL_T_TEST_APPROVE_IDNAME;
             bt.BILL_T_TEST_DATE           = billT.BILL_T_TEST_DATE;
             bt.BILL_T_TEST_TIMESTMP       = billT.BILL_T_TEST_TIMESTMP;
             bt.BILL_T_TES_VALUES          = billT.BILL_T_TES_VALUES;
             bt.EMP_T_TEST_ID   = billT.EMP_T_TEST_ID;
             bt.EMP_T_TEST_NAME = billT.EMP_T_TEST_NAME;
             bt.STAT_M_TEST_ID  = billT.STAT_M_TEST_ID;
             bt.TYPE_M_TEST_ID  = billT.TYPE_M_TEST_ID;
             b.Add(bt);
         }
         foreach (bill_t_test btt in b)
         {
             db.bill_t_test.Attach(btt);
             db.bill_t_test.Remove(btt);
             db.SaveChanges();
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #3
0
 internal BillModel Mapping(bill_t_test m)
 {
     try
     {
         if (m != null)
         {
             return(new BillModel()
             {
                 BILL_T_TEST_ID = m.BILL_T_TEST_ID,
                 EMP_T_TEST_NAME = m.EMP_T_TEST_NAME,
                 EMP_T_TEST_ID = (int)m.EMP_T_TEST_ID,
                 TYPE_M_TEST_ID = (int)m.TYPE_M_TEST_ID,
                 STAT_M_TEST_ID = (int)m.STAT_M_TEST_ID,
                 BILL_T_TES_VALUES = (int)m.BILL_T_TES_VALUES,
                 BILL_T_TEST_DATE = (DateTime)m.BILL_T_TEST_DATE,
                 BILL_T_TEST_TIMESTMP = (DateTime)m.BILL_T_TEST_TIMESTMP,
                 BILL_T_TEST_ACTINE = m.BILL_T_TEST_ACTINE,
                 BILL_T_TEST_APPROVE_IDNAME = (int)m.BILL_T_TEST_APPROVE_IDNAME
             });
         }
         return(null);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public bool UpdateRequestApprove(List <BillModel> billStatus)
 {
     try
     {
         foreach (BillModel b in billStatus)
         {
             bill_t_test bbT = IQueryableBill().FirstOrDefault(bil => bil.BILL_T_TEST_ID == b.BILL_T_TEST_ID);
             bbT.STAT_M_TEST_ID = b.STAT_M_TEST_ID;
             db.SaveChanges();
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public bool UpdateApprove(List <BillModel> billStatus)
 {
     try
     {
         foreach (BillModel b in billStatus)
         {
             bill_t_test billDB = IQueryableBill().FirstOrDefault(s => s.BILL_T_TEST_ID == b.BILL_T_TEST_ID);
             billDB.STAT_M_TEST_ID             = b.STAT_M_TEST_ID;
             billDB.BILL_T_TEST_APPROVE_IDNAME = b.BILL_T_TEST_APPROVE_IDNAME;
             db.SaveChanges();
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }