ASP.NET

Ramasubramaniam wrote:

Save the dataset xml string and store that string in the database table field

<br />
<br />
<br />
<br />
 public void UpdateMonoLinePropMaxLimits(int RateGroupCode, DateTime EffectiveDate, MonoLineMaxLimit[] LimitsRows)<br />
    {<br />
        SqlConnection conn = UAIG.SQL.ConnectionManager.GetConnection();<br />
        SqlCommand cmd1 = new SqlCommand();<br />
        cmd1.CommandText = "dbo.uspUpdatePropMaxLimit";<br />
        cmd1.Connection = conn;<br />
        cmd1.CommandType = CommandType.StoredProcedure;<br />
        cmd1.Parameters.Add(new SqlParameter("@RateGroupCode", RateGroupCode));<br />
        cmd1.Parameters.Add(new SqlParameter("@EffectiveDate", EffectiveDate));<br />
        cmd1.Parameters.Add(new SqlParameter("@NetID", UAIG.Settings.ApplicationSettings.GetUser()));<br />
        //The return value comes from scope_identity() on the header table<br />
        SqlParameter prmReturnValue = new SqlParameter("@ReturnValue", SqlDbType.Int);<br />
        prmReturnValue.Direction = ParameterDirection.ReturnValue;<br />
        cmd1.Parameters.Add(prmReturnValue);<br />
        conn.Open();<br />
        SqlTransaction trans = conn.BeginTransaction();<br />
        cmd1.Transaction = trans;<br />
        cmd1.ExecuteNonQuery();<br />
<br />
<br />
        int MaxLimitGroup = int.Parse(prmReturnValue.Value.ToString());<br />
        SqlCommand cmd2 = new SqlCommand();<br />
        cmd2.CommandType = CommandType.StoredProcedure;<br />
        cmd2.Connection = conn;<br />
        cmd2.CommandText = "dbo.uspInsertMaxLimit";<br />
        cmd2.Parameters.Add(new SqlParameter("@MaxLimitGroup", MaxLimitGroup));<br />
        SqlParameter prmConstructionTypeCode = new SqlParameter("@ConstructionTypeCode", SqlDbType.Int);<br />
        cmd2.Parameters.Add(prmConstructionTypeCode);<br />
        SqlParameter prmSprinklered1_6 = new SqlParameter("@Sprinklered1_6", SqlDbType.Money);<br />
        cmd2.Parameters.Add(prmSprinklered1_6);<br />
        SqlParameter prmSprinklered7_8 = new SqlParameter("@Sprinklered7_8", SqlDbType.Money);<br />
        cmd2.Parameters.Add(prmSprinklered7_8);<br />
        SqlParameter prmNonSprinklered1_6 = new SqlParameter("@NonSprinklered1_6", SqlDbType.Money);<br />
        cmd2.Parameters.Add(prmNonSprinklered1_6);<br />
        SqlParameter prmNonSprinklered7_8 = new SqlParameter("@NonSprinklered7_8", SqlDbType.Money);<br />
        cmd2.Parameters.Add(prmNonSprinklered7_8);<br />
<br />
        foreach (MonoLineMaxLimit item in LimitsRows)<br />
        {<br />
            prmConstructionTypeCode.Value = item.ConstructionTypeCode;<br />
            prmSprinklered1_6.Value = item.Sprinklered1_6;<br />
            prmSprinklered7_8.Value = item.Sprinklered7_8;<br />
            prmNonSprinklered1_6.Value = item.NonSprinklered1_6;<br />
            prmNonSprinklered7_8.Value = item.NonSprinklered7_8;<br />
<br />
            cmd2.Transaction = trans;<br />
            cmd2.ExecuteNonQuery();<br />
<br />
        }<br />
<br />
        trans.Commit();<br />
        conn.Dispose();<br />
    }<br />
<br />
    public struct MonoLineMaxLimit<br />
    {<br />
        public int ConstructionTypeCode;<br />
        public decimal Sprinklered1_6;<br />
        public decimal Sprinklered7_8;<br />
        public decimal NonSprinklered1_6;<br />
        public decimal NonSprinklered7_8;<br />
    }<br />