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