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; }