public int CreatePIPDetails(PIPDeatilsEntities PIPDetailEntities) { //DateTime? createddate = null; //DateTime? closeddate = null; var createddate = (DateTime?)null; var closeddate = (DateTime?)null; if (PIPDetailEntities.CREATEDATE != null) { createddate = DateTime.ParseExact(PIPDetailEntities.CREATEDATE, "dd/MM/yyyy", CultureInfo.InvariantCulture); } if (PIPDetailEntities.CLOSEDATE != null) { closeddate = DateTime.ParseExact(PIPDetailEntities.CLOSEDATE, "dd/MM/yyyy", CultureInfo.InvariantCulture); } if (PIPDetailEntities != null) { var PIPDetailDetail = new TBL_EMP_PIPDETAILS { EMPLOYEE_ID = PIPDetailEntities.EMPLOYEE_ID, PIP_DATE = createddate, REASON = PIPDetailEntities.REASON, PERIOD = PIPDetailEntities.PERIOD, PIPCREATEDBY = PIPDetailEntities.PIPCREATEDBY, PIPCLOSEDBY = PIPDetailEntities.PIPCLOSEDBY, PIPCLOSEDDATE = closeddate, REMARKS = PIPDetailEntities.REMARKS }; _UOW.PIPDETAILSRepository.Insert(PIPDetailDetail); _UOW.Save(); } return(Convert.ToInt32(PIPDetailEntities.ID)); }
// PUT api/pipdetails/5 public bool Put(int id, [FromBody] PIPDeatilsEntities item) { if (id > 0) { return(_PIPDetails.UpdatePIPDetails(id, item)); } return(false); }
// POST api/pipdetails public int Post([FromBody] PIPDeatilsEntities item) { return(_PIPDetails.CreatePIPDetails(item)); }
public bool UpdatePIPDetails(int PIPDeatilId, PIPDeatilsEntities PIPDeatilEntities) { var createddate = (DateTime?)null; var closeddate = (DateTime?)null; if (PIPDeatilEntities.CREATEDATE != null) { createddate = DateTime.ParseExact(PIPDeatilEntities.CREATEDATE, "dd/MM/yyyy", CultureInfo.InvariantCulture); } if (PIPDeatilEntities.CLOSEDATE != null) { closeddate = DateTime.ParseExact(PIPDeatilEntities.CLOSEDATE, "dd/MM/yyyy", CultureInfo.InvariantCulture); } var success = false; if (PIPDeatilEntities != null) { //using (var scope = new TransactionScope()) //{ var PIPDeatil = _UOW.PIPDETAILSRepository.GetByID(PIPDeatilId); if (PIPDeatil != null) { if (PIPDeatilEntities.EMPLOYEE_ID != null) { PIPDeatil.EMPLOYEE_ID = PIPDeatilEntities.EMPLOYEE_ID; } if (PIPDeatilEntities.CREATEDATE != null) { PIPDeatil.PIP_DATE = createddate; } if (PIPDeatilEntities.REASON != "" && PIPDeatilEntities.REASON != null) { PIPDeatil.REASON = PIPDeatilEntities.REASON; } if (PIPDeatilEntities.PERIOD != null) { PIPDeatil.PERIOD = PIPDeatilEntities.PERIOD; } if (PIPDeatilEntities.PIPCREATEDBY != "" && PIPDeatilEntities.PIPCREATEDBY != null) { PIPDeatil.PIPCREATEDBY = PIPDeatilEntities.PIPCREATEDBY; } if (PIPDeatilEntities.PIPCLOSEDBY != "" && PIPDeatilEntities.PIPCLOSEDBY != null) { PIPDeatil.PIPCLOSEDBY = PIPDeatilEntities.PIPCLOSEDBY; } if (PIPDeatilEntities.CLOSEDATE != null) { PIPDeatil.PIPCLOSEDDATE = closeddate; } if (PIPDeatilEntities.REMARKS != "" && PIPDeatilEntities.REMARKS != null) { PIPDeatil.REMARKS = PIPDeatilEntities.REMARKS; } _UOW.PIPDETAILSRepository.Update(PIPDeatil); _UOW.Save(); //scope.Complete(); success = true; //} } } return(success); }