private void Upd_ByID(HttpContext context)
{
String jSonString = "";
try {
Permits aPermits = new Permits();
int idPermits = Convert.ToInt32(context.Request.Form["txtID"]);
aPermits.ID = idPermits;
aPermits.Name = !String.IsNullOrEmpty(context.Request.Form["txtName"])
? Convert.ToString(context.Request.Form["txtName"])
: aPermits.Name;
aPermits.SystemKey = !String.IsNullOrEmpty(context.Request.Form["txtSystemKey"])
? Convert.ToString(context.Request.Form["txtSystemKey"])
: aPermits.SystemKey;
aPermits.IsAdmin = !String.IsNullOrEmpty(context.Request.Form["cbbIsAdmin"])
? Convert.ToBoolean(context.Request.Form["cbbIsAdmin"])
: aPermits.IsAdmin;
aPermits.IsContent = !String.IsNullOrEmpty(context.Request.Form["cbbIsContent"])
? Convert.ToBoolean(context.Request.Form["cbbIsContent"])
: aPermits.IsContent;
aPermits.IsPartner = !String.IsNullOrEmpty(context.Request.Form["cbbIsPartner"])
? Convert.ToBoolean(context.Request.Form["cbbIsPartner"])
: aPermits.IsPartner;
aPermits.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: aPermits.Type;
aPermits.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: aPermits.Status;
aPermits.Disable = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToBoolean(context.Request.Form["cbbDisable"])
: aPermits.Disable;
PermitsBO aPermitsBo = new PermitsBO();
int ret = aPermitsBo.Upd(aPermits);
if (ret != 0)
{
jSonString = "{\"status\": \"success\"}";
}
if (ret == 0)
{
jSonString = "{\"status\":\"error|" + ret + "\"}";
}
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
public void TestUnique() //testing the number of unique vehicles counted
{
Console.WriteLine("Testing UniqueVehicles()"); //print message
int result = Permits.UniqueVehicles(); //call method and save as result
Assert.AreEqual(10, result); //check if result correct
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddDbContext <ApplicationDbContext>(options =>
options.UseSqlServer(
Configuration.GetConnectionString("DefaultConnection")));
services.AddDbContext <ContosoUnivContext>(options =>
options.UseSqlServer(
Configuration.GetConnectionString("DefaultConnection")));
services.AddDatabaseDeveloperPageExceptionFilter();
services.AddDefaultIdentity <IdentityUser>(options => options.SignIn.RequireConfirmedAccount = false)
.AddRoles <IdentityRole>()
.AddEntityFrameworkStores <ApplicationDbContext>();
services.AddControllersWithViews();
#if DEBUG
services.AddRazorPages().AddRazorRuntimeCompilation();
#endif
services.AddAuthorization(options =>
{
foreach (var claim in Permits.GetAllPermits())
{
options.AddPolicy(claim, policy => policy.RequireClaim(claim));
}
});
// services.AddScoped<IClaimsTransformation, RoleClaimTransformer>();
}
public void TestPermitsIssued()
{
Console.WriteLine("Testing PermitsIssued()"); //print message
int result = Permits.PermitsIssued(); //call method and save as result
Assert.AreEqual(8, result); //check if result correct
}
public Permits Details(int?id)
{
Permits model = new Permits();
model = _context.Permit.Where(a => a.Id == id).Select(b => b).FirstOrDefault();
return(model);
}
public static PermitsModel EntityToModel(this Permits entity, bool virtualActive = false)
{
try
{
PermitsModel model = new PermitsModel()
{
EmployeeId = entity.EmployeeId,
EndDate = entity.EndDate,
PermitTypeId = entity.PermitTypeId,
StartingDate = entity.StartingDate,
IsActive = entity.IsActive,
Id = entity.Id
};
if (virtualActive)
{
model.PermitType = entity.PermitType;
model.Employee = entity.Employee;
}
return(model);
}
catch (Exception)
{
return(new PermitsModel());
}
}
public void TestFees()
{
Console.WriteLine("Testing FeesCalculation()"); //print message
int result = Permits.FeesCalculation(); //call method and save as result
Assert.AreEqual(400, result); //check if result correct
}
public ActionResult PermitDelete(int id)
{
Permits permit = _servicePermits.GetById(id);
permit.IsActive = false;
_servicePermits.Update(permit);
return(RedirectToAction("PermitList"));
}
public ActionResult PermitInsert(PermitsModel permitsModel)
{
Permits permit = permitsModel.ModelToEnity();
permit.IsActive = true;
_servicePermits.Insert(permit);
return(RedirectToAction("PermitList"));
}
public ActionResult PermitEdit(PermitsModel permits)
{
Permits permit = permits.ModelToEnity(true);
permit.IsActive = true;
_servicePermits.Update(permit);
return(RedirectToAction("PermitList"));
}
private void Initialize()
{
DataTable MonthsDT = new DataTable();
MonthsDT.Columns.Add(new DataColumn("MonthID", Type.GetType("System.Int32")));
MonthsDT.Columns.Add(new DataColumn("MonthName", Type.GetType("System.String")));
DataTable YearsDT = new DataTable();
YearsDT.Columns.Add(new DataColumn("YearID", Type.GetType("System.Int32")));
YearsDT.Columns.Add(new DataColumn("YearName", Type.GetType("System.String")));
for (int i = 1; i <= 12; i++)
{
DataRow NewRow = MonthsDT.NewRow();
NewRow["MonthID"] = i;
NewRow["MonthName"] = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(i).ToString();
MonthsDT.Rows.Add(NewRow);
}
cbxMonths.DataSource = MonthsDT.DefaultView;
cbxMonths.ValueMember = "MonthID";
cbxMonths.DisplayMember = "MonthName";
DateTime LastDay = new System.DateTime(DateTime.Now.Year, 12, 31);
System.Collections.ArrayList Years = new System.Collections.ArrayList();
for (int i = 2013; i <= LastDay.Year; i++)
{
DataRow NewRow = YearsDT.NewRow();
NewRow["YearID"] = i;
NewRow["YearName"] = i;
YearsDT.Rows.Add(NewRow);
Years.Add(i);
}
cbxYears.DataSource = YearsDT.DefaultView;
cbxYears.ValueMember = "YearID";
cbxYears.DisplayMember = "YearName";
cbxMonths.SelectedValue = DateTime.Now.Month;
cbxYears.SelectedValue = DateTime.Now.Year;
PermitsManager = new Permits();
PermitsManager.Initialize();
dgvPermitsDates.DataSource = PermitsManager.PermitsDatesList;
dgvPermitsDatesSetting();
dgvPermits.DataSource = PermitsManager.PermitsList;
dgvPermits.Columns.Add(PermitsManager.CreateUserColumn);
dgvPermits.Columns.Add(PermitsManager.SignUserColumn);
dgvPermitsSettings(ref dgvPermits);
dgvMDispatch.DataSource = PermitsManager.MDispatchList;
dgvDispatchSetting(ref dgvMDispatch);
dgvZDispatch.DataSource = PermitsManager.ZDispatchList;
dgvDispatchSetting(ref dgvZDispatch);
dgvUnloads.DataSource = PermitsManager.UnloadsList;
dgvUnloadsSetting(ref dgvUnloads);
}
public int Ins(Permits aPermits)
{
try {
_aDatabaseDa.Permits.AddOrUpdate(aPermits);
return(_aDatabaseDa.SaveChanges());
}
catch (Exception ex) {
throw new Exception(String.Format("PermitsBO.Ins: {0}", ex.Message));
}
}
public Permits Sel_ByID(Int32 id)
{
try {
Permits aPermits = _aDatabaseDa.Permits.Where(b => b.ID == id).ToList()[0];
return(aPermits);
}
catch (Exception ex) {
throw new Exception(String.Format("PermitsBO.Sel: {0}", ex.Message));
}
}
public bool ActionPermitted(Actions action, int role)
{
Permit featurePermit = Permits.Find(permit => permit.Action == action);
if (featurePermit != null && featurePermit.Role <= role)
{
return(true);
}
return(false);
}
public void LoadPermitList(string selectedItems = "")
{
selectedItems ??= "";
var selectedList = selectedItems.Split(new char[] { ';' });
PermitList = Permits.GetAllPermits().Select(p => new SelectListItem
{
Text = p,
Value = p.Replace('.', '_'),
Selected = selectedList.Contains(p.Replace('.', '_'))
}).ToList();
}
private void Ins(HttpContext context)
{
String jSonString = "";
try {
Permits permits = new Permits {
Name = !String.IsNullOrEmpty(context.Request.Form["txtName"])
? Convert.ToString(context.Request.Form["txtName"])
: "",
IsAdmin = !String.IsNullOrEmpty(context.Request.Form["cbbIsAdmin"])
? Convert.ToBoolean(context.Request.Form["cbbIsAdmin"])
: false,
IsContent = !String.IsNullOrEmpty(context.Request.Form["cbbIsContent"])
? Convert.ToBoolean(context.Request.Form["cbbIsContent"])
: false,
IsPartner = !String.IsNullOrEmpty(context.Request.Form["cbbIsPartner"])
? Convert.ToBoolean(context.Request.Form["cbbIsPartner"])
: false,
Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: 0,
Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: 0,
SystemKey = !String.IsNullOrEmpty(context.Request.Form["txtSystemKey"])
? Convert.ToString(context.Request.Form["txtSystemKey"])
: "",
Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["cbbDisable"])
: false
};
PermitsBO permitsBo = new PermitsBO();
int ret = permitsBo.Ins(permits);
if (ret != 0)
{
jSonString = "{\"status\": \"success\"}";
}
if (ret == 0)
{
jSonString = "{\"status\":\"error|" + ret + "\"}";
}
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
public bool Delete(Permits model)
{
try
{
_context.Entry(model).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
_context.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public void UpdateFee(string affidavitNo, bool isChecked)
{
var permit = Permits.Where(x => x.Affidavit.Equals(long.Parse(affidavitNo))).FirstOrDefault();
if (isChecked)
{
TotalFee = (decimal.Parse(TotalFee.ToString()) + decimal.Parse(permit.Fee)).ToString();
permit.IsSelected = true;
}
else
{
TotalFee = (decimal.Parse(TotalFee.ToString()) - decimal.Parse(permit.Fee)).ToString();
permit.IsSelected = false;
}
}
public IActionResult Delete(PermitsViewModel model)
{
var type = new Permits
{
Id = model.Id,
EmployeeName = model.EmployeeName,
EmployeeLastName = model.EmployeeLastName,
PermissionType = model.PermissionType,
PermitDate = model.PermitDate
};
_permitsservice.Delete(type);
return(RedirectToAction("Index"));
}
public IActionResult Insert(PermitsViewModel model)
{
if (!ModelState.IsValid)
{
return(View("Create", model));
}
var type = new Permits
{
EmployeeName = model.EmployeeName,
EmployeeLastName = model.EmployeeLastName,
PermissionType = model.PermissionType,
PermitDate = model.PermitDate
};
_permitsservice.Create(type);
return(RedirectToAction("Index"));
}
public IActionResult Create(Permits permits)
{
var permit = _permitDataAccess.AddAsync(new Permits()
{
Id = ObjectId.GenerateNewId().ToString(),
UserId = permits.UserId,
EmailPermit = permits.EmailPermit,
AppPermit = permits.AppPermit,
WebPermit = permits.WebPermit
});
if (permit == null)
{
return(BadRequest(new { message = "Permit eklenemedi!" }));
}
return(Ok(new { permit.Result }));
}
public static Permits ModelToEnity(this PermitsModel model, bool virtualActive = false)
{
Permits entity = new Permits()
{
EmployeeId = model.EmployeeId,
EndDate = model.EndDate,
PermitTypeId = model.PermitTypeId,
StartingDate = model.StartingDate,
Id = model.Id,
IsActive = model.IsActive
};
if (virtualActive)
{
entity.Employee = model.Employee;
entity.PermitType = model.PermitType;
}
return entity;
}
public static Permits ModelToEnity(this PermitsModel model, bool virtualActive = false)
{
Permits entity = new Permits()
{
EmployeeId = model.EmployeeId,
EndDate = model.EndDate,
PermitTypeId = model.PermitTypeId,
StartingDate = model.StartingDate,
Id = model.Id,
IsActive = model.IsActive
};
if (virtualActive)
{
entity.Employee = model.Employee;
entity.PermitType = model.PermitType;
}
return(entity);
}
private void Sel_ByID(HttpContext context)
{
String jSonString = "";
PermitsBO permitsBO = new PermitsBO();
int id = Convert.ToInt32(context.Request.QueryString["ID"]);
bool disable = !String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
Permits permits =
String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? permitsBO.Sel_ByID(id)
: permitsBO.Sel_ByID(id, disable);
if (permits != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(permits, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
/// <summary>
/// this method will get permits by contractor
/// </summary>
/// <param name="contractorName"></param>
async void GetPermitByContractor(string contractorName)
{
PermitList = await _dataService.GetPermitsByApplicant(contractorName);
foreach (var item in PermitList)
{
ContractorPermit permit = new ContractorPermit();
permit.Affidavit = (long)item.Permit.AffidavitID;
permit.NEW_AFF = AffidavitInfo.NEW_AFF;
permit.Fee = item.Permit.TotalFee.Value.ToString();
permit.IsSelected = true;
permit.PetmitID = item.Permit.PermitID;
permit.PropertyAddress = string.Format("{0} {1} {2} {3}", item.Affidavit.st_no.Trim(), item.Affidavit.district.Trim(), item.Affidavit.st_name.Trim(), item.Affidavit.designator.Trim());
//TotalFee = (decimal.Parse(TotalFee) + item.Permit.TotalFee.Value).ToString();
if (item.Permit.DateExpired > NewExpireDate)
{
NewExpireDate = (DateTime)item.Permit.DateExpired;
}
permit.ExpirationDate = item.Permit.DateExpired.Value.ToShortDateString();
Permits.Add(permit);
}
}
private void BindModel()
{
var mod = this.Manager.ActiveModel;
BindingSource bsMod = new BindingSource();
bsMod.DataSource = mod;
BindingSource bsPermits = new BindingSource();
bsPermits.DataSource = this.Manager.Permits;
Permits.DataSource = bsPermits;
BindingSource bsReminders = new BindingSource();
bsReminders.DataSource = mod.Reminders;
gridControlReminders.DataSource = bsReminders;
DriverID.DataBindings.Clear();
DriverID.DataBindings.Add("DriverID", bsMod, mod.GetName(p => p.DriverID), true, DataSourceUpdateMode.OnPropertyChanged);
LicenseID.DataBindings.Clear();
LicenseID.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.LicenseID), true, DataSourceUpdateMode.OnPropertyChanged);
IssueDate.DataBindings.Clear();
IssueDate.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.IssueDate), true, DataSourceUpdateMode.OnPropertyChanged);
ExpirationDate.DataBindings.Clear();
ExpirationDate.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.ExpirationDate), true, DataSourceUpdateMode.OnPropertyChanged);
MVRReviewDate.DataBindings.Clear();
MVRReviewDate.DataBindings.Add("EditValue", bsMod, mod.GetName(p => p.MVRReviewDate), true, DataSourceUpdateMode.OnPropertyChanged);
for (int i = 0; i < this.Manager.Permits.Count; i++)
{
var per = this.Manager.Permits[i];
Permits.SetItemChecked(i, per.IsCheck);
}
}
private void Permits_ItemCheck(object sender, DevExpress.XtraEditors.Controls.ItemCheckEventArgs e)
{
var mod = Permits.GetItem(e.Index) as UtilityModel <uint>;
mod.IsCheck = e.State == CheckState.Checked;
}
