public static DataTable GetAllReceiptTypesForReceive() { var receiptType = new ReceiptType(); var query = HCMIS.Repository.Queries.ReceiptType.SelectGetAllReceiptTypes(); receiptType.LoadFromRawSql(query); var dt = receiptType.DataTable; if (BLL.Settings.IsCenter) dt = dt.AsEnumerable() .Where( dr => dr.Field<string>("ReceiptTypeCode") != "DN" && dr.Field<string>("ReceiptTypeCode") != "MDN") .CopyToDataTable(); return dt; }
public static DataTable GetAllReceiptTypesForReceive() { var receiptType = new ReceiptType(); var query = HCMIS.Repository.Queries.ReceiptType.SelectGetAllReceiptTypes(); receiptType.LoadFromRawSql(query); var dt = receiptType.DataTable; if (BLL.Settings.IsCenter) { dt = dt.AsEnumerable() .Where( dr => dr.Field <string>("ReceiptTypeCode") != "DN" && dr.Field <string>("ReceiptTypeCode") != "MDN") .CopyToDataTable(); } return(dt); }