public bool UpdateRequestAuthorization(long RequestID, string Status, string Comments,bool StatusEligibility,bool FinancialEligibility)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Requests val = new DAL.tbl_Requests();
val = db.tbl_Requests.Where(a => a.ID == RequestID).FirstOrDefault();
val.AuthorizationStatus = Status;
val.AuthorizationComments = Comments;
val.StatusEligibility = StatusEligibility;
val.FinancialEligibility = FinancialEligibility;
val.AuthorizerID = int.Parse(Convert.ToString(HttpContext.Current.Session["UserId"]));
db.SaveChanges();
if (Status == "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", val.ID.ToString());
}
}
return true;
}
catch (Exception ex)
{
return false;
}
}
//public tbl_Requests GetRequestById(int RequestID)
//{
// try
// {
// tbl_Requests request= new DAL.tbl_Requests();
// using (var db = new SoneriCISEntities())
// {
// request = db.tbl_Requests.Where(a => a.ID==RequestID && a.AuthorizationStatus == "P").FirstOrDefault();
// }
// return request;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public tbl_Requests GetRequestById(int RequestID, string RequestType)
{
try
{
tbl_Requests request = new DAL.tbl_Requests();
using (var db = new SoneriCISEntities())
{
request = db.tbl_Requests.Where(a => a.AuthorizationStatus == "P" && a.IsActive == true && a.RequestType == RequestType && a.ID == RequestID).FirstOrDefault();
}
return request;
}
catch (Exception ex)
{
throw ex;
}
}
public tbl_Requests GetRequestForImport(string CIF,string AccountNo)
{
try
{
tbl_Requests request = new DAL.tbl_Requests();
using (var db = new SoneriCISEntities())
{
request = db.tbl_Requests.Where(a => a.AuthorizationStatus == "A" && a.IsActive == true && a.IsExported == true
&& (a.RequestType == "R" || a.RequestType == "N") && a.CIFNo == CIF && a.AccountNo == AccountNo).OrderByDescending(e => e.ID).FirstOrDefault();
}
return request;
}
catch (Exception ex)
{
throw ex;
}
}
public tbl_Requests GetRequestByCardNo(string CardNo,string AuthorizationStatus)
{
try
{
tbl_Requests request = new DAL.tbl_Requests();
using (var db = new SoneriCISEntities())
{
List<tbl_Requests> lst = db.tbl_Requests.Where(a => a.AuthorizationStatus == AuthorizationStatus && a.IsActive == true
&& a.CardNo==CardNo).ToList();
request = lst.Where(a => a.RequestType == "A" || a.RequestType == "R").FirstOrDefault();
}
return request;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateRequestAuthorization(long RequestID, string Status, string Comments,int AuthorizerID)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Requests val = new DAL.tbl_Requests();
val = db.tbl_Requests.Where(a => a.ID == RequestID).FirstOrDefault();
val.ID = val.ID;
val.RequestType = val.RequestType;
val.AccountNo = val.AccountNo;
val.CIFNo = val.CIFNo;
val.CardNo = val.CardNo;
val.WaiveCharges = val.WaiveCharges;
val.StatusEligibility = val.StatusEligibility;
val.FinancialEligibility = val.FinancialEligibility;
val.AuthorizationComments = Comments;
val.AuthorizationStatus = Status;
val.RequestDate = val.RequestDate;
val.CardTitle = val.CardTitle;
val.CardTypeID = val.CardTypeID;
val.Salutation = val.Salutation;
val.LinkingDelinkingAccount = val.LinkingDelinkingAccount;
val.IsActive = val.IsActive;
val.IsExported = val.IsExported;
val.AuthorizerID = AuthorizerID;
db.SaveChanges();
if (Status == "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", val.ID.ToString());
}
}
return true;
}
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;
}
}