public static int Delete(int PaymentRangeID)
        {
            String sql = "SELECT ForeignEmploymentStatusID FROM tbl_foreign_employment_status " +
                         "WHERE MadePaymentRangeID = " + PaymentRangeID  + " OR AskedPayemntRageID = " + PaymentRangeID +
                         " OR ReceiptPaymentRangeID = " + PaymentRangeID;
            DataView dv = new BaseDAO().ExecuteQuery(sql);

            if(dv.Count == 0)
                return new PaymentRangesDAO().Delete("PaymentRangeID=" + PaymentRangeID);

            return -1;
        }
        public static List<EvidencesPerCase> GetAllByCaseID(int CaseID)
        {
            List<EvidencesPerCase> lstEvidencesPerCase = new List<EvidencesPerCase>();

            DataView objDataView = new BaseDAO().Select("*", "tbl_evidences_per_case", "CaseID=" + CaseID);

            foreach (DataRowView drv in objDataView)
            {
                EvidencesPerCase objEvidencesPerCase = new EvidencesPerCase();
                objEvidencesPerCase.EvidencesPerCaseID = (int)drv["EvidencesPerCaseID"];
                objEvidencesPerCase.EvidenceTypeID = (int)drv["EvidenceTypeID"];
                objEvidencesPerCase.CaseID = (int)drv["CaseID"];
                lstEvidencesPerCase.Add(objEvidencesPerCase);
            }

            return lstEvidencesPerCase;
        }
示例#3
0
 public static DateTime GetCurrentDate()
 {
     DataView dv = new BaseDAO().GetServerDate();
     return Convert.ToDateTime(dv.Table.Rows[0]["datetime"].ToString());
 }
示例#4
0
        public static int GetOptionValue(String Value, String Key, String Field, String Table)
        {
            int val = 0;

            DataView dv = new BaseDAO().Select(Field + " AS VAL ", Table, Key + " = '" + Value + "'");
            if (dv.Count > 0)
                return Convert.ToInt32(dv.Table.Rows[0]["VAL"]);

            return val;
        }