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;
}
