public CpPackageEventInfo[] GetByFilter(String tvcdb, List <DTO.Criteria> filters, ref string sErr, int indexPage = 0, int itemPerPage = 0) { DataTable list = GetByFilterToDataTable(tvcdb, filters, ref sErr, indexPage, itemPerPage); if (!string.IsNullOrEmpty(sErr)) { return(null); } CpPackageEventInfo[] res = null; try { res = new CpPackageEventInfo[list.Rows.Count]; for (int i = 0; i < list.Rows.Count; i++) { res[i] = new CpPackageEventInfo(list.Rows[i]); } } catch (Exception ex) { sErr = ex.Message; } if (!string.IsNullOrEmpty(sErr)) { return(null); } return(res); }
public string Update(CpPackageEventInfo obj) { string sErr = _objDAO.Update(obj); // delete details // add details return(sErr); }
public int Add(CpPackageEventInfo obj, ref string sErr) { _objDAO.Add(obj, ref sErr); if (string.IsNullOrEmpty(sErr)) { //add details } return(1); }
public string InsertUpdate(CpPackageEventInfo obj) { string sErr = string.Empty; if (IsExist(obj.tvcdb, obj.packagecode, obj.eventid, ref sErr)) { sErr = Update(obj); } else { obj.createdby = USER_ID; if (string.IsNullOrEmpty(sErr)) { Add(obj, ref sErr); } } return(sErr); }
public string Update(CpPackageEventInfo objEntr) { string sql = @"UPDATE cppackageevent SET "; if (objEntr.eventtype != null) { sql += "eventtype = @eventtype,"; } if (objEntr.startdate != null) { sql += "startdate = @startdate,"; } if (objEntr.enddate != null) { sql += "enddate = @enddate,"; } if (objEntr.eventstatus != null) { sql += "eventstatus = @eventstatus,"; } if (objEntr.lookup != null) { sql += "lookup = @lookup,"; } if (objEntr.pic != null) { sql += "pic = @pic,"; } if (objEntr.notes != null) { sql += "notes = @notes,"; } if (objEntr.updatedby != null) { sql += "updatedby = @updatedby,"; } sql += " lastupdate = getdate()"; sql += @" WHERE tvcdb = @tvcdb AND packagecode = @packagecode AND eventid = @eventid"; openConnection(); InitCommand(sql); AddParameter(CpPackageEventInfo.Field.tvcdb, objEntr.tvcdb); AddParameter(CpPackageEventInfo.Field.packagecode, objEntr.packagecode); AddParameter(CpPackageEventInfo.Field.eventid, objEntr.eventid); if (objEntr.eventtype != null) { AddParameter(CpPackageEventInfo.Field.eventtype, objEntr.eventtype); } if (objEntr.startdate != null) { AddParameter(CpPackageEventInfo.Field.startdate, objEntr.startdate); } if (objEntr.enddate != null) { AddParameter(CpPackageEventInfo.Field.enddate, objEntr.enddate); } if (objEntr.eventstatus != null) { AddParameter(CpPackageEventInfo.Field.eventstatus, objEntr.eventstatus); } if (objEntr.lookup != null) { AddParameter(CpPackageEventInfo.Field.lookup, objEntr.lookup); } if (objEntr.pic != null) { AddParameter(CpPackageEventInfo.Field.pic, objEntr.pic); } if (objEntr.notes != null) { AddParameter(CpPackageEventInfo.Field.notes, objEntr.notes); } if (objEntr.updatedby != null) { AddParameter(CpPackageEventInfo.Field.updatedby, objEntr.updatedby); } string sErr = string.Empty; try { executeNonQuery(); } catch (Exception ex) { sErr = string.Format("{0} sql='{1}'", ex.Message, sql); } finally { closeConnection(); } return(sErr); }
/// <summary> /// Return 1: Table is exist Identity Field /// Return 0: Table is not exist Identity Field /// Return -1: Erro /// </summary> /// <param name="tableName"></param> public int Add(CpPackageEventInfo objEntr, ref string sErr) { string sqlFields = @" INSERT INTO cppackageevent(tvcdb,packagecode,eventid,"; string sqlValues = @" VALUES(@tvcdb,@packagecode,@eventid,"; if (objEntr.eventtype != null) { sqlFields += " eventtype,"; sqlValues += " @eventtype,"; } if (objEntr.startdate != null) { sqlFields += " startdate,"; sqlValues += " @startdate,"; } if (objEntr.enddate != null) { sqlFields += " enddate,"; sqlValues += " @enddate,"; } if (objEntr.eventstatus != null) { sqlFields += " eventstatus,"; sqlValues += " @eventstatus,"; } if (objEntr.lookup != null) { sqlFields += " lookup,"; sqlValues += " @lookup,"; } if (objEntr.pic != null) { sqlFields += " pic,"; sqlValues += " @pic,"; } if (objEntr.notes != null) { sqlFields += " notes,"; sqlValues += " @notes,"; } if (objEntr.createdby != null) { sqlFields += " createdby,"; sqlValues += " @createdby,"; } if (objEntr.updatedby != null) { sqlFields += " updatedby,"; sqlValues += " @updatedby,"; } sqlFields = sqlFields.Substring(0, sqlFields.Length - 1) + ")"; sqlValues = sqlValues.Substring(0, sqlValues.Length - 1) + ")"; int ret = -1; string sql = sqlFields + sqlValues; openConnection(); InitCommand(sql); AddParameter(CpPackageEventInfo.Field.tvcdb, objEntr.tvcdb); AddParameter(CpPackageEventInfo.Field.packagecode, objEntr.packagecode); AddParameter(CpPackageEventInfo.Field.eventid, objEntr.eventid); if (objEntr.eventtype != null) { AddParameter(CpPackageEventInfo.Field.eventtype, objEntr.eventtype); } if (objEntr.startdate != null) { AddParameter(CpPackageEventInfo.Field.startdate, objEntr.startdate); } if (objEntr.enddate != null) { AddParameter(CpPackageEventInfo.Field.enddate, objEntr.enddate); } if (objEntr.eventstatus != null) { AddParameter(CpPackageEventInfo.Field.eventstatus, objEntr.eventstatus); } if (objEntr.lookup != null) { AddParameter(CpPackageEventInfo.Field.lookup, objEntr.lookup); } if (objEntr.pic != null) { AddParameter(CpPackageEventInfo.Field.pic, objEntr.pic); } if (objEntr.notes != null) { AddParameter(CpPackageEventInfo.Field.notes, objEntr.notes); } if (objEntr.createdby != null) { AddParameter(CpPackageEventInfo.Field.createdby, objEntr.createdby); } if (objEntr.updatedby != null) { AddParameter(CpPackageEventInfo.Field.updatedby, objEntr.updatedby); } try { object tmp = executeScalar(); if (tmp != null && tmp != DBNull.Value) { ret = Convert.ToInt32(tmp); } else { ret = 0; } } catch (Exception ex) { sErr = string.Format("{0} sql='{1}'", ex.Message, sql); } finally { closeConnection(); } return(ret); }