public Result billDetailCodeQuery(long cityID, string code, StartEndMonthClass startend, int pageSize, mode searchType) { DaftarModelDataContext db = new DaftarModelDataContext(cn); int depositValue = -1; int refundValue = -1; switch (searchType) { case mode.all: depositValue = -1; refundValue = -1; break; case mode.deposit: depositValue = -1; refundValue = 0; break; case mode.refund: depositValue = 0; refundValue = -1; break; } Result result = new Result(); if (cityID == 0) { var query = (from c in db.DaftarTables.Where(x => x.RealDate >= startend.startDate && x.RealDate <= startend.endDate && x.BillDetailCode.ToString().Contains(code) && x.Deposit.Value > depositValue && x.Refund.Value > refundValue) select c); var count = query.Count(); result.recordCount = count; result.queryPageNumber = count / pageSize; result.query = query; return(result); } var query2 = (from c in db.DaftarTables.Where(x => x.CityID == cityID && x.RealDate >= startend.startDate && x.RealDate <= startend.endDate && x.BillDetailCode.ToString().Contains(code) && x.Deposit.Value > depositValue && x.Refund.Value > refundValue) select c); var count2 = query2.Count(); result.recordCount = count2; result.queryPageNumber = count2 / pageSize; result.query = query2; return(result); }
private void searchButton_Click(object sender, EventArgs e) { DateTime endTime = dateTimePickerX1.SelectedDateInDateTime; DateTime startTime = dateTimePickerX2.SelectedDateInDateTime; StartEndMonthClass date = new StartEndMonthClass(); date.startDate = Convert.ToInt64(startTime.ToFa("yyyyMMdd")); date.endDate = Convert.ToInt64(endTime.ToFa("yyyyMMdd")); form.advanceSearch(date); this.Hide(); }
public StartEndMonthClass getStartEndofMonth(int year, long month) { int days = getMonthsDay(year, Convert.ToInt32(month)); string endDate = year.ToString() + "/" + month + "/" + days.ToString(); endDate = endDate.ToEn().ToFa("yyyyMMdd"); string startDate = year.ToString() + "/" + month + "/" + "01"; startDate = startDate.ToEn().ToFa("yyyyMMdd"); StartEndMonthClass st = new StartEndMonthClass(); st.startDate = Convert.ToInt64(startDate); st.endDate = Convert.ToInt64(endDate); return(st); }
public StartEndMonthClass findMinMaxInQuery(IQueryable <Daftarcs> data) { StartEndMonthClass minmax = new StartEndMonthClass(); try { DaftarModelDataContext db = new DaftarModelDataContext(cn); var q = from row in data group row by true into r select new { min = r.Min(z => z.RealDate), max = r.Max(z => z.RealDate) }; foreach (var a in q) { minmax.endDate = a.max; minmax.startDate = a.min; } return(minmax); } catch (Exception) { throw; } }
private void addRestriction() { try { validationTable valid = new validationTable(); DateTime endTime = endDateTimePickerX1.SelectedDateInDateTime; StartEndMonthClass date = new StartEndMonthClass(); date.endDate = Convert.ToInt64(endTime.ToFa("yyyyMMdd")); valid.startDate = startendDate.min; valid.enDate = date.endDate; valid.City = Convert.ToInt64(validCityComboBox.SelectedValue); SqlManipulator sql = new SqlManipulator(); //if (this.lockAllCitiesCheckBox.Checked == true) //{ // var cities = sql.getDataCity(); // foreach(var city in cities) // { // } //} var cityName = sql.getCityName(valid.City); FarsiDateUtil startDate = new FarsiDateUtil(startendDate.min.ToString()); FarsiDateUtil endDate = new FarsiDateUtil(date.endDate.ToString()); valid.description = "قفل" + " " + cityName + " " + endDate.MonthName + endDate.Year; Reporter rpt = new Reporter(sql.addValidation(valid), (int)errorImages.info); rpt.Show(); makeValidationTable(sql.getValidationData()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public List <string> refundFromFile(IQueryable <Daftarcs> excelQuery, long cityID) { try { List <string> report = new List <string>(); Utility utl = new Utility(); DaftarModelDataContext db = new DaftarModelDataContext(cn); List <DaftarTable> listDaftar = new List <DaftarTable>(); StartEndMonthClass date = findMinMaxInQuery(excelQuery); foreach (var row in excelQuery) { DaftarTable newDaftar = new DaftarTable(); newDaftar.DepositOwnerDetail = row.DepositOwnerDetail; newDaftar.PlaceName = row.PlaceName; newDaftar.AccountType = row.AccountType; newDaftar.Date = row.Date; newDaftar.RealDate = utl.changeToRealDate(newDaftar.Date); newDaftar.BillDetailCode = Convert.ToInt64(row.BillDetailCode); newDaftar.CodeBudget = Convert.ToInt64(row.CodeBudget); newDaftar.Deposit = Convert.ToInt64(row.Deposit); newDaftar.DepositDetail = Convert.ToInt64(row.DepositDetail); newDaftar.Refund = Convert.ToInt64(row.Refund); newDaftar.Id = utl.idGenerator(cityID, newDaftar.Date, newDaftar.BillDetailCode); newDaftar.CityID = cityID; listDaftar.Add(newDaftar); } var query = listDaftar.AsQueryable(); var search = (from c in db.DaftarTables.Where(x => x.CityID == cityID && x.RealDate >= date.startDate && x.RealDate <= date.endDate) select c); foreach (var b in query) { bool refunded = false; foreach (var a in search) { if (a.Id == b.Id) { if (b.Refund != 0 && b.Deposit == 0 && a.Refund == 0) { a.Refund = a.Deposit; a.Deposit = 0; report.Add(a.DepositOwnerDetail + " " + a.Id + "استرداد شد"); refunded = true; } } } if (!refunded) { report.Add(b.DepositOwnerDetail + " " + b.Id + "خطا در استرداد"); } } db.SubmitChanges(); excelQuery = null; return(report); } catch (Exception ex) { string exp = "خطا"; List <string> report = new List <string>(); report.Add(ex.ToString()); report.Add(exp); return(report); } }