public bool update(SectorDTO oSector) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_sector_update"; sqlCmd.Parameters.AddWithValue("@IdSector", oSector.idSector); sqlCmd.Parameters.AddWithValue("@DsSector", oSector.dsSector); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
public int insert(string pDsCategory) { int iReturn = 0; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_category_insert"; sqlCmd.Parameters.AddWithValue("@DsCategory", pDsCategory); iReturn = sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(iReturn); }
public bool delete(int pIdRange) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_range_delete"; sqlCmd.Parameters.AddWithValue("@dRange", pIdRange); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
public bool delTradeCategories(int pidCategory, int pidRange, int pidSector) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_tradeCategory_delete"; sqlCmd.Parameters.AddWithValue("@IdCategory", pidCategory); sqlCmd.Parameters.AddWithValue("@IdRange", pidRange); sqlCmd.Parameters.AddWithValue("@IdSector", pidSector); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
public int insert(RangeDTO oRange) { int iReturn = 0; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_range_insert"; sqlCmd.Parameters.AddWithValue("@FirstValue", oRange.firstValue.ToString()); sqlCmd.Parameters.AddWithValue("@LastValue", oRange.lastValue.ToString()); iReturn = sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(iReturn); }
public IEnumerable <string> GetCityProjectNames(string city) { DBLibrary db = new DBLibrary(_connectionString); Thread.Sleep(10); var cityClause = string.IsNullOrEmpty(city) ? "" : string.Format(" and city = '{0}'", city); var query = string.Format("select distinct project_name from rent_data where project_name is not null{0}", cityClause); var ds = db.ExecuteQuery(query); List <string> list = new List <string>(ds.Tables["Table"].Rows.Count); list = ds.Tables["Table"].AsEnumerable().Select(r => r["project_name"].ToString() ).ToList(); var generic = list.Where(i => i.Contains("esidential")).ToList(); foreach (var item in generic) { list.Remove(item); } return(list); }
public int insert(TradeDTO oTrade) { int iReturn = 0; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_trade_insert"; sqlCmd.Parameters.AddWithValue("@IdCliente", oTrade.idCliente.ToString()); sqlCmd.Parameters.AddWithValue("@TradeValue", oTrade.tradeValue); sqlCmd.Parameters.AddWithValue("@IdSector", oTrade.idSector.ToString()); iReturn = sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(iReturn); }
public bool update(TradeDTO oTrade) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_trade_update"; sqlCmd.Parameters.AddWithValue("@IdTrade", oTrade.idTrade); sqlCmd.Parameters.AddWithValue("@TradeValue", oTrade.tradeValue); sqlCmd.Parameters.AddWithValue("@IdSector", oTrade.idSector.ToString()); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
private void fillDetails() { try { DataSet ds = DBLibrary.GetStageCustomerProcess(); ddlStage.DataSource = ds.Tables[0]; ddlStage.DataTextField = "StageName"; ddlStage.DataValueField = "StageID"; ddlStage.DataBind(); ddlStage.Items.Insert(0, new ListItem("ALL", "0")); ddlProcess.DataSource = ds.Tables[1]; ddlProcess.DataTextField = "ProcessName"; ddlProcess.DataValueField = "ProcessID"; ddlProcess.DataBind(); ddlProcess.Items.Insert(0, new ListItem("ALL", "0")); } catch (Exception ex) { bool rethrow = false; rethrow = UserInterfaceExceptionHandler.HandleExcetion(ref ex); ShowMessage(ex.Message); } }
public IEnumerable <PropertyRentServiceTrimmedDto> TestRents(string numrec) { DBLibrary db = new DBLibrary(_connectionString); var query = string.Format("select top {1} * from rent_data where city = '{0}'", "Pune", numrec); var ds = db.ExecuteQuery(query); //var list = ds.Tables["Table"].ToList<PropertyRentServiceDto>(); List <PropertyRentServiceDto> list = new List <PropertyRentServiceDto>(ds.Tables["Table"].Rows.Count); foreach (DataRow dr in ds.Tables["Table"].Rows) { var dto = ConvertPropertyRentDataRowToServiceDto(dr); list.Add(dto); } var testList = list.Select(i => new PropertyRentServiceTrimmedDto { property_id = i.property_id, bed_rooms = i.bed_rooms, floor_number = null, possession_from = i.possession_from, added_on = i.added_on, last_updated = i.last_updated }); return(testList); }
public IEnumerable <PropertyAverageRentDto> GetCityCurrentAverageRents(string city, string area, string project) { DBLibrary db = new DBLibrary(_connectionString); Thread.Sleep(10); var dateToday = DateTime.Today; var dateStart = dateToday.AddDays(-100); var dateEnd = dateToday.AddDays(100); var dateRange = string.Format("possession_from between '{0}' and '{1}'", dateStart.ToString("yyyy-MM-dd"), dateEnd.ToString("yyyy-MM-dd")); var cityClause = string.Format(" and city = '{0}'", city); var areaClause = string.IsNullOrEmpty(area) ? "" : string.Format(" and area_name = '{0}'", area); var projectClause = string.IsNullOrEmpty(project) ? "" : string.Format(" and project_name = '{0}'", project); var query = string.Format("select avg(rent_monthly) rent, unit_type from rent_data where {0} {1}{2}{3} group by unit_type", dateRange, cityClause, areaClause, projectClause); var ds = db.ExecuteQuery(query); List <PropertyAverageRentDto> list = new List <PropertyAverageRentDto>(ds.Tables["Table"].Rows.Count); list = ds.Tables["Table"].AsEnumerable().Select(r => new PropertyAverageRentDto { unit_type = r["unit_type"].ToString(), avg_rent_monthly = Utilities.GetNullableInt(r["rent"].ToString()) } ).ToList(); return(list); }
public bool update(RangeDTO oRange) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_range_update"; sqlCmd.Parameters.AddWithValue("@IdRange", oRange.idRange.ToString()); sqlCmd.Parameters.AddWithValue("@FirstValue", oRange.firstValue.ToString()); sqlCmd.Parameters.AddWithValue("@LastValue", oRange.lastValue.ToString()); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
public bool update(CategoryDTO pDtoCategory) { bool bReturn = false; SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_category_update"; sqlCmd.Parameters.AddWithValue("@IdCategory", pDtoCategory.idCategory); sqlCmd.Parameters.AddWithValue("@DsCategory", pDtoCategory.dsCategory); sqlCmd.ExecuteNonQuery(); bReturn = true; } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(bReturn); }
/// <summary> /// Gets the equity order detail from database /// </summary> /// <param name="orderExchangeRef">order reference to get details for</param> /// <returns>true if record found, false otherwise</returns> private bool GetOrderRecordFromDatabase(string orderExchangeRef) { bool doesOrderRecordExist = false; DBLibrary dbLib = new DBLibrary(); DBUtilities dbUtilities = new DBUtilities(); try { ArrayList paramList = new ArrayList { dbUtilities.CreateSqlParamater("@orderRef", SqlDbType.VarChar, 50, ParameterDirection.Input, orderExchangeRef) }; // Query the database for an orderRecord with given orderRecordId DataSet ds = dbLib.ExecuteProcedureDS("sp_select_st_derivatives_orderbook", paramList); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; // Get StockOrderBookRecord data OrderDate = DateTime.Parse(dr["order_date"].ToString()); ContractName = dr["contract_name"].ToString(); Direction = (OrderDirection)Enum.Parse(typeof(OrderDirection), dr["direction"].ToString()); Quantity = int.Parse(dr["qty"].ToString()); Price = double.Parse(dr["price"].ToString()); OrderRefenceNumber = dr["order_ref"].ToString(); Exchange = (Exchange)Enum.Parse(typeof(Exchange), dr["exchange"].ToString()); OrderStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), dr["order_status"].ToString()); OpenQty = int.Parse(dr["qty_open"].ToString()); ExecutedQty = int.Parse(dr["qty_executed"].ToString()); ExpiredQty = int.Parse(dr["qty_expired"].ToString()); CancelledQty = int.Parse(dr["qty_cancelled"].ToString()); StopLossPrice = double.Parse(dr["stoploss_price"].ToString()); UpdatedAt = DateTime.Parse(dr["status_update_time"].ToString()); AlgoId = int.Parse(dr["algo_id"].ToString()); doesOrderRecordExist = true; } } } catch (Exception ex) { // If we failed, trace the error for log analysis Logger.LogException(ex); throw; } return(doesOrderRecordExist); }
private void btn_login_Click(object sender, EventArgs e) { //txtBox_userid txtBox_passWd string uname = this.txtBox_userid.Text.Trim(); string pwd = UserMd5(txtBox_passWd.Text.TrimEnd().TrimStart()); SqlConnection sqlcon = DBLibrary.getConn("119.23.174.4", "LR", "lr", "lr123456"); // SqlConnection sqlcon = DBLibrary.getConn("192.168.0.150", "HSLR", "sa", "abc@123");//正式服务器 sqlcon.Open(); //打开数据库连接 SqlCommand cmd = new SqlCommand(); //创建SqlCommand对象 cmd.Connection = sqlcon; //用sqlCon初始化SqlCommand对象 cmd.CommandText = "select * from ES_User where UserLogin='******' and UserPwd='" + pwd + "'"; SqlDataReader sqlDr = cmd.ExecuteReader(); //创建SqlDataReader对象 Configuration cfa = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); if (checkBox1.Checked) { cfa.AppSettings.Settings["rememberme"].Value = "true"; cfa.AppSettings.Settings["name"].Value = uname; cfa.AppSettings.Settings["password"].Value = txtBox_passWd.Text; cfa.Save(); } else { cfa.AppSettings.Settings["rememberme"].Value = "false"; cfa.AppSettings.Settings["name"].Value = ""; cfa.AppSettings.Settings["password"].Value = ""; } cfa.Save(); if (sqlDr.Read()) //帐号和密码正确 { MainForm mForm = new MainForm(); this.Visible = false; mForm.ShowDialog(); this.Dispose(); this.Close(); } else //帐号或密码错误 { MessageBox.Show("用户或密码不正确,请重新输入!"); txtBox_passWd.Text = ""; } sqlcon.Close(); }
/// <summary> /// Persists the TradeRecord record in database /// </summary> private void InsertIntoDatabase() { // Must be a new tradeRecord to insert, Throw an exception if existing tradeRecord is tried to insert if (!_isNewTradeRecord) { throw new InvalidOperationException("TradeRecord Id: " + OrderRefenceNumber + "already exists in the System"); } DBLibrary dbLib = new DBLibrary(); dbLib.ExecuteProcedure("sp_insert_st_derivatives_tradebook", DbParamList(0)); // Now it is no more a new tradeRecord as it is entered into the system _isNewTradeRecord = false; }
public IEnumerable <string> GetAllCityNames() { DBLibrary db = new DBLibrary(_connectionString); Thread.Sleep(10); var query = string.Format("select distinct city from rent_data where city is not null"); var ds = db.ExecuteQuery(query); List <string> list = new List <string>(ds.Tables["Table"].Rows.Count); list = ds.Tables["Table"].AsEnumerable().Select(r => r["city"].ToString() ).ToList(); return(list); }
public void GridProcessBind() { DataTable dtWip = DBLibrary.GetWIPDetails(Convert.ToInt32(ddlStage.SelectedValue), Convert.ToInt32(ddlProcess.SelectedValue)); GVChangeProcess.DataSource = dtWip; GVChangeProcess.DataBind(); if (dtWip.Rows.Count > 0) { //btnUpdate.Visible = true; Export_Link.Visible = true; } else { //btnUpdate.Visible = false; Export_Link.Visible = false; } }
public static bool DoesExistEOPStatsForMinMaxAlgos(string contractName, short algoId, double marketDirection, string r1, string r2) { //EOPTradeStats eopTradeStats = null; DBUtilities dbUtilities = new DBUtilities(); DBLibrary dbLib = new DBLibrary(""); ArrayList paramList = new ArrayList { dbUtilities.CreateSqlParamater("@contract_name", SqlDbType.VarChar, 100, ParameterDirection.Input, contractName), dbUtilities.CreateSqlParamater("@market_direction_percentage", SqlDbType.Decimal, ParameterDirection.Input, marketDirection), dbUtilities.CreateSqlParamater("@algo_id", SqlDbType.SmallInt, ParameterDirection.Input, algoId) }; var param = dbUtilities.CreateSqlParamater("@r1", SqlDbType.VarChar, 100, ParameterDirection.Input, r1); param.IsNullable = true; param.Value = param.Value ?? DBNull.Value; paramList.Add(param); param = dbUtilities.CreateSqlParamater("@r2", SqlDbType.VarChar, 100, ParameterDirection.Input, r2); param.IsNullable = true; param.Value = param.Value ?? DBNull.Value; paramList.Add(param); // Query the database DataSet ds = dbLib.ExecuteProcedureDS("sp_select_st_trading_eop_statsbook", paramList); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(true); } return(false); }
public IEnumerable <string> GetCityAreaNames(string city) { DBLibrary db = new DBLibrary(_connectionString); Thread.Sleep(10); var cityClause = string.IsNullOrEmpty(city) ? "" : string.Format(" and city = '{0}'", city); var query = string.Format("select distinct area_name from rent_data where area_name is not null{0}", cityClause); var ds = db.ExecuteQuery(query); List <string> list = new List <string>(ds.Tables["Table"].Rows.Count); list = ds.Tables["Table"].AsEnumerable().Select(r => r["area_name"].ToString() ).ToList(); return(list); }
public List <TradeCategoryDTO> GetTradeCategoriesByRange(int pidRange) { List <TradeCategoryDTO> oReturn = new List <TradeCategoryDTO>(); SqlConnection sqlCon = DBLibrary.OpenConnection(); try { using (sqlCon = DBLibrary.OpenConnection()) { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = MontaStringSql(0, pidRange, 0); var oData = sqlCmd.ExecuteReader(); while (oData.Read() == true) { TradeCategoryDTO oTrade = new TradeCategoryDTO(); oTrade.idCategory = int.Parse(oData["idTrade"].ToString()); oTrade.dsCategory = oData["dsCategory"].ToString(); oTrade.idRange = int.Parse(oData["idCliente"].ToString()); oTrade.idSector = int.Parse(oData["idSector"].ToString()); oTrade.dsSector = oData["dsSector"].ToString(); oReturn.Add(oTrade); } } } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(oReturn); }
protected void btnSaveVideo_Click(object sender, EventArgs e) { GetId(); PNK_UploadImage productcatObj = new PNK_UploadImage(); Generic <PNK_UploadImage> genericBLL = new Generic <PNK_UploadImage>(); //Get max id medical_product DBLibrary db = new DBLibrary(); productId = db.Timso_int("SELECT TOP 1 id FROM PNK_Product mp order by id desc") + 1; productimageID = db.Timso_int("SELECT TOP 1 ProductID FROM [PNK_UploadImage] mp where ProductID=" + imageID + " And Name='Youtube' "); //Update if (productimageID != 0) { DBHelper.ExcuteNonQuery("Update PNK_UploadImage set Name=" + "'Youtube',ImagePath=" + "'" + txtID.Value + "' Where ProductID=" + imageID + " ", null); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), string.Format("jAlert('{0}','Message');", Constant.UI.admin_msg_save_success), true); } else//Insert { productcatObj.Published = "1"; productcatObj.Updatedate = DateTime.Now; productcatObj.Name = "Youtube"; productcatObj.ImagePath = txtID.Value; productcatObj.ProductId = imageID == int.MinValue ? productId : imageID; productcatObj.PostDate = DateTime.Now; productcatObj.Ordering = genericBLL.getOrdering(); //excute if (genericBLL.Insert(productcatObj) != int.MinValue) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), string.Format("jAlert('{0}','Message');", Constant.UI.admin_msg_save_success), true); } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), string.Format("jAlert('{0}','Message');", Constant.UI.admin_msg_save_fail), true); } Session["ID"] = productId; } }
public IEnumerable <PropertyRentServiceDto> GetRents(string city, string numrec) { DBLibrary db = new DBLibrary(_connectionString); var query = string.Format("select top {1} * from rent_data where city = '{0}'", city, numrec); var ds = db.ExecuteQuery(query); //var list = ds.Tables["Table"].ToList<PropertyRentServiceDto>(); List <PropertyRentServiceDto> list = new List <PropertyRentServiceDto>(ds.Tables["Table"].Rows.Count); foreach (DataRow dr in ds.Tables["Table"].Rows) { var dto = ConvertPropertyRentDataRowToServiceDto(dr); list.Add(dto); } return(list); //var only5 = list.Take(1); //return only5; }
public Dictionary <string, CityMetadataDto> GetCitiesMetaData(string city) { DBLibrary db = new DBLibrary(_connectionString); Thread.Sleep(10); List <string> cities = new List <string>(); if (!string.IsNullOrEmpty(city)) { cities.Add(city); } else { cities.AddRange(GetAllCityNames()); } var cityClause = string.Format("('{0}')", string.Join("','", cities)); var query = string.Format("select distinct city, area_name, project_name from rent_data where city in {0}", cityClause); var ds = db.ExecuteQuery(query); var list = ds.Tables["Table"].AsEnumerable().Select(r => new { city = r["city"].ToString(), area = r["area_name"].ToString(), project = r["project_name"].ToString() } ).ToList(); var response = list.GroupBy(i => i.city).ToDictionary(g => g.Key).Select(kv => new CityMetadataDto { city = kv.Key, areanames = kv.Value.ToList().Select(i => i.area).Distinct(), projectnames = kv.Value.ToList().Select(i => i.project).Distinct() }).ToDictionary(i => i.city); return(response); }
public List <TradeDTO> getTradeByID(int pIdTrade) { List <TradeDTO> oReturn = new List <TradeDTO>(); SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_trade_consultar"; sqlCmd.Parameters.AddWithValue("@IdTrade", pIdTrade); var oData = sqlCmd.ExecuteReader(); while (oData.Read() == true) { TradeDTO oTrade = new TradeDTO(); oTrade.idTrade = int.Parse(oData["idTrade"].ToString()); oTrade.idCliente = int.Parse(oData["idCliente"].ToString()); oTrade.tradeValue = decimal.Parse(oData["tradeValue"].ToString()); oTrade.idSector = int.Parse(oData["idSector"].ToString()); oTrade.dsSector = oData["dsSector"].ToString(); oReturn.Add(oTrade); } } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(oReturn); }
/// <summary> /// Save location /// </summary> private int SaveNewsCategory() { GetId(); PNK_UploadImage productcatObj = new PNK_UploadImage(); Generic <PNK_UploadImage> genericBLL = new Generic <PNK_UploadImage>(); if (idImage == int.MinValue) { //Get max id medical_product DBLibrary db = new DBLibrary(); productId = db.Timso_int("SELECT TOP 1 id FROM PNK_Product mp ORDER BY id desc") + 1; //get data insert productcatObj = this.GetDataObjectParent(productcatObj); productcatObj.ProductId = productId; productcatObj.PostDate = DateTime.Now; productcatObj.Ordering = genericBLL.getOrdering(); //excute genericBLL.Insert(productcatObj); } else { productcatObj.Published = "1"; productcatObj.Updatedate = DateTime.Now; productcatObj.Name = fileNameUpload; productcatObj.ImagePath = ImagePath; productcatObj.ProductId = idImage; productcatObj.PostDate = DateTime.Now; productcatObj.Ordering = genericBLL.getOrdering(); //excute genericBLL.Insert(productcatObj); BindAlbum(idImage); // } //} } return(productId); }
protected void btnUpdate_Click(object sender, EventArgs e) { CheckBox chkPr; int count = 0; try { foreach (GridViewRow gvr in GVChangeProcess.Rows) { chkPr = (CheckBox)gvr.FindControl("chkChangeProcess"); if (chkPr.Checked == true) { int ProcessId = 1; int ID = Convert.ToInt32(GVChangeProcess.DataKeys[gvr.RowIndex].Values["ID"]); int result = DBLibrary.UpdateProcess(ID, ProcessId); count = count + 1; chkPr.Checked = false; chkPr.Enabled = true; } } if (count > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Updation Successful')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Select an Item To REintiate')", true); } GridProcessBind(); } catch (Exception ex) { bool rethrow = false; rethrow = UserInterfaceExceptionHandler.HandleExcetion(ref ex); ShowMessage(ex.Message); } }
protected void grdImage_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int idImage = DBConvert.ParseInt(grdImage.DataKeys[e.RowIndex].Value); DBLibrary db = new DBLibrary(); productId = db.Timso_int(string.Format("SELECT TOP 1 productid FROM PNK_UploadImage mp where id={0} ORDER BY id desc", idImage)); db.Timso_int(string.Format("DELETE FROM PNK_UploadImage WHERE id={0}", idImage)); string imagePath = Server.MapPath(string.Format("{0}/{1}", grdImage.Rows[e.RowIndex].Cells[3].Text, grdImage.Rows[e.RowIndex].Cells[1].Text)); //if (File.Exists(imagePath)) //{ File.Delete(imagePath); BindAlbum(productId); //} } catch (Exception ex) { // throw; } }
public List <CategoryDTO> getCategoryByID(int pIdCategory) { List <CategoryDTO> oReturn = new List <CategoryDTO>(); SqlConnection sqlCon = DBLibrary.OpenConnection(); try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "sp_category_consultar"; sqlCmd.Parameters.AddWithValue("@IdCategory", pIdCategory); var oData = sqlCmd.ExecuteReader(); while (oData.Read() == true) { CategoryDTO oCategory = new CategoryDTO(); oCategory.idCategory = int.Parse(oData["idCategory"].ToString()); oCategory.dsCategory = oData["dsCategory"].ToString(); oReturn.Add(oCategory); } } catch (Exception ex) { throw ex; } finally { sqlCon.Close(); } return(oReturn); }
public IEnumerable <PropertyRentServiceDto> GetCityRents(string city, string area, string project, string maxrecords) { DBLibrary db = new DBLibrary(_connectionString); var cityClause = string.Format(" city = '{0}'", city); var areaClause = string.IsNullOrEmpty(area) ? "" : string.Format(" and area_name = '{0}'", area); var projectClause = string.IsNullOrEmpty(project) ? "" : string.Format(" and project_name = '{0}'", project); var query = string.Format("select top {3} * from rent_data where{0}{1}{2}", cityClause, areaClause, projectClause, maxrecords ?? "99999999"); var ds = db.ExecuteQuery(query); //var list = ds.Tables["Table"].ToList<PropertyRentServiceDto>(); List <PropertyRentServiceDto> list = new List <PropertyRentServiceDto>(ds.Tables["Table"].Rows.Count); foreach (DataRow dr in ds.Tables["Table"].Rows) { var dto = ConvertPropertyRentDataRowToServiceDto(dr); list.Add(dto); } return(list); //var only5 = list.Take(1); //return only5; }