public ActionResult Enrollment(Guid? registrationId = null)
{
Enrollment model = new Enrollment();
if (null != registrationId)
{
//GET identity and pass in as the model
model = GetIdentity(registrationId.Value);
}
return View(model);
}
public ActionResult Enrollment(Enrollment model, Guid? registrationId = null, HttpPostedFileBase proof = null, HttpPostedFileBase photo = null)
{
//, HttpPostedFileBase identity_proof = null, HttpPostedFileBase photo = null)
if (ModelState.IsValid)
{
if (registrationId != null)
model.RegistrationId = registrationId.Value;
//TODO add logging with NLog
if (model.Biodata != null)
{
model.RegistrationId = MergeAccessIdentity(model);
if (model.RegistrationId != null)
{
RegisterM2Sys(model.Biodata, model.RegistrationId);
if (proof != null && proof.ContentLength > 0)
{
//UPLOAD proof
var ext = Path.GetExtension(proof.FileName);
var path = Path.Combine(Server.MapPath("~/proof/"), string.Format("{0}{1}", model.RegistrationId, ext));
proof.SaveAs(path);
model.Proof_File = string.Format("{0}{1}", model.RegistrationId, ext);
}
if (photo != null && proof.ContentLength > 0)
{
//UPLOAD photo
var ext = Path.GetExtension(photo.FileName);
var path = Path.Combine(Server.MapPath("~/photo/"), string.Format("{0}{1}", model.RegistrationId, ext));
photo.SaveAs(path);
model.Photo_File = string.Format("{0}{1}", model.RegistrationId, ext);
}
UpdatePhotoProof(model.RegistrationId, model.Photo_File, model.Proof_File);
}
else
{
ViewBag.CreateIdentityMessage = "Failed to create new access identity. Please check entries and try again.";
}
model = new Enrollment();
return View(model);
}
else
ViewBag.ErrorMessage = "Please scan finger before enrolling.";
}
return View(model);
}
private Guid MergeAccessIdentity(Enrollment model)
{
// var sqlConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
var sqlConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlService sql = new SqlService(sqlConnectionString);
//TODO add other fields
//TODO registration ID
sql.AddParameter("@pIdentityType", System.Data.SqlDbType.VarChar, model.IdentityType);
sql.AddParameter("@pShiftOperation", System.Data.SqlDbType.VarChar, model.Shift);
sql.AddParameter("@pBloodGroup", System.Data.SqlDbType.VarChar, model.BloodGroup);
sql.AddParameter("@pName", System.Data.SqlDbType.VarChar, model.Name);
sql.AddParameter("@pEmplNo", System.Data.SqlDbType.VarChar, model.EmployeeNo);
sql.AddParameter("@pMobileNo", System.Data.SqlDbType.VarChar, model.MobileNo);
sql.AddParameter("@pCompanyRef", System.Data.SqlDbType.VarChar, model.CompanyRefNo);
sql.AddParameter("@pCompanyName", System.Data.SqlDbType.VarChar, model.CompanyName);
sql.AddParameter("@pTransporterName", System.Data.SqlDbType.VarChar, model.TransporterName);
sql.AddParameter("@pTransporterMobileNo", System.Data.SqlDbType.VarChar, model.TransportMobileNo);
sql.AddParameter("@pContractorName", System.Data.SqlDbType.VarChar, model.ContractorName);
sql.AddParameter("@pContractorMobileNo", System.Data.SqlDbType.VarChar, model.ContractorMobileNo);
sql.AddParameter("@pResidentialPhone", System.Data.SqlDbType.VarChar, model.ResidentialNo);
sql.AddParameter("@pPermanentAddress", System.Data.SqlDbType.VarChar, model.PermanentAddress);
sql.AddParameter("@pResidentialAddress", System.Data.SqlDbType.VarChar, model.ResidentialAddress);
sql.AddParameter("@pLicenseExpiryDate", System.Data.SqlDbType.DateTime2, model.LicenseExpiryDate);
sql.AddParameter("@pTTName", System.Data.SqlDbType.VarChar, model.TTName);
sql.AddParameter("@pOfficerNumber", System.Data.SqlDbType.VarChar, model.OfficerStaffMobileNumber);
sql.AddParameter("@pPoliceVerified", System.Data.SqlDbType.Bit, model.PoliceVerification);
sql.AddParameter("@pPoliceVerDate", System.Data.SqlDbType.Bit, model.PoliceVerificationDate);
sql.AddParameter("@pESICNo", System.Data.SqlDbType.Bit, model.ESICNo);
sql.AddParameter("@pPONo", System.Data.SqlDbType.Bit, model.PurchaseOrderNo);
sql.AddParameter("@pPOStartDate", System.Data.SqlDbType.Bit, model.PODateStart);
sql.AddParameter("@pPOEndDate", System.Data.SqlDbType.Bit, model.PODateEnd);
sql.AddParameter("@pJobSkill", System.Data.SqlDbType.Bit, model.JobSkill);
sql.AddParameter("@pPFNo", System.Data.SqlDbType.Bit, model.PFNo);
sql.AddParameter("@pAadhaar", System.Data.SqlDbType.Bit, model.AadhaarNo);
sql.AddParameter("@pBankName", System.Data.SqlDbType.Bit, model.BankName);
sql.AddParameter("@pACNo", System.Data.SqlDbType.Bit, model.ACNo);
sql.AddParameter("@pIFSCCode", System.Data.SqlDbType.Bit, model.IFSCCode);
if (model.RegistrationId != null)
{
sql.AddParameter("@pRegistrationId", System.Data.SqlDbType.UniqueIdentifier, model.RegistrationId);
}
//sql.AddParameter("@pPhoto", System.Data.SqlDbType.VarChar, model.Photo);
//sql.AddParameter("@pAddressProof", System.Data.SqlDbType.VarChar, model.Proof);
using (SqlDataReader reader = sql.ExecuteSPReader("MMD_spCreateAccessIdentity"))
{
if (reader.HasRows)
{
reader.Read();
return reader.GetGuid(0);
}
else
return Guid.Empty;
}
}
private Enrollment GetIdentity(Guid registrationId)
{
var sqlConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
Enrollment id = new Enrollment();
SqlService sql = new SqlService(sqlConnectionString);
sql.AddParameter("pRegistrationId", System.Data.SqlDbType.UniqueIdentifier, registrationId);
using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetBioIdentity"))
{
if (reader.HasRows)
{
reader.Read();
id.RegistrationId = registrationId;
id.BloodGroup = reader.GetString(reader.GetOrdinal("BloodGroup"));
id.Name = reader.GetString(reader.GetOrdinal("Name")); //reader.GetString(1);
id.MobileNo = reader.GetString(reader.GetOrdinal("MobileNo"));
id.IdentityType = reader.GetString(reader.GetOrdinal("IdentityType"));
id.Shift = reader.GetString(reader.GetOrdinal("ShiftOperation"));
id.CompanyName = reader.GetString(reader.GetOrdinal("CompanyName"));
id.CompanyRefNo = reader.GetString(reader.GetOrdinal("CompanyRefNo"));
id.TransporterName = reader.GetString(reader.GetOrdinal("TransporterName"));
id.TransportMobileNo = reader.GetString(reader.GetOrdinal("TransporterMobileNo"));
id.ContractorName = reader.GetString(reader.GetOrdinal("ContractorName"));
id.ContractorMobileNo = reader.GetString(reader.GetOrdinal("ContractorMobileNo"));
id.ResidentialNo = reader.GetString(reader.GetOrdinal("ResidentialNo"));
id.PermanentAddress = reader.GetString(reader.GetOrdinal("PermanentAddress"));
id.ResidentialAddress = reader.GetString(reader.GetOrdinal("ResidentialAddress"));
id.LicenseExpiryDate = reader.GetDateTime(reader.GetOrdinal("LicenseExpiryDate"));
id.TTName = reader.GetString(reader.GetOrdinal("TTName"));
id.OfficerStaffMobileNumber = reader.GetString(reader.GetOrdinal("OfficerStaffMobileNo"));
//TODO photo and addreess proff
id.Photo_File = reader.GetString(reader.GetOrdinal("Photo"));
id.Proof_File = reader.GetString(reader.GetOrdinal("AddressProof"));
id.PoliceVerification = reader.GetBoolean(reader.GetOrdinal("PoliceVerified"));
id.PoliceVerificationDate = reader.GetDateTime(reader.GetOrdinal("PoliceVerificationDate"));
id.ESICNo = reader.GetString(reader.GetOrdinal("ESICNo"));
id.PurchaseOrderNo = reader.GetString(reader.GetOrdinal("PONo"));
DateTime tempDate;
if (DateTime.TryParse(reader.GetString(reader.GetOrdinal("POStartDate")), out tempDate))
{
id.PODateStart = tempDate;
}
if (DateTime.TryParse(reader.GetString(reader.GetOrdinal("POStartDate")), out tempDate))
{
id.PODateEnd = tempDate;
}
id.JobSkill = reader.GetString(reader.GetOrdinal("JobSkill"));
id.PFNo = reader.GetString(reader.GetOrdinal("PFNo"));
id.AadhaarNo = reader.GetString(reader.GetOrdinal("AadhaarNo"));
id.BankName = reader.GetString(reader.GetOrdinal("BankName"));
id.ACNo = reader.GetString(reader.GetOrdinal("ACNo"));
id.IFSCCode = reader.GetString(reader.GetOrdinal("IFSCCode"));
//id.LastInTime = reader.GetDateTime(14);
//id.LastOutTime = reader.GetDateTime(15);
}
}
return id;
}
