public DataTable C_GEToDataCpnByGroup(string ptUrl, cmlCpnSearchReq poCpnSearchReq)
{
try
{
switch (poCpnSearchReq.tCML_CpnUseSta)
{
case "": poCpnSearchReq.tCML_CpnUseSta = ""; break;
case "ใช้งานได้": poCpnSearchReq.tCML_CpnUseSta = "0"; break;
case "ใช้งานไปแล้ว": poCpnSearchReq.tCML_CpnUseSta = "1"; break;
case "ยกเลิก": poCpnSearchReq.tCML_CpnUseSta = "2"; break;
case "หมดอายุ": poCpnSearchReq.tCML_CpnUseSta = "Exp"; break;
}
var tJsonContent = JsonConvert.SerializeObject(poCpnSearchReq, Formatting.Indented);
var tResult = C_ContWebApi(ptUrl, "POST", tJsonContent);
return(JsonConvert.DeserializeObject <DataTable>(tResult));
}
catch (Exception oEx)
{
throw oEx;
}
}
public HttpResponseMessage GEToDataCpnByGroup([FromBody] cmlCpnSearchReq poCpnSearchReq)
{
try
{
var oDataCpn = oC_DataCpnSearch.C_GEToDataCpnByGroup(poCpnSearchReq);
return(SEToDataTableToJson(oDataCpn));
}
catch (WebException oEx)
{
log.Error(cExtensionMessageError.C_GEToErrorException(oEx));
throw cExtensionMessageError.C_GEToErrorException(oEx);
}
}
private void W_GETxSearchCpnGroup()
{
try
{
oFoodLandCallAPI = new cFoodLandCallAPI();
var oCouponReq = new cmlCpnSearchReq
{
tCML_StmCode = otbSearchStmCode.Text,
tCML_CpnUseSta = tSearchCpnSta
};
if (oCouponReq.tCML_CpnUseSta.Equals("ทั้งหมด"))
{
string tUrl = tC_Url + "CpnStatusAll";
oCpnData = oFoodLandCallAPI.C_GEToDataCpnStatusAll(tUrl.Trim());
}
else if (oCouponReq.tCML_CpnUseSta.Equals("NULL"))
{
oCouponReq.tCML_CpnUseSta = "";
string tUrl = tC_Url + "CpnSearchByGroup";
oCpnData = oFoodLandCallAPI.C_GEToDataCpnByGroup(tUrl.Trim(), oCouponReq);
}
else
{
string tUrl = tC_Url + "CpnSearchByGroup";
oCpnData = oFoodLandCallAPI.C_GEToDataCpnByGroup(tUrl.Trim(), oCouponReq);
}
}
catch (WebException oEx)
{
int nResCode = (int)oEx.Status;
if (oEx.Status == WebExceptionStatus.ProtocolError || oEx.Status == WebExceptionStatus.ConnectFailure || oEx.Status == WebExceptionStatus.KeepAliveFailure)
{
var response = oEx.Response as HttpWebResponse;
if (response != null)
{
nResCode = (int)response.StatusCode;
if (nResCode == 500)
{
MessageBox.Show("wMain : W_GETxSearchCpnGroup ///" + oEx.Message + "ไม่สามารถติดต่อฐานข้อมูลได้ หรือฐานข้อมูลไม่ถูกต้อง กรุณาตรวจสอบการตั้งค่า");
}
}
}
else
{
MessageBox.Show("wMain : W_GETxSearchCpnGroup ///" + oEx.Message);
}
}
}
private void ocmSearchCpnGroup_Click(object sender, EventArgs e)
{
try
{
oFoodLandCallAPI = new cFoodLandCallAPI();
var tUrl = otbUrl.Text = tC_Url + "CpnSearchByGroup";
var oCouponReq = new cmlCpnSearchReq();
oCouponReq.tCML_StmCode = otbSearchStmCode.Text;
oCouponReq.tCML_CpnUseSta = ocbSearchCpnSta.Text;
var oCpnStatusAll = oFoodLandCallAPI.C_GEToDataCpnByGroup(tUrl.Trim(), oCouponReq);
ogdDataCoupon.DataSource = oCpnStatusAll;
}
catch (Exception oEx)
{
throw oEx;
}
}
public DataTable C_GEToDataCpnStatusAll(cmlCpnSearchReq poCpnSearchReq)
{
throw new NotImplementedException();
}
public DataTable C_GEToDataCpnByGroup(cmlCpnSearchReq poCpnSearchReq)
{
}
public DataTable C_GEToDataCpnStatusAll(cmlCpnSearchReq poCpnSearchReq)
{
}
public DataTable C_GEToDataCpnByGroup(cmlCpnSearchReq poCpnSearchReq)
{
StringBuilder oSql;
try
{
oSql = new StringBuilder();
if (poCpnSearchReq.tCML_CpnUseSta.Equals("Exp") && poCpnSearchReq.tCML_StmCode != "")
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE FTStmCode = '" + poCpnSearchReq.tCML_StmCode + "' ");
oSql.AppendLine("AND Getdate() > FDCpnExp");
oSql.AppendLine("ORDER BY FDDateUpd DESC ");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
else if (poCpnSearchReq.tCML_CpnUseSta.Equals("Exp"))
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE Getdate() > FDCpnExp");
oSql.AppendLine("ORDER BY FDDateUpd DESC ");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
if (poCpnSearchReq.tCML_StmCode != "" && poCpnSearchReq.tCML_CpnUseSta != "")
{
if (poCpnSearchReq.tCML_CpnUseSta == "0")
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE FTStmCode = '" + poCpnSearchReq.tCML_StmCode + "' ");
oSql.AppendLine("AND FTCpnUseSta = '" + poCpnSearchReq.tCML_CpnUseSta + "'");
oSql.AppendLine("AND Getdate() < FDCpnExp");
oSql.AppendLine("ORDER BY FDDateUpd DESC");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
else
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE FTStmCode = '" + poCpnSearchReq.tCML_StmCode + "' ");
oSql.AppendLine("AND FTCpnUseSta = '" + poCpnSearchReq.tCML_CpnUseSta + "'");
oSql.AppendLine("ORDER BY FDDateUpd DESC");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
}
else if (poCpnSearchReq.tCML_StmCode == "")
{
if (poCpnSearchReq.tCML_CpnUseSta == "0")
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE FTCpnUseSta = '" + poCpnSearchReq.tCML_CpnUseSta + "' ");
oSql.AppendLine("AND Getdate() < FDCpnExp");
oSql.AppendLine("ORDER BY FDDateUpd DESC ");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
else
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE FTCpnUseSta = '" + poCpnSearchReq.tCML_CpnUseSta + "' ");
oSql.AppendLine("ORDER BY FDDateUpd DESC ");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
}
else
{
oSql.AppendLine("SELECT FTStmCode");
oSql.AppendLine(",FTTmnNum");
oSql.AppendLine(",FDDateIns");
oSql.AppendLine(",FTCpnCode");
oSql.AppendLine(",FCCpnAmt");
oSql.AppendLine(",FDCpnExp");
oSql.AppendLine(",FTCpnUseSta");
oSql.AppendLine(",FTWhoIns");
oSql.AppendLine("FROM TPSTCpnStatus ");
oSql.AppendLine("WHERE FTStmCode = '" + poCpnSearchReq.tCML_StmCode + "' ");
oSql.AppendLine("ORDER BY FDDateUpd DESC ");
var oDataCpn = cCNSP.SP_GEToDbTbl(oSql.ToString());
return(oDataCpn);
}
}
catch (SqlException oEx)
{
throw oEx;
}
}
