public int Add(VAT_SHOP_ECARE VAT_SHOP_ECAREObj)
{
try
{
string strColumns = "";
string strValues = "";
strColumns += "REQ_XML";
if (VAT_SHOP_ECAREObj.REQ_XML != null)
{
strValues += "" + DH.ToDBString(VAT_SHOP_ECAREObj.REQ_XML);
}
else
{
strValues += "null";
}
strColumns += ",PARTITION_ID";
if (VAT_SHOP_ECAREObj.Partition_ID != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.Partition_ID);
}
else
{
strValues += ",null";
}
strColumns += ",SEQ_ID";
if (VAT_SHOP_ECAREObj.SEQ_ID != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.SEQ_ID);
}
else
{
strValues += ",null";
}
strColumns += ",ResultDesc";
if (VAT_SHOP_ECAREObj.ResultDesc != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.ResultDesc);
}
else
{
strValues += ",null";
}
strColumns += ",OFFER_NAME";
if (VAT_SHOP_ECAREObj.OFFER_NAME != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.OFFER_NAME);
}
else
{
strValues += ",null";
}
strColumns += ",STATUS";
if (VAT_SHOP_ECAREObj.STATUS >= 0)
{
strValues += "," + VAT_SHOP_ECAREObj.STATUS;
}
else
{
strValues += ",null";
}
strColumns += ",CHANNEL";
if (VAT_SHOP_ECAREObj.CHANNEL != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.CHANNEL);
}
else
{
strValues += ",null";
}
strColumns += ",VAT_AMOUNT";
if (VAT_SHOP_ECAREObj.VAT_AMOUNT > 0)
{
strValues += "," + VAT_SHOP_ECAREObj.VAT_AMOUNT;
}
else
{
strValues += ",null";
}
strColumns += ",RECHARGE_AMOUNT";
if (VAT_SHOP_ECAREObj.RECHARGE_AMOUNT > 0)
{
strValues += "," + VAT_SHOP_ECAREObj.RECHARGE_AMOUNT;
}
else
{
strValues += ",null";
}
strColumns += ",MSISDN";
if (VAT_SHOP_ECAREObj.MSISDN != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.MSISDN);
}
else
{
strValues += ",null";
}
strColumns += ",TRANSDATE";
if (VAT_SHOP_ECAREObj.TRANSDATE != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.TRANSDATE);
}
else
{
strValues += ",null";
}
strColumns += ",TRACK_ID";
if (VAT_SHOP_ECAREObj.TRACK_ID != null)
{
strValues += "," + DH.ToDBString(VAT_SHOP_ECAREObj.TRACK_ID);
}
else
{
strValues += ",null";
}
DH.ExecuteNonQuery("insert into " + strTableName + "(" + strColumns + ") values(" + strValues + ")");
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public VAT_SHOP_ECARE Get(string Condition)
{
VAT_SHOP_ECARE VAT_SHOP_ECAREObj = new VAT_SHOP_ECARE();
try
{
DataTable dtVAT_SHOP_ECARE = DH.ExecuteDataTable("select " + strFieldsToSelect + " from " + strTableName + " Where " + Condition);
if (dtVAT_SHOP_ECARE.Rows.Count > 0)
{
DataRow dr = dtVAT_SHOP_ECARE.Rows[0];
if (dr["REQ_XML"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.REQ_XML = dr["REQ_XML"].ToString();
}
if (dr["SEQ_ID"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.SEQ_ID = dr["SEQ_ID"].ToString();
}
if (dr["OFFER_NAME"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.OFFER_NAME = dr["OFFER_NAME"].ToString();
}
if (dr["ResultDesc"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.ResultDesc = dr["ResultDesc"].ToString();
}
if (dr["STATUS"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.STATUS = int.Parse(dr["STATUS"].ToString());
}
if (dr["CHANNEL"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.CHANNEL = dr["CHANNEL"].ToString();
}
if (dr["VAT_AMOUNT"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.VAT_AMOUNT = decimal.Parse(dr["VAT_AMOUNT"].ToString());
}
if (dr["RECHARGE_AMOUNT"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.RECHARGE_AMOUNT = int.Parse(dr["RECHARGE_AMOUNT"].ToString());
}
if (dr["MSISDN"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.MSISDN = dr["MSISDN"].ToString();
}
if (dr["TRANSDATE"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.TRANSDATE = dr["TRANSDATE"].ToString();
}
if (dr["TRACK_ID"] != DBNull.Value)
{
VAT_SHOP_ECAREObj.TRACK_ID = dr["TRACK_ID"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(VAT_SHOP_ECAREObj);
}
public int Update(VAT_SHOP_ECARE VAT_SHOP_ECAREObj)
{
try
{
string strUpdate = "update " + strTableName + " set ";
string strSets = "";
string strWhere = " where SEQ_ID=" + VAT_SHOP_ECAREObj.SEQ_ID;
if (VAT_SHOP_ECAREObj.REQ_XML != null)
{
strSets += ",REQ_XML=" + DH.ToDBString(VAT_SHOP_ECAREObj.REQ_XML);
}
else
{
strSets += ",REQ_XML=null";
}
if (VAT_SHOP_ECAREObj.SEQ_ID != null)
{
strSets += ",SEQ_ID=" + DH.ToDBString(VAT_SHOP_ECAREObj.SEQ_ID);
}
else
{
strSets += ",SEQ_ID=null";
}
if (VAT_SHOP_ECAREObj.ResultDesc != null)
{
strSets += ",ResultDesc=" + DH.ToDBString(VAT_SHOP_ECAREObj.ResultDesc);
}
else
{
strSets += ",ResultDesc=null";
}
if (VAT_SHOP_ECAREObj.OFFER_NAME != null)
{
strSets += ",OFFER_NAME=" + DH.ToDBString(VAT_SHOP_ECAREObj.OFFER_NAME);
}
else
{
strSets += ",OFFER_NAME=null";
}
if (VAT_SHOP_ECAREObj.STATUS > 0)
{
strSets += ",STATUS=" + VAT_SHOP_ECAREObj.STATUS;
}
else
{
strSets += ",STATUS=null";
}
if (VAT_SHOP_ECAREObj.CHANNEL != null)
{
strSets += ",CHANNEL=" + DH.ToDBString(VAT_SHOP_ECAREObj.CHANNEL);
}
else
{
strSets += ",CHANNEL=null";
}
if (VAT_SHOP_ECAREObj.VAT_AMOUNT > 0)
{
strSets += ",VAT_AMOUNT=" + VAT_SHOP_ECAREObj.VAT_AMOUNT;
}
else
{
strSets += ",VAT_AMOUNT=null";
}
if (VAT_SHOP_ECAREObj.RECHARGE_AMOUNT > 0)
{
strSets += ",RECHARGE_AMOUNT=" + VAT_SHOP_ECAREObj.RECHARGE_AMOUNT;
}
else
{
strSets += ",RECHARGE_AMOUNT=null";
}
if (VAT_SHOP_ECAREObj.MSISDN != null)
{
strSets += ",MSISDN=" + DH.ToDBString(VAT_SHOP_ECAREObj.MSISDN);
}
else
{
strSets += ",MSISDN=null";
}
if (VAT_SHOP_ECAREObj.TRANSDATE != null)
{
strSets += ",TRANSDATE=" + DH.ToDBString(VAT_SHOP_ECAREObj.TRANSDATE);
}
else
{
strSets += ",TRANSDATE=null";
}
if (VAT_SHOP_ECAREObj.TRACK_ID != null)
{
strSets += ",TRACK_ID=" + DH.ToDBString(VAT_SHOP_ECAREObj.TRACK_ID);
}
else
{
strSets += ",TRACK_ID=null";
}
if (strSets.Length > 0)
{
DH.ExecuteNonQuery(strUpdate + strSets + strWhere);
}
return(1);
}
catch (Exception ex)
{
throw ex;
}
}