private GenericValidator ValidatePermit(PermitObject permit)
{
var gVal = new GenericValidator();
try
{
if (permit.Id < 1)
{
gVal.Code = -1;
gVal.Error = "Please select a Permit.";
return(gVal);
}
gVal.Code = 5;
return(gVal);
}
catch (Exception)
{
gVal.Code = -1;
gVal.Error = "Permit Validation failed. Please provide all required fields and try again.";
return(gVal);
}
}
public long UpdatePermit(PermitObject permit)
{
try
{
if (permit == null)
{
return(-2);
}
var permitEntity = ModelMapper.Map <PermitObject, Permit>(permit);
if (permitEntity == null || permitEntity.Id < 1)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
db.Permits.Attach(permitEntity);
db.Entry(permitEntity).State = EntityState.Modified;
db.SaveChanges();
return(permit.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
private PermitObject ProcessRecord(DataRowView dv, ref string msg)
{
if (dv == null)
{
return(null);
}
try
{
var permit = new PermitObject();
var companyName = dv.Row["Company"].ToString().Trim();
if (string.IsNullOrEmpty(companyName))
{
msg = "Company Name is empty.";
return(null);
}
permit.CompanyName = companyName;
var refCode = dv.Row["Reference_Number"].ToString().Trim();
if (string.IsNullOrEmpty(refCode))
{
msg = "License Number is empty.";
return(null);
}
var issueDate = dv.Row["Issue_Date"].ToString().Trim();
if (string.IsNullOrEmpty(issueDate))
{
msg = "Issue Date is empty.";
return(null);
}
var expiryDate = dv.Row["Expiry_Date"].ToString().Trim();
if (string.IsNullOrEmpty(expiryDate))
{
msg = "Expiry Date is empty.";
return(null);
}
permit.ExpiryDate = DateTime.Parse(expiryDate);
permit.IssueDate = DateTime.Parse(issueDate);
permit.PermitStatus = 2;
permit.PermitValue = refCode;
permit.PermitNo = 0;
permit.ImporterId = 0;
permit.DateAdded = DateTime.Now;
permit.QuantityImported = 0;
permit.file = "";
return(permit);
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public long UpdatePermit(PermitObject permit)
{
try
{
return(_permitManager.UpdatePermit(permit));
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult EditPermit(PermitObject permit)
{
var gVal = new GenericValidator();
try
{
var stat = ValidatePermit(permit);
if (stat.Code < 1)
{
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
if (Session["_permit"] == null)
{
gVal.Code = -1;
gVal.Error = "Session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var oldpermit = Session["_permit"] as PermitObject;
if (oldpermit == null)
{
gVal.Code = -1;
gVal.Error = "Session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
oldpermit.Id = permit.Id;
var docPermitStatus = new PermitServices().UpdatePermit(oldpermit);
if (docPermitStatus < 1)
{
gVal.Code = -1;
gVal.Error = docPermitStatus == -3 ? "Permit already exists." : "Permit information could not be updated. Please try again later";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = oldpermit.Id;
gVal.Error = "Permit information was successfully updated";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
gVal.Code = -1;
gVal.Error = "Permit information could not be updated. Please try again later";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
public long AddPermit(PermitObject permit)
{
try
{
if (permit == null)
{
return(-2);
}
var permitEntity = ModelMapper.Map <PermitObject, Permit>(permit);
if (permitEntity == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
var stopDate = DateTime.Parse("2015-07-31");
if (DateTime.Today <= stopDate)
{
var existingSimilarPermits = db.Permits.Where(m => m.PermitValue.Trim() == permit.PermitValue.Trim() && m.ImporterId == permit.ImporterId).ToList();
if (existingSimilarPermits.Any())
{
return(existingSimilarPermits[0].Id);
}
var returnStatus = db.Permits.Add(permitEntity);
db.SaveChanges();
return(returnStatus.Id);
}
else
{
var returnStatus = db.Permits.Add(permitEntity);
db.SaveChanges();
return(returnStatus.Id);
}
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult AddPermit(PermitObject permit)
{
var gVal = new GenericValidator();
try
{
var importerInfo = GetLoggedOnUserInfo();
if (importerInfo.Id < 1)
{
gVal.Error = "Your session has timed out";
gVal.Code = -1;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var validationResult = ValidatePermit(permit);
if (validationResult.Code == 1)
{
return(Json(validationResult, JsonRequestBehavior.AllowGet));
}
var appPermitStatus = new PermitServices().AddPermit(permit);
if (appPermitStatus < 1)
{
validationResult.Code = -1;
validationResult.Error = appPermitStatus == -2 ? "Permit upload failed. Please try again." : "The Permit Information already exists";
return(Json(validationResult, JsonRequestBehavior.AllowGet));
}
gVal.Code = appPermitStatus;
gVal.Error = "Permit was successfully added.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
gVal.Error = "Permit processing failed. Please try again later";
gVal.Code = -1;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
public long AddBulkPermit(PermitObject permit)
{
try
{
var permitEntity = ModelMapper.Map <PermitObject, Permit>(permit);
if (permitEntity == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
int permid;
var permits = db.Permits.OrderByDescending(l => l.PermitNo).Take(1);
if (permits.Any())
{
permid = permits.First().PermitNo + 1;
}
else
{
permid = 1;
}
var permNum = "";
var count = permid.ToString().Length;
if (count == 1)
{
permNum = "00000" + permid;
}
else if (count == 2)
{
permNum = "0000" + permid;
}
else if (count == 3)
{
permNum = "000" + permid;
}
else if (count == 4)
{
permNum = "00" + permid;
}
else if (count == 5)
{
permNum = "0" + permid;
}
else if (count >= 6)
{
permNum = permid.ToString();
}
var year = DateTime.Now.Year;
var perm = new Permit
{
IssueDate = DateTime.Now,
PermitNo = permid,
PermitValue = "DPR/PPIPS/RC" + year + "/" + permNum,
DateAdded = DateTime.Now
};
perm.PermitStatus = (int)PermitStatusEnum.Active;
db.Permits.Add(perm);
db.SaveChanges();
return(5);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult VerifyPermit(string permNo)
{
var perm = new PermitObject();
try
{
if (String.IsNullOrEmpty(permNo))
{
perm.IsNull = true;
return(Json(perm, JsonRequestBehavior.AllowGet));
}
using (var db = new ImportPermitEntities())
{
var dat = DateTime.Now;
var check = db.Permits.Where(c => c.PermitValue.Equals(permNo)).ToList();
if (check.Any())
{
var permdate = check[0].ExpiryDate;
var permId = check[0].Id;
var permApp = db.PermitApplications.Where(p => p.PermitId == permId).ToList();
if (permApp.Any())
{
var appId = permApp[0].ApplicationId;
var app = db.Applications.Where(a => a.Id == appId).ToList();
if (app.Any())
{
perm.CompanyName = app[0].Importer.Name;
var permit = db.Permits.Where(m => m.Id == permId).ToList();
if (permit.Any())
{
perm.IssueDateStr = permit[0].IssueDate.ToString();
perm.ExpiryDateStr = permit[0].ExpiryDate.ToString();
perm.QuantityStr = permit[0].QuantityImported.ToString();
if (dat > permdate)
{
perm.IsExpired = true;
return(Json(perm, JsonRequestBehavior.AllowGet));
}
perm.IsValid = true;
return(Json(perm, JsonRequestBehavior.AllowGet));
}
}
perm.NoEmployee = true;
}
perm.NoEmployee = true;
}
perm.NoEmployee = true;
return(Json(perm, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
perm.IsError = true;
return(Json(perm, JsonRequestBehavior.AllowGet));
}
}
