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