public IQueryable getValidationDataByCityandDate(int cityID, long startDate, long endDate)
{
ValidationDataClassesDataContext db = new ValidationDataClassesDataContext(cn);
var q = from c in db.validationTables.Where(x => x.id == cityID && x.startDate == startDate && x.enDate == endDate)
select new
{
c.id,
c.description,
c.City,
c.startDate,
c.enDate,
};
return(q);
}
public IQueryable getValidationData()
{
ValidationDataClassesDataContext db = new ValidationDataClassesDataContext(cn);
var q = from c in db.validationTables
select new
{
c.id,
c.description,
c.City,
c.startDate,
c.enDate,
};
return(q);
}
public Boolean isRestricted(DaftarTable data, bool permission)
{
try {
if (permission)
{
return(false);
}
ValidationDataClassesDataContext db = new ValidationDataClassesDataContext(cn);
var valid = (from c in db.validationTables.Where(x => x.City == data.CityID && data.RealDate >= x.startDate && data.RealDate <= x.enDate) select c).Any();
return(valid);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public Boolean removeRestriction(validationTable restriction)
{
try
{
ValidationDataClassesDataContext db = new ValidationDataClassesDataContext(cn);
var q = from a in db.validationTables where a.id == restriction.id select a;
foreach (var a in q)
{
db.validationTables.DeleteOnSubmit(a);
}
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public List <string> addValidation(validationTable newRestriction)
{
try
{
ValidationDataClassesDataContext db = new ValidationDataClassesDataContext(cn);
db.validationTables.InsertOnSubmit(newRestriction);
db.SubmitChanges();
List <string> report = new List <string>();
report.Add(newRestriction.description + "" + " با موفقیت اضافه گردید");
return(report);
}
catch (System.Data.SqlClient.SqlException)
{
// DaftarModelDataContext db = new DaftarModelDataContext(cn);
List <string> report = new List <string>();
report.Add("خطا در اضافه کردن محدودیت");
return(report);
}
}
