public String Update(ems_ust_TradingLimits Lcl_TradingLimits, String editingEmail, String editingLimitHardOrSoft, String editingLimitType, String editingLimitCurrencyCode)
{
DateTime dt = DateTime.Now;
String retMessage = System.String.Empty;
SqlConnection sql = new SqlConnection(conString);
sql.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sql;
cmd.CommandText = "UPDATE [ems.ust_TradingLimits] SET ManagerEmail=@ManagerEmail , LimitHardOrSoft=@LimitHardOrSoft, LimitType=@LimitType, LimitCurrencyCode=@LimitCurrencyCode, LimitValue=@LimitValue, LimitOverride=@LimitOverride, ModifiedDateTime=@ModifiedDateTime WHERE ManagerEmail=@editingEmail and LimitHardOrSoft=@editingLimitHardOrSoft and LimitType=@editingLimitType and LimitCurrencyCode=@editingLimitCurrencyCode";
cmd.Parameters.AddWithValue("@ManagerEmail", Lcl_TradingLimits.ManagerEmail);
cmd.Parameters.AddWithValue("@editingEmail", editingEmail);
cmd.Parameters.AddWithValue("@LimitHardOrSoft", Lcl_TradingLimits.LimitHardOrSoft);
cmd.Parameters.AddWithValue("@editingLimitHardOrSoft", editingLimitHardOrSoft);
cmd.Parameters.AddWithValue("@LimitType", Lcl_TradingLimits.LimitType);
cmd.Parameters.AddWithValue("@editingLimitType", editingLimitType);
cmd.Parameters.AddWithValue("@LimitCurrencyCode", Lcl_TradingLimits.LimitCurrencyCode);
cmd.Parameters.AddWithValue("@editingLimitCurrencyCode", editingLimitCurrencyCode);
cmd.Parameters.AddWithValue("@LimitValue", Lcl_TradingLimits.LimitValue);
cmd.Parameters.AddWithValue("@LimitOverride", Lcl_TradingLimits.LimitOverride);
cmd.Parameters.AddWithValue("@ModifiedDateTime", dt);
try
{
cmd.ExecuteNonQuery();
sql.Close();
return(retMessage);
}
catch (Exception)
{
return(retMessage);
throw;
}
}
public String Insert(ems_ust_TradingLimits Lcl_TradingLimits)
{
DateTime dt = DateTime.Now;
String retMessage = System.String.Empty;
SqlConnection sql = new SqlConnection(conString);
sql.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sql;
cmd.CommandText = "insert into [ems.ust_TradingLimits] (ManagerEmail,LimitHardOrSoft,LimitType,LimitCurrencyCode,LimitValue,LimitOverride,CreateDateTime,ModifiedDateTime) values (@ManagerEmail,@LimitHardOrSoft,@LimitType,@LimitCurrencyCode,@LimitValue,@LimitOverride,@CreateDateTime,@ModifiedDateTime)";
cmd.Parameters.AddWithValue("@ManagerEmail", Lcl_TradingLimits.ManagerEmail);
cmd.Parameters.AddWithValue("@LimitHardOrSoft", Lcl_TradingLimits.LimitHardOrSoft);
cmd.Parameters.AddWithValue("@LimitType", Lcl_TradingLimits.LimitType);
cmd.Parameters.AddWithValue("@LimitCurrencyCode", Lcl_TradingLimits.LimitCurrencyCode);
cmd.Parameters.AddWithValue("@LimitValue", Lcl_TradingLimits.LimitValue);
cmd.Parameters.AddWithValue("@LimitOverride", Lcl_TradingLimits.LimitOverride);
cmd.Parameters.AddWithValue("@CreateDateTime", dt);
cmd.Parameters.AddWithValue("@ModifiedDateTime", dt);
try
{
cmd.ExecuteNonQuery();
sql.Close();
return(retMessage);
}
catch (Exception)
{
return(retMessage);
throw;
}
}
