public int checkUserCreds(string Email, string Password)
{
int checkedUser = 0;
Encrypt newCrypt = new Encrypt();
string encPassword = newCrypt.EncryptString(Password);
var db = new PetaPoco.Database("Olgarsconnection");
VSLog vsLogger = new VSLog();
vsLogger.WriteDebug("About to select");
try
{
checkedUser = db.ExecuteScalar <int>("SELECT Count(*) FROM [User] WHERE EmailAddress=@0 AND UserPassword=@1 AND SysStatus=0 and DeleteStatus=0", Email, encPassword);
}
catch (Exception ex)
{
string apiResponse = "";
string sqlError = "";
string exMessage = ex.Message.ToString();
sqlError = db.LastSQL;
vsLogger.WriteDebug("Logon Error");
vsLogger.WriteDebug(exMessage);
apiResponse = exMessage;
checkedUser = 0;
}
return(checkedUser);
}
public List <vw_CaseDefectsData> GetVictimsByCaseID(int CaseID, int SessionID)
{
var victims = (from _case in DataContext.Cases_Cases
join _session in DataContext.Cases_CaseSessions on _case.ID equals _session.CaseID
join _victim in DataContext.Cases_CaseVictims on _case.ID equals _victim.CaseID
join _personVictim in DataContext.Configurations_Persons on _victim.PersonID equals _personVictim.ID
join _victimsSessionLog in DataContext.Cases_VictimsSessionsLog on _victim.ID equals _victimsSessionLog.VictimID into VSLog
from _vslog in VSLog.DefaultIfEmpty()
join _PresenceStatus in DataContext.Configurations_Lookups on _vslog.PresenceStatusID equals _PresenceStatus.ID into PStatus
from _ps in PStatus.DefaultIfEmpty()
where _case.ID == CaseID && _session.ID == SessionID && _case.IsDeleted != true
select new vw_CaseDefectsData
{
ID = _victim.ID,
PersonID = _victim.PersonID,
Name = _personVictim.FullName,
NationalID = _personVictim.NationalID,
DefectType = PartyTypes.Victim,
IsCivilRightProsecutor = _victim.IsCivilRightProsecutor,
Presence = _vslog == null ? 0 :(PresenceStatus)_vslog.PresenceStatusID,
JobName = _personVictim.JobTitle,
NationalityType = _personVictim.NationalityID,
PassportNumber = _personVictim.PassportNumber,
Birthdate = _personVictim.Birthdate,
Order = _victim.Order,
Address = _personVictim.Address,
Nationality = _personVictim.Configurations_Lookups.Name,
}).ToList();
return(victims);
}
private void btnLogon_Click(object sender, EventArgs e)
{
Models.CurrentUser PresentUser = new Models.CurrentUser();
Controllers.UserOperations userOps = new Controllers.UserOperations();
if (string.IsNullOrWhiteSpace(txtUser.Text) == true | string.IsNullOrWhiteSpace(txtPwd.Text) == true)
{
lblError.Text = "Incorrect User Information";
}
else
{
//for Testing = 1
VSLog vsLogger = new VSLog();
vsLogger.WriteDebug("About to Logon");
vsLogger.WriteDebug(txtUser.Text);
int userstatus = 1;
//userstatus = userOps.checkUserCreds(txtUser.Text, txtPwd.Text);
if (userstatus > 0)
{
lblError.Text = "Correct User Information All Good";
this.Hide();
DigiScan frmScan = new DigiScan();
frmScan.ShowDialog();
this.Close();
}
else
{
lblError.Text = "Incorrect User Credentials";
}
}
}
private void DigiScan_Load(object sender, EventArgs e)
{
VSLog vsLogger = new VSLog();
vsLogger.WriteDebug("Loaded Scanning Page" + System.DateTime.Now.ToString());
this.AutoSize = true;
this.AutoSizeMode = AutoSizeMode.GrowOnly;
}
private void DigiSignLogon_Load(object sender, EventArgs e)
{
VSLog vsLogger = new VSLog();
vsLogger.WriteDebug("Starting VDI Logon" + System.DateTime.Now.ToString());
this.AutoSize = true;
this.AutoSizeMode = AutoSizeMode.GrowOnly;
}
private void disableButtons(string custIdNo)
{
VSLog vsLogger = new VSLog();
vsLogger.WriteDebug("Disabling Buttons for ID No" + custIdNo);
btnSearchPad.Visible = false;
btnStartScan.Visible = false;
btnStopScan.Visible = false;
btnSaveScan.Visible = false;
}
private void sendOtp(string fullName, string custIdNo)
{
VSLog vsLogger = new VSLog();
string response = "";
string otpNo = "";
otpNo = GenerateSignCode(custIdNo);
Controllers.SMSMessageOperations smsOps = new Controllers.SMSMessageOperations();
Models.SMSObj smsObj = new Models.SMSObj();
vsLogger.WriteDebug("Inside SMS Code ");
smsObj.messageText = "You about to sign a document please provide this ICARS Signing Security OTP " + otpNo + " to the Sales Team Member";
smsObj.toNumber = getMobileNumber(custIdNo); // "0834634921";
//smsObj.toNumber = "0799425095";
smsObj.olgarsUser = "******";
smsObj.toUser = fullName;
smsObj.olgarsEmail = fullName;
response = smsOps.sendManualSMSMessage(smsObj, "3", 2);
//Add the to the DB the OTP
Models.DigiSignature thisDigiSign = new Models.DigiSignature();
thisDigiSign.DateAdded = DateTime.Now;
thisDigiSign.AddedBy = fullName;
thisDigiSign.ResidentId = custIdNo;
thisDigiSign.ResidentInitial = "NotSetup";
thisDigiSign.ResidentSignature = "NotSetup";
thisDigiSign.SalesInitial = "NotSetup";
thisDigiSign.SalesSignature = "NotSetup";
thisDigiSign.WitnessInitial = "NotSetup";
thisDigiSign.WitnessName = "NotSetup";
thisDigiSign.WitnessSignature = "NotSetup";
thisDigiSign.OtpNo = otpNo;
thisDigiSign.ServerPath = GenerateFileName();
//Remove whatever Signature is there
//Always a unique combination
//Need to delete the files as well at some point
deleteCustId(custIdNo);
int thiSigId = addSig(thisDigiSign);
}
