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