/// <summary> /// Connects to database and add module web info. /// </summary> /// <param name="list"> List of object of ModuleWebInfo class.</param> public static void AddModuleWebInfo(List <ModuleWebInfo> list) { string sp = "[dbo].[usp_ModuleWebInfoDelete]"; SQLHandler sagesql = new SQLHandler(); DbTransaction transaction = sagesql.GetTransaction(); try { sagesql.ExecuteNonQuery(sp); sp = "[dbo].[usp_ModuleWebInfoAdd]"; foreach (ModuleWebInfo Obj in list) { List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleID", Obj.ModuleID)); ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleName", Obj.ModuleName)); ParamCollInput.Add(new KeyValuePair <string, object>("@ReleaseDate", Obj.ReleaseDate)); ParamCollInput.Add(new KeyValuePair <string, object>("@Description", Obj.Description)); ParamCollInput.Add(new KeyValuePair <string, object>("@Version", Obj.Version)); ParamCollInput.Add(new KeyValuePair <string, object>("@DownloadUrl", Obj.DownloadUrl)); sagesql.ExecuteNonQuery(sp, ParamCollInput); } sagesql.CommitTransaction(transaction); } catch (Exception ex) { sagesql.RollbackTransaction(transaction); throw ex; } }
public static void AddModuleWebInfo(List<ModuleWebInfo> list) { string sp = "[dbo].[usp_ModuleWebInfoDelete]"; SQLHandler sagesql = new SQLHandler(); DbTransaction transaction = sagesql.GetTransaction(); try { sagesql.ExecuteNonQuery(sp); sp = "[dbo].[usp_ModuleWebInfoAdd]"; foreach (ModuleWebInfo Obj in list) { List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleID", Obj.ModuleID)); ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleName", Obj.ModuleName)); ParamCollInput.Add(new KeyValuePair<string, object>("@ReleaseDate", Obj.ReleaseDate)); ParamCollInput.Add(new KeyValuePair<string, object>("@Description", Obj.Description)); ParamCollInput.Add(new KeyValuePair<string, object>("@Version", Obj.Version)); ParamCollInput.Add(new KeyValuePair<string, object>("@DownloadUrl", Obj.DownloadUrl)); sagesql.ExecuteNonQuery(sp, ParamCollInput); } sagesql.CommitTransaction(transaction); } catch (Exception ex) { sagesql.RollbackTransaction(transaction); throw ex; } }