public SOWCreateHandler(GlobalSolusindoDb db, tblM_User user, SOWValidator sowValidator, SOWFactory sowFactory, SOWAssignFactory sowAssignFactory, SOWTrackFactory sowTrackFactory, SOWQuery sowQuery, AccessControl accessControl) : base(db, user) { this.sowValidator = sowValidator; this.sowFactory = sowFactory; this.sowQuery = sowQuery; this.sowAssignFactory = sowAssignFactory; this.sowTrackFactory = sowTrackFactory; this.sowEntryDataProvider = new SOWEntryDataProvider(db, user, accessControl, sowQuery); }
public IHttpActionResult Get(int id) { ThrowIfUserHasNoRole(readRole); using (SOWQuery sowQuery = new SOWQuery(Db)) { var data = sowQuery.GetByPrimaryKey(id); SaveLog("SOW", "Get", JsonConvert.SerializeObject(new { primaryKey = id })); return(Ok(new SuccessResponse(data))); } }
public SOWImportExcelHandler(GlobalSolusindoDb db, tblM_User user, SOWValidator SOWValidator, SOWFactory SOWFactory, SOWAssignFactory sOWAssignFactory, SOWQuery SOWQuery, AccessControl accessControl) : base(db, user) { this.SOWValidator = SOWValidator; this.SOWFactory = SOWFactory; this.SOWQuery = SOWQuery; this.SOWAssignFactory = sOWAssignFactory; this.SOWEntryDataProvider = new SOWEntryDataProvider(db, user, accessControl, SOWQuery); //((IObjectContextAdapter)Db).ObjectContext.CommandTimeout = 300; //set time out //db.Database.CommandTimeout = 300; }
public IHttpActionResult Search([FromUri] SOWSearchFilter filter) { ThrowIfUserHasNoRole(readRole); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var sowQuery = new SOWQuery(Db)) { var data = sowQuery.Search(filter); return(Ok(new SuccessResponse(data))); } }
public TaskEngineerDetailDTO Get(int sowAssignPK) { TaskEngineerDetailDTO model = new TaskEngineerDetailDTO(); model.SOWAssign = new SOWAssignQuery(Db).GetByPrimaryKey(sowAssignPK); if (model.SOWAssign != null) { model.User = new UserQuery(Db).GetByPrimaryKey(model.SOWAssign.User_FK); var sow = new SOWQuery(Db).GetByPrimaryKey(model.SOWAssign.SOW_FK); if (sow != null) { model.BTS = new BTSQuery(Db).GetByPrimaryKey(sow.BTS_FK); } } return(model); }
public SOWListDataProvider(GlobalSolusindoDb db, tblM_User user, SOWQuery sowQuery) : base(db, user) { this.sowQuery = sowQuery; }
public List <SOWDTO> CreateListFromExcelBase64(SOWImportDTO importDTO) { BTSQuery btsquery = new BTSQuery(); UserQuery userQuery = new UserQuery(); var base64 = importDTO.File; base64 = base64.Replace("data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,", ""); var wb = ExcelConverter.FromBase64(base64); var sheet = wb.Worksheet("SOWUpload"); var nonEmptyRowCount = sheet.RowsUsed().Count() + 1; var areaQuery = new AreaQuery(Db); var operatorQuery = new OperatorQuery(Db); var technologyQuery = new TechnologyQuery(Db); var SOWQuery = new SOWQuery(Db); List <SOWDTO> SOWList = new List <SOWDTO>(); List <SOWAssignDTO> sowAssign = new List <SOWAssignDTO>(); //first index is 1, and the first one is header title for (int i = 2; i < nonEmptyRowCount; i++) { var row = sheet.Row(i); var pmouniq = row.Cell(1).Value.ToString(); var project = row.Cell(2).Value.ToString(); var duid = row.Cell(3).Value.ToString(); var bts = row.Cell(4).Value.ToString(); var tech = row.Cell(5).Value.ToString(); var sowname = row.Cell(6).Value.ToString(); var codate = row.Cell(7).Value.ToString(); var lvdate = row.Cell(8).Value.ToString(); var accdate = row.Cell(9).Value.ToString(); var tp = row.Cell(10).Value.ToString(); var rtp = row.Cell(11).Value.ToString(); var teamlead = row.Cell(12).Value.ToString(); var ploqc = row.Cell(13).Value.ToString(); var rf = row.Cell(14).Value.ToString(); var rigger = row.Cell(15).Value.ToString(); var dt = row.Cell(16).Value.ToString(); if (teamlead != "") { sowAssign.Add(new SOWAssignDTO() { User_FK = userQuery.GetByUsername(teamlead).User_PK }); } if (ploqc != "") { sowAssign.Add(new SOWAssignDTO() { User_FK = userQuery.GetByUsername(ploqc).User_PK }); } if (rf != "") { sowAssign.Add(new SOWAssignDTO() { User_FK = userQuery.GetByUsername(rf).User_PK }); } if (rigger != "") { sowAssign.Add(new SOWAssignDTO() { User_FK = userQuery.GetByUsername(rigger).User_PK }); } if (dt != "") { sowAssign.Add(new SOWAssignDTO() { User_FK = userQuery.GetByUsername(dt).User_PK }); } SOWList.Add(new SOWDTO() { SOWName = sowname, PMOUniq = pmouniq, BTS_FK = bts == "" ? 0 : Convert.ToInt16(project.Split('-')[0]), Project_FK = project == "" ? 0 : Convert.ToInt16(project.Split('-')[0]), Technology_FK = tech == "" ? 0 : technologyQuery.GetByTitle(tech).Technology_PK, TglMulai = DateTime.Parse(codate), DUID = duid, LVDate = DateTime.Parse(lvdate), AcceptedDate = DateTime.Parse(accdate), StatusSOW_FK = 1, SOWAssigns = sowAssign }); } return(SOWList); }
public SOWInfoDataProvider(GlobalSolusindoDb db, tblM_User user, AccessControl accessControl, SOWQuery sowQuery) : base(db, user) { this.accessControl = accessControl; this.sowQuery = sowQuery; }