private void MapDALObject() { CRDALObject = new CompteResult(); CRDALObject.Id = Id; CRDALObject.Name = Name; CRDALObject.CompanyIds = ParentCompanyIds; CRDALObject.CompanyNames = ParentCompanyNames; CRDALObject.AssurIds = AssurIds; CRDALObject.AssurNames = AssurNames; CRDALObject.SubsidIds = SubsidIds; CRDALObject.SubsidNames = SubsidNames; CRDALObject.ContractIds = ContractIds; CRDALObject.ContractNames = ContractNames; CRDALObject.ReportLevelId = ReportLevelId; CRDALObject.CollegeId = CollegeId; CRDALObject.UserName = UserName; CRDALObject.CreationDate = CreationDate; CRDALObject.IsActive = IsActive; CRDALObject.IsAutoGenerated = IsAutoGenerated; CRDALObject.ReportType = ReportType.ToString(); CRDALObject.TaxActif = TaxAct; CRDALObject.TaxDefault = TaxDef; CRDALObject.TaxPerif = TaxPer; }
public void UpdateDBRecord() { try { if (Id == 0) { throw new Exception("Id cannot be 0 - Source: BLCompteResultat::UpdateDBRecord"); } MapDALObject(); CompteResult.Update(CRDALObject); //Update Planning information //### update Planning only if there is only one single Planning available - otherwise we don't know which Planning shoul dbe updated //we also need to retrieve the Id of that Planning List <CRPlanning> oldPls = CRPlanning.GetCRPlannngForComptesResultat(Id); if (oldPls.Count == 1) { CRPlanning newPl = CRPlannings[0]; newPl.CRId = Id; newPl.Id = oldPls[0].Id; CRPlanning.Update(newPl); } } catch (Exception ex) { log.Error("UpdateDBRecord :: " + ex.Message); throw ex; } }
public static void DeleteCompteResultat(int CRId) { try { CompteResult.Delete(CRId); } catch (Exception ex) { log.Error(ex.Message); throw ex; } }
public void DeleteCompteResultat() { try { MapDALObject(); CompteResult.Delete(CRDALObject); } catch (Exception ex) { log.Error(ex.Message); throw ex; } }
public int CreateNewCompteResultat() { try { //verify if our CR is at the level of the assur or the level of a parent company //if more than 1 parent company was selected, the level is assur bool crIsAssurLevel = true; if (!ParentCompanyIds.Contains(C.cVALSEP)) { crIsAssurLevel = false; } List <string> parentCompanyList = Regex.Split(ParentCompanyIds, C.cVALSEP).ToList(); List <string> assurList = Regex.Split(AssurIds, C.cVALSEP).ToList(); if (crIsAssurLevel) { Id = CompteResult.GetIdForCRNameAndAssur(Name, assurList[0]); } else { Id = CompteResult.GetIdForCRNameAndParentComp(Name, parentCompanyList[0]); } if (Id != C.cINVALIDID) { CRExists = true; UpdateDBRecord(); } else { CRExists = false; Id = AddDBRecord(); } //Create Excel Docs foreach (CRPlanning crp in CRPlannings) { CreateExcelDoc(Id, crp); } return(Id); } catch (Exception ex) { log.Error("CreateNewCompteResultat :: " + ex.Message); throw ex; } }
public int AddDBRecord() { try { int crId = 0; MapDALObject(); crId = CompteResult.Insert(CRDALObject); //add the planning information foreach (CRPlanning crp in CRPlannings) { crp.CRId = crId; CRPlanning.Insert(crp); } return(crId); } catch (Exception ex) { log.Error("AddDBRecord :: " + ex.Message); throw ex; } }