public HttpResponseMessage Get()
{
HttpResponseMessage message = null;
productListModel prodMdl = new productListModel();
string token = HttpContext.Current.Request.Headers["Authorization"].Replace("Bearer ", "").Trim();
try
{
if (dbconn.idbCheck(out dbres))
{
string userCardNo = string.Empty;
string userAdminNo = string.Empty;
if (dbconn.checkToken(token, out userCardNo, out userAdminNo))
{
DataTable dt = dbconn.getTable(appServiceQry._getMainProducts("27,28,29,73"));
if (dt.Rows.Count != 0)
{
List <productDetial> prdList = new List <productDetial>();
foreach (DataRow item in dt.Rows)
{
productDetial prodDetial = new productDetial();
prodDetial.productName = item["PRODUCT_NAME_MON"].ToString();
prodDetial.productId = item["PRODUCT_ID"].ToString();
prodDetial.smsCode = item["SMS_CODE"].ToString();
prodDetial.productImg = httpUtil.getProductLogoUrl(item["PRODUCT_ID"].ToString());//"http://my.ddishtv.mn:808/products/bagts.png";
//prodDetial.additionalProducts = null;
//DataTable dtUp = dbconn.getTable(appServiceQry._getMainProducts(item["UPGRADE_PRODUCTS"].ToString()));
//List<addChennelDetial> upChannels = new List<addChennelDetial>();
//foreach(DataRow dr in dtUp.Rows)
//{
// addChennelDetial upch = new addChennelDetial();
// upch.productName = dr["PRODUCT_NAME_MON"].ToString();
// upch.productId = dr["PRODUCT_ID"].ToString();
// upch.smsCode = dr["SMS_CODE"].ToString();
// upch.productImg = "http://my.ddishtv.mn:808/products/bagts.png";
// upChannels.Add(upch);
//}
//prodDetial.upProducts = upChannels;
// ======================= price List awah =============================
DataTable dtPrice = dbconn.getTable(appServiceQry._getMainProductPrices(item["PRODUCT_ID"].ToString()));
string priceP = string.Empty;
if (dtPrice.Rows.Count != 0)
{
priceP = dtPrice.Rows[0]["PRICE"].ToString();
}
prodDetial.price = priceP;
////List<priceList> priceL = new List<priceList>();
////foreach (DataRow rr in dtPrice.Rows)
////{
//// priceList price = new priceList();
//// price.productId = rr["PRODUCT_ID"].ToString();
//// price.price = rr["PRICE"].ToString();
//// price.month = rr["MONTH"].ToString();
//// priceL.Add(price);
////}
////prodDetial.priceList = priceL;
prdList.Add(prodDetial);
}
prodMdl.isSuccess = true;
prodMdl.resultCode = HttpStatusCode.OK.ToString();
prodMdl.resultMessage = appConstantValues.MSG_SUCCESS;
prodMdl.productList = prdList;
}
else
{
prodMdl.isSuccess = false;
prodMdl.resultCode = HttpStatusCode.NotFound.ToString();
prodMdl.resultMessage = appConstantValues.MSG_NOFOUND;
}
}
else
{
prodMdl.isSuccess = false;
prodMdl.resultCode = HttpStatusCode.Unauthorized.ToString();
prodMdl.resultMessage = appConstantValues.MSG_EXPIRED;
}
}
else
{
prodMdl.isSuccess = false;
prodMdl.resultCode = HttpStatusCode.NotFound.ToString();
prodMdl.resultMessage = appConstantValues.MSG_INTERNAL_ERROR;
LogWriter._error(TAG, dbres);
}
}
catch (Exception ex)
{
exceptionManager.ManageException(ex, TAG);
prodMdl.isSuccess = false;
prodMdl.resultCode = HttpStatusCode.NotFound.ToString();
prodMdl.resultMessage = ex.Message;
}
message = Request.CreateResponse(HttpStatusCode.OK, prodMdl);
LogWriter._channelList(TAG, string.Format("IP: [{0}], Request: [{1}], Response: [{2}], Token: [{3}]", httpUtil.GetClientIPAddress(HttpContext.Current.Request), "", serialzer.Serialize(prodMdl), token));
return(message);
}
public async Task <HttpResponseMessage> Get(string searchVal)
{
HttpResponseMessage message = new HttpResponseMessage();
string ip = httpUtil.GetClientIPAddress(HttpContext.Current.Request);
string secToken = string.Empty;
ProdutListResponse response = new ProdutListResponse();
LogWriter._chargeProd(TAG, string.Format(@"[>>] Request: [{0}]", searchVal));
try
{
secToken = HttpContext.Current.Request.Headers["Authorization"].Replace("Basic ", "").Trim();
if (dbconn.idbStatOK())
{
string insId = string.Empty;
string insPhone = string.Empty;
if (dbconn.tabletCheckToken(secToken, out insId, out insPhone))
{
LogWriter._noti(TAG, string.Format(@"Request Token: [{0}], InstallerId: [{1}]", secToken, insId));
DataTable dt = dtS(searchVal);
if (dt.Rows.Count != 0)
{
string ccType = dt.Rows[0]["IS_PREPAID"].ToString();
string fname = dt.Rows[0]["SUBSCRIBER_FNAME"].ToString();
string admin = dt.Rows[0]["PHONE_NO"].ToString();
string card = dt.Rows[0]["CARD_NO"].ToString();
if (ccType != "2")
{
DataTable dtProd = dbconn.getTable(appServiceQry._getMainProducts("27,28,29,73"));
List <productDetial> prdList = new List <productDetial>();
foreach (DataRow item in dtProd.Rows)
{
productDetial prodDetial = new productDetial();
prodDetial.productName = item["PRODUCT_NAME_MON"].ToString();
prodDetial.productId = item["PRODUCT_ID"].ToString();
prodDetial.smsCode = item["SMS_CODE"].ToString();
prodDetial.productImg = httpUtil.getProductLogoUrl(item["PRODUCT_ID"].ToString());
DataTable dtPrice = dbconn.getTable(appServiceQry._getMainProductPrices(item["PRODUCT_ID"].ToString()));
string priceP = string.Empty;
if (dtPrice.Rows.Count != 0)
{
priceP = dtPrice.Rows[0]["PRICE"].ToString();
}
prodDetial.price = priceP;
prdList.Add(prodDetial);
}
// additional channel list
DataTable dtAct = dbconn.getTable(tabletQuery.getActiveMainProducts(card, "27,28,29,73"));
DataTable dtAdd = new DataTable();
if (dtAct.Rows.Count != 0)
{
string mProd = dtAct.Rows[0]["PRODUCT_ID"].ToString();
dtAdd = dbconn.getTable(appServiceQry._getMainProducts(additionalProductSelector.getAddProd(mProd)));
}
else
{
dtAdd = dbconn.getTable(appServiceQry._getMainProducts(additionalProductSelector.getAddProd("28")));
}
List <productDetial> addChannels = new List <productDetial>();
foreach (DataRow rf in dtAdd.Rows)
{
productDetial prd = new productDetial();
prd.productName = rf["PRODUCT_NAME_MON"].ToString();
prd.productId = rf["PRODUCT_ID"].ToString();
prd.smsCode = rf["SMS_CODE"].ToString();
prd.productImg = httpUtil.getProductLogoUrl(rf["PRODUCT_ID"].ToString());
DataTable dtPrice = dbconn.getTable(appServiceQry._getMainProductPrices(rf["PRODUCT_ID"].ToString()));
string priceP = string.Empty;
if (dtPrice.Rows.Count != 0)
{
priceP = dtPrice.Rows[0]["PRICE"].ToString();
}
prd.price = priceP;
addChannels.Add(prd);
}
response.isSuccess = true;
response.errorCode = Convert.ToString((int)HttpStatusCode.OK);
response.resultMessage = "success";
response.firstName = fname;
response.cardNo = card;
response.adminNo = admin;
response.productList = prdList;
response.additionalProductList = addChannels;
response.ccType = ccType;
}
else
{
response.isSuccess = true;
response.errorCode = Convert.ToString((int)HttpStatusCode.OK);
response.resultMessage = "Дараа төлбөрт хэрэглэгч";
response.firstName = fname;
response.cardNo = card;
response.adminNo = admin;
response.ccType = ccType;
}
}
else
{
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.NotFound);
response.resultMessage = "Хайлтын үр дүн хоосон байна.";
}
}
else
{
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.Unauthorized);
response.resultMessage = "Session has expired";
}
}
else
{
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.InternalServerError);
response.resultMessage = "Internal Error";
}
}
catch (Exception ex)
{
LogWriter._error(TAG, string.Format(@"Token: [{0}], Exception: [{1}]", secToken, ex.ToString()));
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.InternalServerError);
response.resultMessage = ex.Message;
}
message = Request.CreateResponse(HttpStatusCode.OK, response);
LogWriter._chargeProd(TAG, string.Format(@"[<<] ClientIp: [{0}], Response: [{1}]", ip, serializer.Serialize(response)));
return(message);
}
public HttpResponseMessage Get(string productId)
{
HttpResponseMessage message = null;
productAdditionDetial prdAddDetial = new productAdditionDetial();
string token = HttpContext.Current.Request.Headers["Authorization"].Replace("Bearer ", "").Trim();
try
{
if (dbconn.idbCheck(out dbres))
{
string userCardNo = string.Empty;
string userAdminNo = string.Empty;
if (dbconn.checkToken(token, out userCardNo, out userAdminNo))
{
DataTable dtCh = dbconn.getTable(appServiceQry._getMainProducts(productId));
if (dtCh.Rows.Count != 0)
{
//DataTable dtUp = dbconn.getTable(appServiceQry._getMainProducts(dtCh.Rows[0]["UPGRADE_PRODUCTS"].ToString()));
//List<productDetial> upChannels = new List<productDetial>();
//foreach (DataRow dr in dtUp.Rows)
//{
// productDetial upch = new productDetial();
// upch.productName = dr["PRODUCT_NAME_MON"].ToString();
// upch.productId = dr["PRODUCT_ID"].ToString();
// upch.smsCode = dr["SMS_CODE"].ToString();
// upch.productImg = httpUtil.getProductLogoUrl(dr["PRODUCT_ID"].ToString());
// upChannels.Add(upch);
//}
DataTable dtAdd = dbconn.getTable(appServiceQry._getMainProducts(additionalProductSelector.getAddProd(productId)));
List <productDetial> addChannels = new List <productDetial>();
foreach (DataRow rf in dtAdd.Rows)
{
productDetial prd = new productDetial();
prd.productName = rf["PRODUCT_NAME_MON"].ToString();
prd.productId = rf["PRODUCT_ID"].ToString();
prd.smsCode = rf["SMS_CODE"].ToString();
prd.productImg = httpUtil.getProductLogoUrl(rf["PRODUCT_ID"].ToString());
DataTable dtPrice = dbconn.getTable(appServiceQry._getMainProductPrices(rf["PRODUCT_ID"].ToString()));
string priceP = string.Empty;
if (dtPrice.Rows.Count != 0)
{
priceP = dtPrice.Rows[0]["PRICE"].ToString();
}
prd.price = priceP;
addChannels.Add(prd);
}
prdAddDetial.productId = productId;
prdAddDetial.upProducts = null;
prdAddDetial.additionalProducts = addChannels;
prdAddDetial.isSuccess = true;
prdAddDetial.resultCode = HttpStatusCode.OK.ToString();
prdAddDetial.resultMessage = appConstantValues.MSG_SUCCESS;
}
else
{
prdAddDetial.isSuccess = false;
prdAddDetial.resultCode = HttpStatusCode.NotFound.ToString();
prdAddDetial.resultMessage = appConstantValues.MSG_NOFOUND;
}
}
else
{
prdAddDetial.isSuccess = false;
prdAddDetial.resultCode = HttpStatusCode.Unauthorized.ToString();
prdAddDetial.resultMessage = appConstantValues.MSG_EXPIRED;
}
}
else
{
prdAddDetial.isSuccess = false;
prdAddDetial.resultCode = HttpStatusCode.NotFound.ToString();
prdAddDetial.resultMessage = appConstantValues.MSG_INTERNAL_ERROR;
LogWriter._error(TAG, dbres);
}
}
catch (Exception ex)
{
exceptionManager.ManageException(ex, TAG);
prdAddDetial.isSuccess = false;
prdAddDetial.resultCode = HttpStatusCode.NotFound.ToString();
prdAddDetial.resultMessage = ex.Message;
}
message = Request.CreateResponse(HttpStatusCode.OK, prdAddDetial);
LogWriter._channelList(TAG, string.Format("IP: [{0}], Request: [{1}], Response: [{2}], Token: [{3}]", httpUtil.GetClientIPAddress(HttpContext.Current.Request), productId, serialzer.Serialize(prdAddDetial), token));
return(message);
}
public async Task <HttpResponseMessage> Get(string cardNo, string pref)
{
HttpResponseMessage message = new HttpResponseMessage();
string ip = httpUtil.GetClientIPAddress(HttpContext.Current.Request);
string secToken = string.Empty;
additionalProductListResponse response = new additionalProductListResponse();
LogWriter._chargeProd(TAG, string.Format(@"[>>] Request: [Card:{0}, Pref:{1}]", cardNo, pref));
try
{
secToken = HttpContext.Current.Request.Headers["Authorization"].Replace("Basic ", "").Trim();
if (dbconn.idbStatOK())
{
string insId = string.Empty;
string insPhone = string.Empty;
if (dbconn.tabletCheckToken(secToken, out insId, out insPhone))
{
DataTable dtAct = dbconn.getTable(tabletQuery.getActiveMainProducts(cardNo, "27,28,29,73"));
DataTable dtAdd = new DataTable();
if (dtAct.Rows.Count != 0)
{
string mProd = dtAct.Rows[0]["PRODUCT_ID"].ToString();
dtAdd = dbconn.getTable(appServiceQry._getMainProducts(additionalProductSelector.getAddProd(mProd)));
}
else
{
dtAdd = dbconn.getTable(appServiceQry._getMainProducts(additionalProductSelector.getAddProd("28")));
}
List <productDetial> addChannels = new List <productDetial>();
foreach (DataRow rf in dtAdd.Rows)
{
productDetial prd = new productDetial();
prd.productName = rf["PRODUCT_NAME_MON"].ToString();
prd.productId = rf["PRODUCT_ID"].ToString();
prd.smsCode = rf["SMS_CODE"].ToString();
prd.productImg = httpUtil.getProductLogoUrl(rf["PRODUCT_ID"].ToString());
DataTable dtPrice = dbconn.getTable(appServiceQry._getMainProductPrices(rf["PRODUCT_ID"].ToString()));
string priceP = string.Empty;
if (dtPrice.Rows.Count != 0)
{
priceP = dtPrice.Rows[0]["PRICE"].ToString();
}
prd.price = priceP;
addChannels.Add(prd);
}
response.isSuccess = true;
response.errorCode = Convert.ToString((int)HttpStatusCode.OK);
response.resultMessage = "success";
response.productList = addChannels;
}
else
{
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.Unauthorized);
response.resultMessage = "Session has expired";
}
}
else
{
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.InternalServerError);
response.resultMessage = "Internal Error";
}
}
catch (Exception ex)
{
LogWriter._error(TAG, string.Format(@"Token: [{0}], Exception: [{1}]", secToken, ex.ToString()));
response.isSuccess = false;
response.errorCode = Convert.ToString((int)HttpStatusCode.InternalServerError);
response.resultMessage = ex.Message;
}
message = Request.CreateResponse(HttpStatusCode.OK, response);
LogWriter._chargeProd(TAG, string.Format(@"[<<] ClientIp: [{0}], Response: [{1}]", ip, serializer.Serialize(response)));
return(message);
}
