protected void Page_Load(object sender, EventArgs e)
{
if (Session["basket"] != null)
///read Basket_DataTable from session if exist
Basket_DataTable = (DataTable)Session["basket"];
else
{
//create an empty DataTable and Add some columns to it
Basket_DataTable = new DataTable();
Basket_DataTable.Columns.Add("id");
Basket_DataTable.Columns.Add("name");
Basket_DataTable.Columns.Add("price");
Basket_DataTable.Columns.Add("pic");
Basket_DataTable.Columns.Add("count");
Basket_DataTable.Columns.Add("total");
}
/////////////////////////
if (Request["DelID"] != null)
{
for (int i = 0; i < Basket_DataTable.Rows.Count; i++)
if (Basket_DataTable.Rows[i][0].ToString() == Request["DelID"].ToString())
Basket_DataTable.Rows.Remove(Basket_DataTable.Rows[i]);
}
if (Request["ID"] != null)
{
//search item in DataTable
bool Found = false;
for (int i = 0; i < Basket_DataTable.Rows.Count; i++)
if (Basket_DataTable.Rows[i][0].ToString() == Request["ID"].ToString())
Found = true;
//add to basket
if (Found == false)
{
DataAcess data = new DataAcess();
string sql = "SELECT * FROM Items where id=" + Request["ID"];
DataTable ret= data.exe_select(sql);
if (ret != null && ret.Rows.Count == 1)
{
Basket_DataTable.Rows.Add(new object[] { Request["ID"],ret.Rows[0]["name"].ToString()
,ret.Rows[0]["price"].ToString(),ret.Rows[0]["pic"].ToString()
,"1",ret.Rows[0]["price"].ToString()});
}
}
}
/////////////////////////
if (IsPostBack == false)
{
GridView2.DataSource = Basket_DataTable;
GridView2.DataBind();
}
Session["basket"] = Basket_DataTable;
}
protected void save_Click(object sender, EventArgs e)
{
DataAcess data = new DataAcess();
for (int i = 0; i < GridView2.Rows.Count; i++)
{
String ID = GridView2.Rows[i].Cells[0].Text.ToString(); ;
TextBox Tb = (TextBox)GridView2.Rows[i].FindControl("TextBoxCount");
string sql = "INSERT INTO Basket (count, id)VALUES ({0}, {1})";
sql = string.Format(sql, Tb.Text, ID);
data.exe_cmd(sql);
}
}
// TODO: ADD binary data SP
// LARS: Where do I find the binary data for page attributes? Not clear from API DOC
public void DBGetPageAttributes(string mobile, string inPageName, int gameID)
{
try
{
string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile);
DataSet result = new DataSet();
List <SqlParameter> spParams = new List <SqlParameter>();
spParams.Add(new SqlParameter("@GameID", gameID));
result = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_GetGameNameANDCaption_ByGameID", spParams);
if (result.Tables[0].Rows.Count > 0)
{
GameName = result.Tables[0].Rows[0]["GameName"].ToString();
PageName = inPageName;
Caption = result.Tables[0].Rows[0]["Caption"].ToString();
DataSet aR = new DataSet();
List <SqlParameter> attParams = new List <SqlParameter>();
attParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
attParams.Add(new SqlParameter("@GameID", gameID));
attParams.Add(new SqlParameter("@PageName", PageName));
aR = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_GetPageAttributes", attParams);
if (aR.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < aR.Tables[0].Rows.Count; j++)
{
Attributes pageAttributes = new Attributes();
pageAttributes.TypeName = aR.Tables[0].Rows[j]["TypeName"].ToString();
pageAttributes.ObjectName = aR.Tables[0].Rows[j]["ObjectName"].ToString();
pageAttributes.AttributeName = aR.Tables[0].Rows[j]["AttributeName"].ToString();
pageAttributes.AttributeValue = aR.Tables[0].Rows[j]["AttributeValue"].ToString();
DataSet binaryData = new DataSet();
List <SqlParameter> binaryParams = new List <SqlParameter>();
binaryParams.Add(new SqlParameter("@GameID", gameID));
binaryParams.Add(new SqlParameter("@PageName", PageName));
binaryData = DataAcess.ExecuteQuerySP("TODO", binaryParams);
if (binaryData.Tables[0].Rows.Count > 0)
{
MemoryStream ms = new MemoryStream((byte[])binaryData.Tables[0].Rows[0]["attributeBinaryData"]);
byte[] bytes = ms.ToArray();
pageAttributes.AttributeValueBinary = bytes;
}
else
{
pageAttributes.AttributeValueBinary = null;
}
listAttributes.Add(pageAttributes);
}
}
//ELSE: There are no attributes for a given pageNumber
else
{
RemoveData();
}
}
else
{
RemoveData();
}
}
catch (SqlException ex)
{
string errorMessage = ex.Message;
RemoveData();
}
}
public void DBGetGameInfoForPromotion(string mobile, int gameID, string gameToken)
{
try
{
string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile);
DataSet result = new DataSet();
List <SqlParameter> spParams = new List <SqlParameter>();
spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
spParams.Add(new SqlParameter("@GameID", gameID));
spParams.Add(new SqlParameter("@GameToken", gameToken));
result = DataAcess.ExecuteQuerySP("PEC.MG_", spParams);
if (result.Tables[0].Rows.Count > 0)
{
variantID = Convert.ToInt32(result.Tables[0].Rows[0]["VariantID"].ToString());
gameNameForDisplay = result.Tables[0].Rows[0]["GameName"].ToString();
playInstructions = result.Tables[0].Rows[0]["PlayInstructions"].ToString();
gameType = result.Tables[0].Rows[0]["GameType"].ToString();
DataSet gameDS = new DataSet();
List <SqlParameter> gParams = new List <SqlParameter>();
gParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
gParams.Add(new SqlParameter("@GameID", gameID));
gParams.Add(new SqlParameter("@VariantID", variantID));
gameDS = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTIONS_GetGameObjects", gParams);
for (int i = 0; i < gameDS.Tables[0].Rows.Count; i++)
{
GameObject newObject = new GameObject();
newObject.ObjectName = gameDS.Tables[0].Rows[i]["ObjectName"].ToString();
newObject.ObjectID = Convert.ToInt32(gameDS.Tables[0].Rows[i]["ObjectID"].ToString());
newObject.GOAttributeName = gameDS.Tables[0].Rows[i]["AttributeName"].ToString();
newObject.GOAttributeValue = gameDS.Tables[0].Rows[i]["AttributeValue"].ToString();
DataSet imageData = new DataSet();
List <SqlParameter> imageParam = new List <SqlParameter>();
imageParam.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
imageParam.Add(new SqlParameter("@GameID", gameID));
imageParam.Add(new SqlParameter("@VariantID", variantID));
imageData = DataAcess.ExecuteQuerySP("MG_PROMOTION_GameObjectGetImage", imageParam);
if (imageData.Tables[0].Rows.Count > 0)
{
MemoryStream ms = new MemoryStream((byte[])imageData.Tables[0].Rows[0]["GameObjectAttributeBinary"]);
byte[] bytes = ms.ToArray();
newObject.GOAttributeValueBinary = bytes;
}
else
{
newObject.GOAttributeValueBinary = null;
}
GameObjects.Add(newObject);
}
}
else
{
throw new Exception("No data");
}
}
catch (Exception)
{
RemoveData();
}
}
public DAEContractExecute()
{
_da = Common.GetProjectDataAcess.GetDataAcess();
}
//SQL DB Function to get games wrapper from DB
public void DBGetGamesScreenWrapper(string mobile)
{
try
{
string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile);
DataSet headerDS = new DataSet();
List <SqlParameter> headerParams = new List <SqlParameter>();
headerParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
headerDS = DataAcess.ExecuteQuerySP("PEC.", headerParams);
if (headerDS.Tables[0].Rows.Count > 0)
{
headerCaption = headerDS.Tables[0].Rows[0]["HeaderCaption"].ToString();
headerData = headerDS.Tables[0].Rows[0]["HeaderData"].ToString();
}
DataSet result = new DataSet();
List <SqlParameter> spParams = new List <SqlParameter>();
spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
result = DataAcess.ExecuteQuerySP("PEC.PROMOTION_ID_GetByCMSPlayerID", spParams);
if (result.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < result.Tables[0].Rows.Count; i++)
{
PromotionID.Add(Int64.Parse(result.Tables[0].Rows[i]["PromotionID"].ToString()));
}
foreach (long ID in PromotionID)
{
//GET Game Attributes from GD_PROMOtionGames
DataSet ds = new DataSet();
List <SqlParameter> gameParams = new List <SqlParameter>();
gameParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
gameParams.Add(new SqlParameter("@PromotionID", ID));
ds = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_WRAPPER_GetByPromotionID", gameParams);
DataSet imageSet = new DataSet();
if (ds.Tables[0].Rows.Count > 0)
{
Game newGame = new Game();
newGame.GameID = ds.Tables[0].Rows[0]["GameID"].ToString();
newGame.GameName = ds.Tables[0].Rows[0]["GameName"].ToString();
newGame.GameDescription = ds.Tables[0].Rows[0]["GameDescription"].ToString();
newGame.ButtonDescription = ds.Tables[0].Rows[0]["ButtonDesc"].ToString();
newGame.IsButtonEnabled = Convert.ToBoolean(ds.Tables[0].Rows[0]["isButtonEnabled"].ToString());
DataSet imageData = new DataSet();
List <SqlParameter> imageParam = new List <SqlParameter>();
imageParam.Add(new SqlParameter("@PromotionID", ID));
imageData = DataAcess.ExecuteQuerySP("MG_PROMOTION_WRAPPER_ReadGameIcon", imageParam);
if (imageData.Tables[0].Rows.Count > 0)
{
MemoryStream ms = new MemoryStream((byte[])imageData.Tables[0].Rows[0]["promoKioskImage"]);
byte[] bytes = ms.ToArray();
newGame.GameIcon = bytes;
}
else
{
newGame.GameIcon = null;
}
Games.Add(newGame);
}
}
}
}
catch (SqlException ex)
{
RemoveData();
string errorMessage = ex.Message;
}
}
public void DBClaimBonusCoupons(string mobile, int promotionID)
{
try
{
PromotionID = promotionID;
string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile);
DataSet result = new DataSet();
List <SqlParameter> spParams = new List <SqlParameter>();
spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
spParams.Add(new SqlParameter("@PromotionID", PromotionID));
result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams);
if (result.Tables[0].Rows.Count > 0)
{
ClaimButtonRemainsVisible = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString());
ClaimButtonRemainsActive = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString());
ClaimButtonNewCaption = result.Tables[0].Rows[0][""].ToString();
MemoryStream ms = new MemoryStream((byte[])result.Tables[0].Rows[0]["Image"]);
byte[] bytes = ms.ToArray();
ClaimButtonNewImage = bytes;
DataSet descDS = new DataSet();
List <SqlParameter> descParams = new List <SqlParameter>();
descParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
descParams.Add(new SqlParameter("@PromotionID", PromotionID));
descDS = DataAcess.ExecuteQuerySP("PEC.TODO", descParams);
if (descDS.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < descDS.Tables[0].Rows.Count; i++)
{
ResultDescriptionBonus newRDB = new ResultDescriptionBonus();
newRDB.ResultCaption = descDS.Tables[0].Rows[i][""].ToString();
newRDB.ResultUpdatedElement = descDS.Tables[0].Rows[i][""].ToString();
MemoryStream msResult = new MemoryStream((byte[])descDS.Tables[0].Rows[i]["Image"]);
byte[] resultBytes = msResult.ToArray();
newRDB.ResultImage = resultBytes;
DataSet dP = new DataSet();
List <SqlParameter> pointsParams = new List <SqlParameter>();
pointsParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
pointsParams.Add(new SqlParameter("@PromotionID", PromotionID));
dP = DataAcess.ExecuteQuerySP("PEC.TODO", pointsParams);
if (dP.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dP.Tables[0].Rows.Count; j++)
{
DataPoint newPoint = new DataPoint();
newPoint.DataPointCaption = dP.Tables[0].Rows[i]["DataPointCaption"].ToString();
newPoint.DataPointData = dP.Tables[0].Rows[i]["DataPointData"].ToString();
newRDB.DataPoints.Add(newPoint);
}
}
else
{
newRDB.DataPoints = null;
}
}
}
else
{
ResultDescriptions = null;
}
}
else
{
RemoveData();
}
}
catch (SqlException ex)
{
string errorMessage = ex.Message;
RemoveData();
}
}
private void Form2_Load(object sender, EventArgs e)
{
RestaurantsGrid.DataSource = DataAcess.AcessRestaurantsFound();
}
//DB Get Promotion List
public void DBGetPromotionList(string mobile)
{
try
{
string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile);
DataSet ds = new DataSet();
List <SqlParameter> spParams = new List <SqlParameter>();
spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
ds = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetPromotionList_ByCMSPlayerID", spParams);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Promotion newPromo = new Promotion();
newPromo.PromotionID = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.PromoVersionID = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.GameID = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.PromotionName = ds.Tables[0].Rows[i][""].ToString();
newPromo.StartDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""].ToString());
newPromo.EndDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""].ToString());
newPromo.Enrolled = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.CouponsAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.NextDrawingDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""].ToString());
newPromo.CheckInAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.CheckInStatusMessage = ds.Tables[0].Rows[i][""].ToString();
newPromo.FreeEntryAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.RemoteEntryAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.PointsToDate = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.EntriesToDate = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.PointsPerEntry = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.TodaysPoint = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.DailyEntryLImit = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.ThresholdType = ds.Tables[0].Rows[i][""].ToString();
newPromo.ThresholdPoints = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString());
newPromo.PrizeName = ds.Tables[0].Rows[i][""].ToString();
newPromo.ThresholdReached = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.PrizeClaimed = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.GameAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
newPromo.RaffleAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString());
DataSet raffleDS = new DataSet();
List <SqlParameter> raffleParams = new List <SqlParameter>();
raffleParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
raffleDS = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetPromotionRaffleTickets", raffleParams);
if (raffleDS.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < raffleDS.Tables[0].Rows.Count; j++)
{
RaffleTicketList newRaffleTicket = new RaffleTicketList();
newRaffleTicket.RaffleTicket = raffleDS.Tables[0].Rows[j][""].ToString();
newPromo.RaffleTickets.Add(newRaffleTicket);
}
}
else
{
newPromo.RaffleTickets = null;
}
DataSet imageDS = new DataSet();
List <SqlParameter> imageParams = new List <SqlParameter>();
imageParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID));
imageDS = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetPromotionImage", imageParams);
if (imageDS.Tables[0].Rows.Count > 0)
{
MemoryStream ms = new MemoryStream((byte[])imageDS.Tables[0].Rows[0]["Image"]);
byte[] bytes = ms.ToArray();
newPromo.PromotionImage = bytes;
}
else
{
newPromo.PromotionImage = null;
}
Promotions.Add(newPromo);
}
}
else
{
RemoveData();
}
}
catch (SqlException ex)
{
string errorMessage = ex.Message;
RemoveData();
}
}
public DataTable buscarCategoriaManual(RegistroModel eo)
{
DataTable categorizacaoManual = new DataTable();
DataAcess dataAcces = new DataAcess();
String sql = "";
try
{
if (!string.IsNullOrEmpty(eo.CONDICAO_NOME_CLIENTE))
{
dataAcces.AddInParameter("@DS_CONDICAO_COMPANY", eo.CONDICAO_NOME_CLIENTE);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_COMPANY", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_SERVICO))
{
dataAcces.AddInParameter("@DS_CONDICAO_SERVICO", eo.CONDICAO_SERVICO);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_SERVICO", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_ITEM))
{
dataAcces.AddInParameter("@DS_CONDICAO_ITEM", eo.CONDICAO_ITEM);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_ITEM", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_SUB_ITEM))
{
dataAcces.AddInParameter("@DS_CONDICAO_SUB_ITEM", eo.CONDICAO_SUB_ITEM);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_SUB_ITEM", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_TITULO))
{
dataAcces.AddInParameter("@DS_CONDICAO_TITULO", eo.CONDICAO_TITULO);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_TITULO", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_DESCRICAO))
{
dataAcces.AddInParameter("@DS_CONDICAO_DESCRICAO", eo.CONDICAO_DESCRICAO);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_DESCRICAO", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_TIPO_REQUISICAO))
{
dataAcces.AddInParameter("@DS_CONDICAO_TIPO_REQUISICAO", eo.CONDICAO_TIPO_REQUISICAO);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_TIPO_REQUISICAO", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_IMPACTO_FINANCEIRO))
{
dataAcces.AddInParameter("@DS_CONDICAO_IMPACTO_FINANCEIRO", eo.CONDICAO_IMPACTO_FINANCEIRO);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_IMPACTO_FINANCEIRO", DBNull.Value);
}
if (!string.IsNullOrEmpty(eo.CONDICAO_IMPACTO_NEGOCIO))
{
dataAcces.AddInParameter("@DS_CONDICAO_IMPACTO_NEGOCIO", eo.CONDICAO_IMPACTO_NEGOCIO);
}
else
{
dataAcces.AddInParameter("@DS_CONDICAO_IMPACTO_NEGOCIO", DBNull.Value);
}
sql = @"Select CM.* from TB_CATEGORIZACAO_MANUAL_PAINEL CM WHERE CM.IN_STATUS = 1 AND
(
--1
((CM.DS_TIPO_COMPARACAO_TITULO = 'Igual' and CM.DS_CONDICAO_TITULO = @DS_CONDICAO_TITULO) or
(CM.DS_TIPO_COMPARACAO_TITULO = 'Contém' and CM.DS_CONDICAO_TITULO like '%' + replace(@DS_CONDICAO_TITULO,'[','[[]') +'%'))
and CM.DS_CONDICAO_COMPANY = @DS_CONDICAO_COMPANY
and CM.DS_CONDICAO_SERVICO = @DS_CONDICAO_SERVICO
and CM.DS_CONDICAO_ITEM = @DS_CONDICAO_ITEM
and CM.DS_CONDICAO_SUB_ITEM = @DS_CONDICAO_SUB_ITEM
and CM.DS_CONDICAO_TIPO_REQUISICAO = @DS_CONDICAO_TIPO_REQUISICAO
and CM.DS_CONDICAO_IMPACTO_FINANCEIRO = @DS_CONDICAO_IMPACTO_FINANCEIRO
and CM.DS_CONDICAO_IMPACTO_NEGOCIO = @DS_CONDICAO_IMPACTO_NEGOCIO
and ((CM.DS_TIPO_COMPARACAO_DESCRICAO = 'Igual' and CM.DS_CONDICAO_DESCRICAO = @DS_CONDICAO_DESCRICAO) or
(CM.DS_TIPO_COMPARACAO_DESCRICAO = 'Contém' and DS_CONDICAO_DESCRICAO like '%' + replace(@DS_CONDICAO_DESCRICAO,'[','[[]') +'%'))
)";
return(dataAcces.GetDataTable(sql));
}
catch (Exception ex)
{
logErro(eo.ID_TRBTKT_FROM_PAINEL, eo.DS_CALL, "Banco de dados, Messagem: " + ex.Message, "", "", sql);
return(null);
}
}
public void atualizarRegistro(RegistroModel registro, String descricaoStatus, int status)
{
DataAcess dataAcces = new DataAcess();
String sql = @"UPDATE TB_TRBTKT_FROM_PAINEL
SET ID_CATEGORY_MANUAL = @ID_CATEGORY_MANUAL,
RESULTADO_SERVICO = @RESULTADO_SERVICO,
RESULTADO_CATEGORIA = @RESULTADO_CATEGORIA,
RESULTADO_SUBCATEGORIA = @RESULTADO_SUBCATEGORIA,
RESULTADO_TIPOPRODUTO = @RESULTADO_TIPOPRODUTO,
RESULTADO_SINTOMA = @RESULTADO_SINTOMA,
RESULTADO_GRUPO = @RESULTADO_GRUPO,
LOG_RESULTADO = @LOG_RESULTADO,
RESULTADO_IMPACTO = @RESULTADO_IMPACTO,
RESULTADO_URGENCIA = @RESULTADO_URGENCIA,
STATUS_REGISTRO = @STATUS_REGISTRO
WHERE ID_TRBTKT_FROM_PAINEL = @ID_TRBTKT_FROM_PAINEL";
try
{
if (registro.ID_CATEGORY_MANUAL != int.MinValue)
{
dataAcces.AddInParameter("@ID_CATEGORY_MANUAL", registro.ID_CATEGORY_MANUAL);
}
else
{
dataAcces.AddInParameter("@ID_CATEGORY_MANUAL", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_SERVICO))
{
dataAcces.AddInParameter("@RESULTADO_SERVICO", registro.RESULTADO_SERVICO);
}
else
{
dataAcces.AddInParameter("@RESULTADO_SERVICO", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_CATEGORIA))
{
dataAcces.AddInParameter("@RESULTADO_CATEGORIA", registro.RESULTADO_CATEGORIA);
}
else
{
dataAcces.AddInParameter("@RESULTADO_CATEGORIA", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_SUBCATEGORIA))
{
dataAcces.AddInParameter("@RESULTADO_SUBCATEGORIA", registro.RESULTADO_SUBCATEGORIA);
}
else
{
dataAcces.AddInParameter("@RESULTADO_SUBCATEGORIA", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_TIPOPRODUTO))
{
dataAcces.AddInParameter("@RESULTADO_TIPOPRODUTO", registro.RESULTADO_TIPOPRODUTO);
}
else
{
dataAcces.AddInParameter("@RESULTADO_TIPOPRODUTO", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_SINTOMA))
{
dataAcces.AddInParameter("@RESULTADO_SINTOMA", registro.RESULTADO_SINTOMA);
}
else
{
dataAcces.AddInParameter("@RESULTADO_SINTOMA", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_GRUPO))
{
dataAcces.AddInParameter("@RESULTADO_GRUPO", registro.RESULTADO_GRUPO);
}
else
{
dataAcces.AddInParameter("@RESULTADO_GRUPO", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_IMPACTO))
{
dataAcces.AddInParameter("@RESULTADO_IMPACTO", registro.RESULTADO_IMPACTO);
}
else
{
dataAcces.AddInParameter("@RESULTADO_IMPACTO", DBNull.Value);
}
if (!string.IsNullOrEmpty(registro.RESULTADO_URGENCIA))
{
dataAcces.AddInParameter("@RESULTADO_URGENCIA", registro.RESULTADO_URGENCIA);
}
else
{
dataAcces.AddInParameter("@RESULTADO_URGENCIA", DBNull.Value);
}
if (!string.IsNullOrEmpty(descricaoStatus))
{
dataAcces.AddInParameter("@LOG_RESULTADO", descricaoStatus);
}
else
{
dataAcces.AddInParameter("@LOG_RESULTADO", DBNull.Value);
}
dataAcces.AddInParameter("@STATUS_REGISTRO", status);
dataAcces.AddInParameter("@ID_TRBTKT_FROM_PAINEL", registro.ID_TRBTKT_FROM_PAINEL);
dataAcces.Execute(sql);
}
catch (Exception ex)
{
logErro(registro.ID_TRBTKT_FROM_PAINEL, registro.DS_CALL, "Banco de dados, Messagem: " + ex.Message, "", "", sql);
}
}
public DAEDesktop()
{
_da = GetProjectDataAcess.GetDataAcess();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["basket"] != null)
{
///read Basket_DataTable from session if exist
Basket_DataTable = (DataTable)Session["basket"];
}
else
{
//create an empty DataTable and Add some columns to it
Basket_DataTable = new DataTable();
Basket_DataTable.Columns.Add("id");
Basket_DataTable.Columns.Add("name");
Basket_DataTable.Columns.Add("price");
Basket_DataTable.Columns.Add("pic");
Basket_DataTable.Columns.Add("count");
Basket_DataTable.Columns.Add("total");
}
/////////////////////////
if (Request["DelID"] != null)
{
for (int i = 0; i < Basket_DataTable.Rows.Count; i++)
{
if (Basket_DataTable.Rows[i][0].ToString() == Request["DelID"].ToString())
{
Basket_DataTable.Rows.Remove(Basket_DataTable.Rows[i]);
}
}
}
if (Request["ID"] != null)
{
//search item in DataTable
bool Found = false;
for (int i = 0; i < Basket_DataTable.Rows.Count; i++)
{
if (Basket_DataTable.Rows[i][0].ToString() == Request["ID"].ToString())
{
Found = true;
}
}
//add to basket
if (Found == false)
{
DataAcess data = new DataAcess();
string sql = "SELECT * FROM Items where id=" + Request["ID"];
DataTable ret = data.exe_select(sql);
if (ret != null && ret.Rows.Count == 1)
{
Basket_DataTable.Rows.Add(new object[] { Request["ID"], ret.Rows[0]["name"].ToString()
, ret.Rows[0]["price"].ToString(), ret.Rows[0]["pic"].ToString()
, "1", ret.Rows[0]["price"].ToString() });
}
}
}
/////////////////////////
if (IsPostBack == false)
{
GridView2.DataSource = Basket_DataTable;
GridView2.DataBind();
}
Session["basket"] = Basket_DataTable;
}
