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