public static long?AddReplacementRequest(RequestVM model)
{
long?Result = 0;
model.RequestDate = DateTime.Now;
try
{
using (var db = new SoneriCISEntities())
{
tbl_Requests request = new tbl_Requests();
request.RequestType = model.RequestType;
request.AccountNo = model.AccountNo;
request.CIFNo = model.CustomerId;
request.WaiveCharges = model.Waive;
request.StatusEligibility = model.StatusEligibility;
request.FinancialEligibility = model.FinancialEligibility;
request.AuthorizationStatus = model.AuthorizationStatus;
request.RequestDate = model.RequestDate;
request.CardTitle = model.CardTitle;
request.CardTypeID = model.CardTypeId;
request.Salutation = model.Salutation;
request.IsActive = true;
request.IsExported = false;
request.CreatorID = StateHelper.UserId;
db.tbl_Requests.Add(request);
db.SaveChanges();
model.ID = request.ID;
}
Result = model.ID;
}
catch (Exception ex)
{
}
return(Result);
}
public static bool AuthorizeRequest(string CardNo, long RequestId, string AuthorizationStatus)
{
bool success = false;
var db = new SoneriCISEntities();
try
{
tbl_Requests request = db.tbl_Requests.Single(x => x.CardNo == CardNo && x.ID == RequestId);
request.AuthorizationStatus = AuthorizationStatus;
if (AuthorizationStatus == "A")
{
/* Add new row in user log, as because we can't get the authorizer's record of the request, as because the authorizer has functionality to export the file, when file export occurs, the authorizer changes as we get record of the user who update the request in last */
new UserLogDataAccess().AddUserLog(null, "tbl_Requests", "A", RequestId.ToString());
request.AuthorizerID = StateHelper.UserId;
}
db.SaveChanges();
success = true;
}
catch (Exception ex)
{
success = false;
}
return(success);
}
public static bool GenerateHotMarkRequest(string CardNo)
{
bool success = false;
string AddressValue = ""; string MobileValue = "";
string LandlineValue = ""; string OfficePhoneValue = "";
try
{
List <CustomerCardVM> lst = new List <CustomerCardVM>();
lst = CommonMethods.GetCardInfo(CardNo);
if (lst.Count > 0)
{
using (var db = new SoneriCISEntities())
{
tbl_Requests request = new tbl_Requests();
request.RequestType = "H";
request.AccountNo = lst.FirstOrDefault().AccountNo;
request.CardNo = CardNo;
request.AuthorizationStatus = "P";
request.RequestDate = DateTime.Now;
request.CardTitle = lst.FirstOrDefault().CardTitle;
request.CardTypeID = lst.FirstOrDefault().CardTypeID;
request.Salutation = lst.FirstOrDefault().Salutation;
request.IsActive = true;
request.CIFNo = lst.FirstOrDefault().CIFNo;
request.CreatorID = StateHelper.UserId;
db.tbl_Requests.Add(request);
db.SaveChanges();
RequestVM rm = new RequestVM();
rm.AccountNo = request.AccountNo;
rm.CardNo = request.CardNo;
rm.ID = request.ID;
rm.RequestType = request.RequestType;
// rm.AuthorizationStatus = request.AuthorizationStatus;
rm.CardTitle = request.CardTitle;
rm.CIFNo = request.CIFNo;
rm.Salutation = request.Salutation;
RequestMethods.AddRequestCustomerAccount(rm, AddressValue, MobileValue, LandlineValue, OfficePhoneValue);
}
success = true;
}
else
{
success = false;
}
}
catch (Exception ex)
{
success = false;
}
return(success);
}
public static bool GenerateHotMarkRequest(string CardNo, DateTime Expiry)
{
bool success = false;
try
{
List <CustomerCardVM> lst = new List <CustomerCardVM>();
lst = CommonMethods.GetCardInfo(CardNo, Expiry);
if (lst.Count > 0)
{
using (var db = new SoneriCISEntities())
{
tbl_Requests request = new tbl_Requests();
request.RequestType = "H";
request.AccountNo = lst.FirstOrDefault().AccountNo;
request.CardNo = CardNo;
request.AuthorizationStatus = "P";
request.RequestDate = DateTime.Now;
request.CardTitle = lst.FirstOrDefault().CardTitle;
request.CardTypeID = lst.FirstOrDefault().CardTypeID;
request.Salutation = lst.FirstOrDefault().Salutation;
request.IsActive = true;
request.CIFNo = lst.FirstOrDefault().CIFNo;
request.IsExported = false;
request.CreatorID = StateHelper.UserId;
db.tbl_Requests.Add(request);
db.SaveChanges();
var resp = db.tbl_User_Log.Where(e => e.EntityID == request.ID).FirstOrDefault();
if (resp != null)
{
resp.Descp = "A";
db.SaveChanges();
}
}
success = true;
}
else
{
success = false;
}
}
catch (Exception ex)
{
success = false;
}
return(success);
}
public tbl_Requests GetRequestToBeReviewed(int RequestID, string RequestType)
{
try
{
tbl_Requests request = new tbl_Requests();
using (var db = new SoneriCISEntities())
{
request = db.tbl_Requests.Where(a => a.AuthorizationStatus == "R" && a.IsActive == true
&& a.RequestType == RequestType && a.ID == RequestID).FirstOrDefault();
}
return request;
}
catch (Exception ex)
{
throw ex;
}
}
public long AddRequest2(tbl_Requests row)
{
try
{
using (var db = new SoneriCISEntities())
{
db.tbl_Requests.Add(row);
db.SaveChanges();
return row.ID;
}
}
catch (Exception ex)
{
return 0;
}
}
public bool AddRequest(tbl_Requests row)
{
row.RequestDate = DateTime.Now;
try
{
using (var db = new SoneriCISEntities())
{
db.tbl_Requests.Add(row);
db.SaveChanges();
}
return true;
}
catch (Exception ex)
{
return false;
}
}
public static bool GenerateActivationRequest(string CardNo)
{
bool success = false;
try
{
List <CustomerCardVM> lst = new List <CustomerCardVM>();
lst = CommonMethods.GetCardInfo(CardNo);
if (lst.Count > 0)
{
using (var db = new SoneriCISEntities())
{
tbl_Requests request = new tbl_Requests();
request.RequestType = "W";
request.AccountNo = lst.FirstOrDefault().AccountNo;
request.CardNo = CardNo;
request.AuthorizationStatus = "P";
request.RequestDate = DateTime.Now;
request.CardTitle = lst.FirstOrDefault().CardTitle;
request.CardTypeID = lst.FirstOrDefault().CardTypeID;
request.Salutation = lst.FirstOrDefault().Salutation;
request.IsActive = true;
request.CreatorID = StateHelper.UserId;
request.CIFNo = lst.FirstOrDefault().CIFNo;
db.tbl_Requests.Add(request);
db.SaveChanges();
}
success = true;
}
else
{
success = false;
}
}
catch (Exception ex)
{
success = false;
}
return(success);
}
//Check if Creator and Authorizer are same
public bool CheckSameAuthorizer(int AuthorizerID,int RequestID)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Requests r = db.tbl_Requests.Where(a => a.ID == RequestID && a.CreatorID == AuthorizerID).FirstOrDefault();
if (r != null)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
return false;
}
}
public bool UpdateRequest(tbl_Requests row , out long id)
{
row.RequestDate = DateTime.Now;
try
{
using (var db = new SoneriCISEntities())
{
tbl_Requests val = new DAL.tbl_Requests();
val = db.tbl_Requests.Where(a => a.ID == row.ID).FirstOrDefault();
val.RequestType = row.RequestType;
//val.AccountNo = row.AccountNo;
//val.CIFNo = row.CIFNo;
//val.CardNo = row.CardNo;
val.WaiveCharges = row.WaiveCharges;
val.StatusEligibility = row.StatusEligibility;
val.FinancialEligibility = row.FinancialEligibility;
val.AuthorizationComments = row.AuthorizationComments;
val.AuthorizationStatus = row.AuthorizationStatus;
val.RequestDate = row.RequestDate;
val.CardTitle = row.CardTitle;
val.CardTypeID = row.CardTypeID;
val.Salutation = row.Salutation;
val.LinkingDelinkingAccount = row.LinkingDelinkingAccount;
val.IsActive = row.IsActive;
val.IsExported = row.IsExported;
db.SaveChanges();
id = val.ID;
}
return true;
}
catch (Exception ex)
{
id = 0;
return false;
}
}
