public int UpdService(Tracker.Entity.web.Service service) { if (service != null && service.sid > 0) { DBConnect db = new DBConnect(); string updateStatement = string.Format("Update tblService set suspDt='{0}' where sid='{1}';", DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"), service.sid); db.Insert(updateStatement); return(SetService(service)); } else { throw new Exception("Service Unavailalbe to modify.."); } }
public int SetService(Tracker.Entity.web.Service service) { Tracker.Entity.web.Service tService = null; if (service.sid > 0) { tService = GetService(service.sid); } if (tService == null) { DBConnect db = new DBConnect(); string insert = string.Format("Insert into tblService (uid,sType,sPhone,srchDtil,dtil,statDt,expDt) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}');", service.uid, service.sType, service.sPhone, service.srcDtil, service.dtil, service.statDt.ToString("yyyy-MM-dd"), service.expDt.ToString("yyyy-MM-dd")); return(db.Insert(insert)); } else { throw new Exception("Service Already Found."); } }
public Tracker.Entity.web.Service GetService(int id) { DBConnect db = new DBConnect(); DataSet ds = db.Select("select * from tblService where sid=" + id.ToString()); Tracker.Entity.web.Service service = null; if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { service = new Entity.web.Service { sid = int.Parse(ds.Tables[0].Rows[0]["sid"].ToString()), uid = int.Parse(ds.Tables[0].Rows[0]["uid"].ToString()), sType = ds.Tables[0].Rows[0]["sType"].ToString(), dtil = ds.Tables[0].Rows[0]["dtil"].ToString(), sPhone = ds.Tables[0].Rows[0]["sPhone"].ToString(), srcDtil = ds.Tables[0].Rows[0]["srchDtil"].ToString(), statDt = DateTime.Parse(ds.Tables[0].Rows[0]["statDt"].ToString()), expDt = DateTime.Parse(ds.Tables[0].Rows[0]["expDt"].ToString()) } } ; return(service); }
// PUT: api/service/5 public int Put(int id, [FromBody] Tracker.Entity.web.Service service) { service.sid = id; return(ServiceBLL.Instance.UpdService(service)); }
// POST: api/service public int Post([FromBody] Tracker.Entity.web.Service service) { return(ServiceBLL.Instance.SetService(service)); }