public static FormsRepository GetFormsRepository(IUnitOfWork unitOfWork)
{
var repository = new FormsRepository();
repository.UnitOfWork = unitOfWork;
return(repository);
}
public void GetDOFAData(int _dataCaptYM, string empDept = "")
{
EmpDept = empDept;
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (_dataCaptYM > 0 ? _dataCaptYM : 0);
this.DofaData = formsRepository.GetDOFAFormDataByID(DataCaptYM, SessionManager.DeptID, empDept);
if (DofaData == null || DofaData.Count == 0)
{
DofaData = new List <DofaInfo>();
DofaData.Add(new DofaInfo());
DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
}
else
{
DataStatus = DofaData.First().DataStatus;
DataStatusName = DofaData.First().DataStatusName;
}
if (!string.IsNullOrWhiteSpace(EmpDept))
{
DofaData.ForEach(f => f.empDEPT = EmpDept);
}
}
public void GetInfraData(int _dataCaptYM)
{
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (_dataCaptYM > 0 ? _dataCaptYM : 0);
var data = formsRepository.GetInfraFormDataByID(DataCaptYM, SessionManager.DeptID);
InfraDeptData = data.Item1;
InfraInfoData = data.Item2;
if (SessionManager.DeptID == "EW")
{
IsInfraInfoVisible = true;
}
if (InfraDeptData == null || InfraInfoData == null || InfraDeptData.Count == 0 || InfraInfoData.Count == 0)
{
throw new Exception("Invalid Data");
}
else
{
DataStatus = InfraDeptData.First().DataStatus;
DataStatusName = InfraDeptData.First().DataStatusName;
if (DataStatus == 0)
{
DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
}
}
}
public static FormsRepository GetFormsRepository()
{
var repository = new FormsRepository();
repository.UnitOfWork = GetUnitOfWork();
return(repository);
}
public bool SaveDFNPData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (finInfo == null)
{
return(success);
}
finInfo.MenuID = DataAccess.Enum.Menu.DFNP.ToString();
finInfo.DeptID = string.IsNullOrEmpty(finInfo.EmpDept) ? SessionManager.DeptID : finInfo.EmpDept;
finInfo.DeptName = SessionManager.DeptID;
finInfo.DataUser = SessionManager.UserName;
finInfo.DataUpdatedOn = DateTime.Now;
finInfo.DataCaptYM = SessionManager.DataCaptYR;
finInfo.DataStatus = FormCommonMethods.GetStatusByAction(action);
finInfo.DataValid = "Y";
finInfo.DataLocked = "N";
finInfo.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(new List <FinInfo> {
finInfo
});
success = formsRepository.UpdateBulkDFNPData(dt, SessionManager.DataCaptYR);
}
catch (Exception ex)
{
}
return(success);
}
public bool SaveDOAA1Form(FormsViewModel dOAA1ViewModel)
{
FormsRepository formsRepository = new FormsRepository();
int isSave = formsRepository.Insert(dOAA1ViewModel.info);
GetDOAA1Data(dOAA1ViewModel.info.DataCaptYM, dOAA1ViewModel.info.MenuID);
return(isSave > 0);
}
public bool UdpateLIBForm(FormsViewModel formsViewModel)
{
FormsRepository formsRepository = new FormsRepository();
bool isUpdate = formsRepository.UpdateToLibInfo(formsViewModel.libInfo);
GetDOAA1Data(formsViewModel.libInfo.DataCaptYM, formsViewModel.libInfo.MenuID);
return(isUpdate);
}
public bool SaveLIBForm(FormsViewModel formsViewModel)
{
FormsRepository formsRepository = new FormsRepository();
bool isSave = formsRepository.InsertToLibInfo(formsViewModel.libInfo);
GetDOAA1Data(formsViewModel.libInfo.DataCaptYM, formsViewModel.libInfo.MenuID);
return(isSave);
}
public bool UdpateADIRAndDOSWForm(FormsViewModel formsViewModel)
{
FormsRepository formsRepository = new FormsRepository();
bool isUpdate = formsRepository.UpdateTostInfo2(formsViewModel.info2);
GetDOAA1Data(formsViewModel.info2.DataCaptYM, formsViewModel.info2.MenuID);
return(isUpdate);
}
public bool SaveADIRAndDOSWForm(FormsViewModel formsViewModel)
{
FormsRepository formsRepository = new FormsRepository();
bool isSave = formsRepository.InsertTostInfo2(formsViewModel.info2);
GetDOAA1Data(formsViewModel.info2.DataCaptYM, formsViewModel.info2.MenuID);
return(isSave);
}
public bool UdpateDOAA1Form(FormsViewModel dOAA1ViewModel)
{
FormsRepository formsRepository = new FormsRepository();
bool isUpdate = formsRepository.Update(dOAA1ViewModel.info);
GetDOAA1Data(dOAA1ViewModel.info.DataCaptYM, dOAA1ViewModel.info.MenuID);
return(isUpdate);
}
public void BindDDLs(LegalEntityView legalEntityView, ObjectContext db)
{
//forms ddl
IFormsRepository formsRepository = new FormsRepository(db);
legalEntityView.Forms = new SelectList(formsRepository.GetValid().OrderBy("Name ASC").ToList(), "FormPK", "Name");
//activities ddl
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
var activities = activitiesRepository.GetValid().OrderBy("Name ASC").ToList();
//regional offices ddl
IRegionalOfficesRepository regionalOfficesRepository = new RegionalOfficesRepository(db);
legalEntityView.RegionalOffices = new SelectList(regionalOfficesRepository.GetValid().OrderBy("Name ASC").ToList(), "RegionalOfficePK", "Name");
}
public bool SaveSricFAData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (SricFAData == null || SricFAData.Count == 0)
{
return(success);
}
if (SricFAData.Any(n => string.IsNullOrWhiteSpace(n.FAName)))
{
msg = "At least Agency Name / Sponsor Name Required.";
return(success);
}
if (SricFAData.GroupBy(n => n.FAName.Trim().ToLower()).Any(c => c.Count() > 1))
{
msg = "Duplicate Organization / Agency Name Exist.! Data saving aborted.";
return(success);
}
foreach (var item in SricFAData)
{
item.FAName = item.FAName.Trim();
item.MenuID = DataAccess.Enum.Menu.SRICFA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(SricFAData);
success = formsRepository.UpdateBulkSricFAFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID);
}
catch (Exception ex)
{
}
return(success);
}
public bool SaveDOFAData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (DofaData == null || DofaData.Count == 0)
{
return(success);
}
if (DofaData.Any(n => n.empNo <= 0 || string.IsNullOrWhiteSpace(n.empName) || string.IsNullOrWhiteSpace(n.empDEPT)))
{
msg = "Minimum EmpNo, Name, Dept should not be blank";
return(success);
}
if (DofaData.GroupBy(n => n.empNo).Any(c => c.Count() > 1))
{
msg = "Duplicate EmpNo Exist.! Data saving aborted.";
return(success);
}
foreach (var item in DofaData)
{
item.MenuID = DataAccess.Enum.Menu.DOFA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(DofaData);
success = formsRepository.UpdateBulkDOFAFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID, EmpDept);
}
catch (Exception ex)
{
}
return(success);
}
public void GetDOAA1Data(int DataCaptYM, string MenuID)
{
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (DataCaptYM > 0 ? DataCaptYM : 0);
if (MenuID == DataAccess.Enum.Menu.DOAA.ToString())
{
this.info = formsRepository.GetDOAA1FormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (info == null)
{
info = new stInfo();
info.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
info.DataStatusName = "Data Entry Started by Operator";
info.DataCaptYM = DataCaptYM;
info.DeptName = info.DeptID = SessionManager.DeptID;
}
}
else if (MenuID == DataAccess.Enum.Menu.ADIR.ToString() || MenuID == DataAccess.Enum.Menu.DOSW.ToString())
{
this.info2 = formsRepository.GetADIRFormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (info2 == null)
{
info2 = new stInfo2();
info2.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
info2.DataStatusName = "Data Entry Started by Operator";
info2.DataCaptYM = DataCaptYM;
info2.DeptName = info2.DeptID = SessionManager.DeptID;
}
}
else if (MenuID == DataAccess.Enum.Menu.LIBFORM.ToString())
{
this.libInfo = formsRepository.GetLibFormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (libInfo == null)
{
libInfo = new LibInfo();
libInfo.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
libInfo.DataStatusName = "Data Entry Started by Operator";
libInfo.DataCaptYM = DataCaptYM;
libInfo.DeptName = libInfo.DeptID = SessionManager.DeptID;
}
}
RankMesg rankmesg = FormCommonMethods.GetCurrentRankMesg();
this.rankmsg = rankmesg.Message;
}
public void GetMultiDataByMenuID(int dataCaptYM, string MenuID, string empDept = "")
{
FormsRepository formsRepository = new FormsRepository();
dataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (dataCaptYM > 0 ? dataCaptYM : 0);
if (MenuID == DataAccess.Enum.Menu.DOFA.ToString())
{
dofaViewModel = new DofaViewModel();
dofaViewModel.GetDOFAData(dataCaptYM, empDept);
}
else if (MenuID == DataAccess.Enum.Menu.SRICFA.ToString())
{
sricFAViewModel = new SricFAViewModel();
sricFAViewModel.GetSRICFAData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.SRIC.ToString())
{
sricDeptViewModel = new SricDeptViewModel();
sricDeptViewModel.GetSRICData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.DOFAPEER.ToString())
{
dofaPeerViewModel = new DofaPeerViewModel();
dofaPeerViewModel.GetDofaPeerData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.TPDEPT.ToString())
{
tpDeptViewModel = new TPDeptViewModel();
tpDeptViewModel.GetTPDeptData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.INFRA.ToString())
{
infraViewModel = new InfraViewModel();
infraViewModel.GetInfraData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.DFNP.ToString())
{
dfnpViewModel = new DFNPViewModel();
dfnpViewModel.GetDFNPData(dataCaptYM);
dfnpViewModel.finInfo.EmpDept = SessionManager.EmpDeptID;
}
RankMesg rankmesg = FormCommonMethods.GetCurrentRankMesg();
this.rankmsg = rankmesg.Message;
}
public void GetDFNPData(int _dataCaptYM)
{
FormsRepository formsRepository = new FormsRepository();
var DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (_dataCaptYM > 0 ? _dataCaptYM : 0);
string deptID = string.IsNullOrEmpty(SessionManager.EmpDeptID) ? SessionManager.DeptID : SessionManager.EmpDeptID;
finInfo = formsRepository.GetDFNPDataByID(DataCaptYM, deptID);
if (finInfo == null)
{
finInfo = new FinInfo();
}
if (finInfo.DataStatus == 0)
{
finInfo.DataCaptYM = DataCaptYM;
finInfo.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
finInfo.DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
}
}
public void GetSRICFAData(int _dataCaptYM)
{
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (_dataCaptYM > 0 ? _dataCaptYM : 0);
SricFAData = formsRepository.GetSricFAFormDataByID(DataCaptYM, SessionManager.DeptID);
if (SricFAData == null || SricFAData.Count == 0)
{
SricFAData = new List <SricFA>();
SricFAData.Add(new SricFA());
DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
}
else
{
DataStatus = SricFAData.First().DataStatus;
DataStatusName = SricFAData.First().DataStatusName;
}
}
public void GetSRICData(int _dataCaptYM)
{
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (_dataCaptYM > 0 ? _dataCaptYM : 0);
SricDeptData = formsRepository.GetSricDeptFormDataByID(DataCaptYM);
if (SricDeptData == null || SricDeptData.Count == 0)
{
throw new Exception("Invalid Data");
}
else
{
DataStatus = SricDeptData.First().DataStatus;
DataStatusName = SricDeptData.First().DataStatusName;
if (DataStatus == 0)
{
DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
}
}
}
public ActionResult LegalEntities(string Name, string OIB, string MB, string MBS, int?BankPK, int?TaxPK, int?FormPK, int?ActivityPK, int?SubstationPK, int?CommercialCourtPK, int?NumberOfEmployeesFrom, int?NumberOfEmployeesTo, int?FundamentalCapitalFrom, int?FundamentalCapitalTo, string TouristOffice, string MonumentAnnuity)
{
string sortOrder = !string.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !string.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "LegalEntityPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IBanksRepository banksRepository = new BanksRepository(db);
ITaxesRepository taxesRepository = new TaxesRepository(db);
IFormsRepository formsRepository = new FormsRepository(db);
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
ISubstationsRepository substationsRepository = new SubstationsRepository(db);
ICommercialCourtsRepository commercialCourtsRepository = new CommercialCourtsRepository(db);
// Binding DDL for report search
ViewBag.Banks = new SelectList(banksRepository.GetValid().OrderBy("Name ASC").ToList(), "BankPK", "Name", BankPK);
ViewBag.Taxes = new SelectList(taxesRepository.GetValid().OrderBy("Name ASC").ToList(), "TaxPK", "Name", TaxPK);
ViewBag.Forms = new SelectList(formsRepository.GetValid().OrderBy("Name ASC").ToList(), "FormPK", "Name", FormPK);
ViewBag.Activities = new SelectList(activitiesRepository.GetValid().OrderBy("Name ASC").ToList(), "ActivityPK", "Name", ActivityPK);
ViewBag.Substations = new SelectList(substationsRepository.GetValid().OrderBy("Name ASC").ToList(), "SubstationPK", "Name", SubstationPK);
ViewBag.CommercialCourts = new SelectList(commercialCourtsRepository.GetValid().OrderBy("Name ASC").ToList(), "CommercialCourtPK", "Name", CommercialCourtPK);
if (BankPK != null)
{
ViewBag.Bank = banksRepository.GetBankByPK((int)BankPK).Name;
}
if (TaxPK != null)
{
ViewBag.Tax = taxesRepository.GetTaxByPK((int)TaxPK).Name;
}
if (SubstationPK != null)
{
ViewBag.Substation = substationsRepository.GetSubstationByPK((int)SubstationPK).Name;
}
if (CommercialCourtPK != null)
{
ViewBag.CommercialCourt = commercialCourtsRepository.GetCommercialCourtByPK((int)CommercialCourtPK).Name;
}
if (FormPK != null)
{
ViewBag.Form = formsRepository.GetFormByPK((int)FormPK).Name;
}
if (ActivityPK != null)
{
ViewBag.Activity = activitiesRepository.GetActivityByPK((int)ActivityPK).Name;
}
bool?TouristOfficeFlag = null;
bool?MonumentAnnuityFlag = null;
if (TouristOffice == "on")
{
TouristOfficeFlag = true;
}
if (MonumentAnnuity == "on")
{
MonumentAnnuityFlag = true;
}
// Applying filters
IQueryable <LegalEntityView> legalEntities = LegalEntityView.GetLegalEntitiesReport(db, Name, OIB, MB, MBS, BankPK, TaxPK, FormPK, ActivityPK, SubstationPK, CommercialCourtPK, NumberOfEmployeesFrom, NumberOfEmployeesTo, FundamentalCapitalFrom, FundamentalCapitalTo, TouristOfficeFlag, MonumentAnnuityFlag)
.OrderBy(ordering);
// Excluding temporary deleted items from view
legalEntitiesPKsToExclude = new List <int>();
// Empty session on first request
if (Request.QueryString.Count == 0)
{
Session["legalEntitiesPKsToExclude"] = null;
}
if (Session["legalEntitiesPKsToExclude"] != null)
{
legalEntitiesPKsToExclude = (List <int>)Session["legalEntitiesPKsToExclude"];
legalEntities = legalEntities.Where(c => !legalEntitiesPKsToExclude.Contains(c.LegalEntityPK));
}
return(View("LegalEntities", legalEntities.ToList()));
}
public bool SaveInfraData(string action, out string msg)
{
msg = string.Empty;
bool success = false, IsInfraInfoVisible = false;
if (InfraDeptData == null || InfraDeptData.Count == 0)
{
return(success);
}
foreach (var item in InfraDeptData)
{
item.MenuID = DataAccess.Enum.Menu.INFRA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
if (SessionManager.DeptID == "EW")
{
IsInfraInfoVisible = true;
foreach (var item in InfraInfoData)
{
item.MenuID = DataAccess.Enum.Menu.INFRA.ToString();
item.DataUser = SessionManager.UserName;
item.DeptID = SessionManager.DeptID;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
item.InfraRemarks = SessionManager.UserName + " on " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
}
else
{
IsInfraInfoVisible = false;
InfraInfoData = new List <InfraInfo>();
InfraInfo item = new InfraInfo();
item.DeptID = SessionManager.DeptID;
item.MenuID = DataAccess.Enum.Menu.INFRA.ToString();
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
InfraInfoData.Add(item);
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dtInfraInfo = null;
DataTable dtInfraDept = ToDataTable(InfraDeptData);
dtInfraInfo = ToDataTable(InfraInfoData);
success = formsRepository.UpdateBulkInfraFormData(dtInfraDept, dtInfraInfo, SessionManager.DataCaptYR, IsInfraInfoVisible);
}
catch (Exception ex)
{
}
return(success);
}
