public object SaveActionPendingCbsAccounts(BatchUpdateModel model)
{
try
{
var mtcbsinfos = ConvertBatchUpdateModelToMtCbsinfoModelForCheck(model);
foreach (MtCbsinfo mtcbsinfo in mtcbsinfos)
{
if (String.IsNullOrEmpty(mtcbsinfo.CheckBy))
{
return(HttpStatusCode.Unauthorized);
}
if (mtcbsinfo.CheckStatus != null && mtcbsinfo.CheckStatus != "P")
{
var cbsInfoPrev = _repository.GetMappedAccountByAccNo(mtcbsinfo.Accno);
_repository.ChekCbsAccuntByAccNo(mtcbsinfo);
var cbsInfoCurrent = _repository.GetMappedAccountByAccNo(mtcbsinfo.Accno);
auditTrailService.InsertUpdatedModelToAuditTrail(cbsInfoCurrent, cbsInfoPrev, mtcbsinfo.CheckBy, 8, 4, "Acc Mapping Check", mtcbsinfo.Mphone, "Successfully Checked");
}
}
return(HttpStatusCode.OK);
}
catch (Exception ex)
{
throw;
}
}
public object UpdatePermissions([FromBody] BatchUpdateModel model)
{
try
{
Permission permissionObj = new Permission();
foreach (var item in model.List)
{
permissionObj.IsAddPermitted = item.isAddPermitted == 0 ? "n" : "y";
permissionObj.IsDeletePermitted = item.isDeletePermitted == 0 ? "n" : "y";
permissionObj.IsEditPermitted = item.isEditPermitted == 0 ? "n" : "y";
permissionObj.IsRegistrationPermitted = item.isRegistrationPermitted == 0 ? "n" : "y";
permissionObj.IsSecuredviewPermitted = item.isSecuredviewPermitted == 0 ? "n" : "y";
permissionObj.IsViewPermitted = item.isViewPermitted == 0 ? "n" : "y";
permissionObj.FeatureId = item.featureId;
permissionObj.RoleId = item.roleId;
if (item.id != null && item.id != 0)
{
permissionObj.Id = item.id;
permissionService.Update(permissionObj);
}
else
{
permissionService.Add(permissionObj);
}
}
return(" Permissions of " + model.List.Count() + " features updated Successfully");
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public List <MtCbsinfo> ConvertBatchUpdateModelToMtCbsinfoModelForCheck(BatchUpdateModel model)
{
MtCbsinfo aMtCbsinfo = null;
StringBuilderService builder = new StringBuilderService();
List <MtCbsinfo> mtCbsinfos = new List <MtCbsinfo>();
var changeBy = model.Param;
foreach (var item in model.List)
{
aMtCbsinfo = new MtCbsinfo
{
Mphone = item.MOBNUM,
Custid = item.CUSTID,
Name = item.NAME,
Accno = item.ACCNO,
Branch = item.BRANCH,
Mobnum = item.MOBNUM,
Nationid = item.NATIONID,
Accstat = item.ACCSTAT,
CheckBy = changeBy,
CheckTime = DateTime.Now,
CheckStatus = item.CHECK_STATUS
};
aMtCbsinfo.MakeStatus = item.MAKE_STATUS == "Active" ? "A" : "I";
aMtCbsinfo.Status = item.STATUS == "Active" ? "A" : "I";
aMtCbsinfo.Frozen = item.FROZEN == "Yes" ? "Y" : "N";
aMtCbsinfo.Dorm = item.DORM == "Yes" ? "A" : "N";
mtCbsinfos.Add(aMtCbsinfo);
}
return(mtCbsinfos);
}
public MtCbsinfo ConvertBatchUpdateParameterToMtCbsinfoModel(BatchUpdateModel model)
{
MtCbsinfo aMtCbsinfo = null;
StringBuilderService builder = new StringBuilderService();
var changeBy = builder.ExtractText(Convert.ToString(model.Param), "changeby", "}");
aMtCbsinfo = new MtCbsinfo
{
Mphone = builder.ExtractText(Convert.ToString(model.Param), "mobnum", ","),
Custid = builder.ExtractText(Convert.ToString(model.Param), "custid", ","),
Name = builder.ExtractText(Convert.ToString(model.Param), "name", ","),
Accno = builder.ExtractText(Convert.ToString(model.Param), "accno", ","),
Branch = builder.ExtractText(Convert.ToString(model.Param), "branch", ","),
Class = builder.ExtractText(Convert.ToString(model.Param).ToLower(), "class", ","),
Frozen = builder.ExtractText(Convert.ToString(model.Param), "frozen", ","),
Dorm = builder.ExtractText(Convert.ToString(model.Param), "dorm", ","),
Mobnum = builder.ExtractText(Convert.ToString(model.Param), "mobnum", ","),
Nationid = builder.ExtractText(Convert.ToString(model.Param), "nationid", "}"),
Accstat = builder.ExtractText(Convert.ToString(model.Param), "accstat", ","),
MakeStatus = "A",
EntryBy = changeBy,
MakeBy = changeBy,
CheckStatus = "P"
};
return(aMtCbsinfo);
}
public object SaveMatchedCbsAccount([FromBody] BatchUpdateModel model)
{
try
{
return(_service.SaveMatchedCbsAccount(model));
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object SaveMatchedCbsAccount(BatchUpdateModel model)
{
var mtCbsinfoList = ConvertBatchUpdateModelToMtCbsinfoModel(model);
try
{
foreach (var MtCbsinfo in mtCbsinfoList)
{
_repository.Add(MtCbsinfo);
}
return(HttpStatusCode.OK);
}
catch (Exception e)
{
return(HttpStatusCode.InternalServerError);
}
}
public object SaveMapOrRemapCbsAccount([FromBody] BatchUpdateModel model)
{
try
{
var result = _service.SaveMapOrRemapCbsAccount(model);
if (result.ToString() == "Unauthorized")
{
return(StatusCode(StatusCodes.Status401Unauthorized));
}
else
{
return(result);
}
}
catch (Exception ex)
{
errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString());
return(HttpStatusCode.BadRequest);
}
}
public List <MtCbsinfo> ConvertBatchUpdateModelToMtCbsinfoModel(BatchUpdateModel model)
{
MtCbsinfo aMtCbsinfo = null;
StringBuilderService builder = new StringBuilderService();
List <MtCbsinfo> mtCbsinfos = new List <MtCbsinfo>();
var changeBy = builder.ExtractText(Convert.ToString(model.Param), "changeby", "}");
var ubranch = builder.ExtractText(Convert.ToString(model.Param), "ubranch", ",");
foreach (var item in model.List)
{
aMtCbsinfo = new MtCbsinfo
{
Mphone = item.mobnum,
Custid = item.custid,
Name = item.name,
Accno = item.accno,
Branch = item.branch,
Class = builder.ExtractText(Convert.ToString(item), "class", ","),
Frozen = item.frozen,
Dorm = item.dorm,
Mobnum = item.mobnum,
Nationid = item.nationid,
Accstat = item.accstat,
EntryBy = changeBy,
MakeBy = changeBy,
Ubranch = ubranch,
CheckStatus = "P"
};
if (item.status != null)
{
aMtCbsinfo.Status = item.status;
}
aMtCbsinfo.MakeStatus = item.make_status_dump == 1 ? "A" : "I";
mtCbsinfos.Add(aMtCbsinfo);
}
return(mtCbsinfos);
}
public object SaveMapOrRemapCbsAccount(BatchUpdateModel model)
{
StringBuilderService builder = new StringBuilderService();
var cbsInfosList = ConvertBatchUpdateModelToMtCbsinfoModel(model);
string inactiveCbsAccountNo = string.Empty;
int allowAccNo = 3;
int count = 0;
int countPending = 0;
int totalCount = 0;
bool allowMap = false;
count = _repository.CheckEligibilityMappingByMphone(cbsInfosList[0].Mphone);
foreach (var value in cbsInfosList)
{
if (value.MakeStatus == "A")
{
countPending++;
}
}
totalCount = count + countPending;
if (count <= 2 && totalCount <= 3)
{
allowMap = true;
}
if (totalCount > 3)
{
return("Please do not try to activate more than three account");
}
if (countPending > 3)
{
return("Please do not try to activate more than three account");
}
if (count > 3)
{
return("Three accont activated already");
}
foreach (var item in cbsInfosList)
{
bool isRegInfoExist = _repository.IsRegInfoExist(item.Mphone);
if (!isRegInfoExist)
{
return("Ok Account: " + item.Mphone + " is Not exist"); //reginfo not exist
}
if (String.IsNullOrEmpty(item.MakeBy))
{
return(HttpStatusCode.Unauthorized);
}
if (item.Status == null && item.MakeStatus == "A")
{
var IsAccNoIsMappedByMblNo = _repository.CheckAccNoIsMappedByMblNo(item.Mobnum, item.Accno);
if (Convert.ToInt32(IsAccNoIsMappedByMblNo) == 0)
{
_repository.Add(item);
auditTrailService.InsertModelToAuditTrail(item, item.MakeBy, 8, 3, "Customer Acc Mapping", item.Mphone, "Mapped Suucessful");
}
else
{
return(HttpStatusCode.BadRequest);
}
}
if ((item.Status != item.MakeStatus) && item.Status != null)
{
if (item.MakeStatus == "A")
{
if (allowMap)
{
var cbsInfoPrev = _repository.GetMappedAccountByAccNo(item.Accno);
_repository.ActiveCbsAccountByAccountNo(item.Accno, item.MakeBy, item.Ubranch);
var cbsInfoCurrent = _repository.GetMappedAccountByAccNo(item.Accno);
auditTrailService.InsertUpdatedModelToAuditTrail(cbsInfoCurrent, cbsInfoPrev, item.MakeBy, 8, 4, "Customer Acc Mapping", item.Mphone, "Successfully Map or Remapped");
}
else
{
break;
}
}
else
{
var cbsInfoPrev = _repository.GetMappedAccountByAccNo(item.Accno);
_repository.InactiveCbsAccountByAccountNo(item.Accno, item.MakeBy, item.Ubranch);
var cbsInfoCurrent = _repository.GetMappedAccountByAccNo(item.Accno);
auditTrailService.InsertUpdatedModelToAuditTrail(cbsInfoCurrent, cbsInfoPrev, item.MakeBy, 8, 4, "Customer Acc Mapping", item.Mphone, "Successfully Map or Remapped");
}
}
}
return(HttpStatusCode.OK);
}
