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);
}
}
