public ArrayList GetList(string Condition)
{
ArrayList arrChangePrimaryBusList = new ArrayList();
ChangePrimaryBus ChangePrimaryBusObj;
try
{
DataTable dtChangePrimaryBus = DH.ExecuteDataTable("select " + strFieldsToSelect + " from " + strTableName + " Where " + Condition);
foreach (DataRow dr in dtChangePrimaryBus.Rows)
{
ChangePrimaryBusObj = new ChangePrimaryBus();
if (dr["ID"] != DBNull.Value)
{
ChangePrimaryBusObj.ID = int.Parse(dr["ID"].ToString());
}
if (dr["MSISDN"] != DBNull.Value)
{
ChangePrimaryBusObj.MSISDN = dr["MSISDN"].ToString();
}
if (dr["receive_date"] != DBNull.Value)
{
ChangePrimaryBusObj.receive_date = dr["receive_date"].ToString();
}
if (dr["SMS_content"] != DBNull.Value)
{
ChangePrimaryBusObj.SMS_content = dr["SMS_content"].ToString();
}
if (dr["SMS_Options"] != DBNull.Value)
{
ChangePrimaryBusObj.SMS_Options = dr["SMS_Options"].ToString();
}
if (dr["Reply_Option"] != DBNull.Value)
{
ChangePrimaryBusObj.Reply_Option = dr["Reply_Option"].ToString();
}
if (dr["status"] != DBNull.Value)
{
ChangePrimaryBusObj.status = int.Parse(dr["status"].ToString());
}
if (dr["error_desc"] != DBNull.Value)
{
ChangePrimaryBusObj.error_desc = dr["error_desc"].ToString();
}
if (dr["request_type"] != DBNull.Value)
{
ChangePrimaryBusObj.request_type = int.Parse(dr["request_type"].ToString());
}
arrChangePrimaryBusList.Add(ChangePrimaryBusObj);
}
}
catch (Exception ex)
{
throw ex;
}
return(arrChangePrimaryBusList);
}
public ChangePrimaryBus Get(string Condition)
{
ChangePrimaryBus ChangePrimaryBusObj = new ChangePrimaryBus();
try
{
DataTable dtChangePrimaryBus = DH.ExecuteDataTable("select " + strFieldsToSelect + " from " + strTableName + " Where " + Condition);
if (dtChangePrimaryBus.Rows.Count > 0)
{
DataRow dr = dtChangePrimaryBus.Rows[0];
if (dr["ID"] != DBNull.Value)
{
ChangePrimaryBusObj.ID = int.Parse(dr["ID"].ToString());
}
if (dr["MSISDN"] != DBNull.Value)
{
ChangePrimaryBusObj.MSISDN = dr["MSISDN"].ToString();
}
if (dr["receive_date"] != DBNull.Value)
{
ChangePrimaryBusObj.receive_date = dr["receive_date"].ToString();
}
if (dr["SMS_content"] != DBNull.Value)
{
ChangePrimaryBusObj.SMS_content = dr["SMS_content"].ToString();
}
if (dr["SMS_Options"] != DBNull.Value)
{
ChangePrimaryBusObj.SMS_Options = dr["SMS_Options"].ToString();
}
if (dr["Reply_Option"] != DBNull.Value)
{
ChangePrimaryBusObj.Reply_Option = dr["Reply_Option"].ToString();
}
if (dr["status"] != DBNull.Value)
{
ChangePrimaryBusObj.status = int.Parse(dr["status"].ToString());
}
if (dr["error_desc"] != DBNull.Value)
{
ChangePrimaryBusObj.error_desc = dr["error_desc"].ToString();
}
if (dr["request_type"] != DBNull.Value)
{
ChangePrimaryBusObj.request_type = int.Parse(dr["request_type"].ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
return(ChangePrimaryBusObj);
}
public int Add(ChangePrimaryBus ChangePrimaryBusObj)
{
try
{
string strColumns = "";
string strValues = "";
strColumns += "MSISDN";
if (ChangePrimaryBusObj.MSISDN != null)
{
strValues += "" + DH.ToDBString(ChangePrimaryBusObj.MSISDN);
}
else
{
strValues += "null";
}
strColumns += ",receive_date";
if (ChangePrimaryBusObj.receive_date != null)
{
strValues += "," + DH.ToDBString(ChangePrimaryBusObj.receive_date);
}
else
{
strValues += ",null";
}
strColumns += ",SMS_content";
if (ChangePrimaryBusObj.SMS_content != null)
{
strValues += "," + DH.ToDBString(ChangePrimaryBusObj.SMS_content);
}
else
{
strValues += ",null";
}
strColumns += ",SMS_Options";
if (ChangePrimaryBusObj.SMS_Options != null)
{
strValues += "," + DH.ToDBString(ChangePrimaryBusObj.SMS_Options);
}
else
{
strValues += ",null";
}
strColumns += ",Reply_Option";
if (ChangePrimaryBusObj.Reply_Option != null)
{
strValues += "," + DH.ToDBString(ChangePrimaryBusObj.Reply_Option);
}
else
{
strValues += ",null";
}
strColumns += ",status";
if (ChangePrimaryBusObj.status >= 0)
{
strValues += "," + ChangePrimaryBusObj.status;
}
else
{
strValues += ",null";
}
strColumns += ",error_desc";
if (ChangePrimaryBusObj.error_desc != null)
{
strValues += "," + DH.ToDBString(ChangePrimaryBusObj.error_desc);
}
else
{
strValues += ",null";
}
strColumns += ",request_type";
if (ChangePrimaryBusObj.request_type >= 0)
{
strValues += "," + ChangePrimaryBusObj.request_type;
}
else
{
strValues += ",null";
}
DH.ExecuteNonQuery("insert into " + strTableName + "(" + strColumns + ") values(" + strValues + ")");
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(ChangePrimaryBus ChangePrimaryBusObj)
{
try
{
string strUpdate = "update " + strTableName + " set ";
string strSets = "";
string strWhere = " where 1=1" + "" + " and ID=" + ChangePrimaryBusObj.ID;
if (ChangePrimaryBusObj.MSISDN != null)
{
strSets += "MSISDN=" + DH.ToDBString(ChangePrimaryBusObj.MSISDN);
}
else
{
strSets += "MSISDN=null";
}
if (ChangePrimaryBusObj.SMS_content != null)
{
strSets += ",SMS_content=" + DH.ToDBString(ChangePrimaryBusObj.SMS_content);
}
else
{
strSets += ",SMS_content=null";
}
if (ChangePrimaryBusObj.SMS_Options != null)
{
strSets += ",SMS_Options=" + DH.ToDBString(ChangePrimaryBusObj.SMS_Options);
}
else
{
strSets += ",SMS_Options=null";
}
if (ChangePrimaryBusObj.Reply_Option != null)
{
strSets += ",Reply_Option=" + DH.ToDBString(ChangePrimaryBusObj.Reply_Option);
}
else
{
strSets += ",Reply_Option=null";
}
if (ChangePrimaryBusObj.status >= 0)
{
strSets += ",status=" + ChangePrimaryBusObj.status;
}
else
{
strSets += ",status=null";
}
if (ChangePrimaryBusObj.error_desc != null)
{
strSets += ",error_desc=" + DH.ToDBString(ChangePrimaryBusObj.error_desc);
}
else
{
strSets += ",error_desc=null";
}
if (ChangePrimaryBusObj.request_type >= 0)
{
strSets += ",request_type=" + ChangePrimaryBusObj.request_type;
}
else
{
strSets += ",request_type=null";
}
if (strSets.Length > 0)
{
DH.ExecuteNonQuery(strUpdate + strSets + strWhere);
}
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
