/// <summary>
/// Code to update factors from Multi5 module
/// </summary>
/// <param name="ObjEMulti"></param>
/// <returns></returns>
public EMulti UpdateMulti5(EMulti ObjEMulti)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Upd_Multi]";
cmd.Parameters.Add("@ProjectID", ObjEMulti.ProjectID);
cmd.Parameters.Add("@LVSection", ObjEMulti.LVSection);
cmd.Parameters.Add("@dt", ObjEMulti.dtArticles);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Aktualisierung von Multi 5");
}
else
{
throw new Exception("Error while updating multi5");
}
}
finally
{
SQLCon.Close();
}
return(ObjEMulti);
}
/// <summary>
/// Code to get Article groups based on LV section for Multi5 module
/// </summary>
/// <param name="ObjEMulti"></param>
/// <returns></returns>
public EMulti GetArticleGroups(EMulti ObjEMulti)
{
try
{
ObjEMulti.dtArticles = new DataTable();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_WGForMulti]";
cmd.Parameters.Add("@ProjectID", ObjEMulti.ProjectID);
cmd.Parameters.Add("@LVSection", ObjEMulti.LVSection);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ObjEMulti.dtArticles);
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Laden der Artikelgruppen");
}
else
{
throw new Exception("Error while retrieving article groups");
}
}
finally
{
SQLCon.Close();
}
return(ObjEMulti);
}
/// <summary>
/// Code to fetch Sumbitted Multi 5 factors
/// </summary>
/// <param name="ObjEMulti"></param>
/// <returns></returns>
public EMulti GetSOldMultis(EMulti ObjEMulti)
{
try
{
ObjDMulti.GetSOldMultis(ObjEMulti);
}
catch (Exception ex) {}
return(ObjEMulti);
}
/// <summary>
/// Code to update factors from multi 6 module
/// </summary>
/// <param name="ObjEMulti"></param>
/// <returns></returns>
public EMulti UpdateMulti6(EMulti ObjEMulti)
{
try
{
ObjEMulti = ObjDMulti.UpdateMulti6(ObjEMulti);
}
catch (Exception ex)
{
throw;
}
return(ObjEMulti);
}
/// <summary>
/// Code to fetch articles groups for Multi6 module
/// </summary>
/// <param name="ObjEMulti"></param>
/// <returns></returns>
public EMulti GetArticleGroupsForMulti6(EMulti ObjEMulti)
{
try
{
ObjEMulti = ObjDMulti.GetArticleGroupsForMulti6(ObjEMulti);
}
catch (Exception ex)
{
throw;
}
return(ObjEMulti);
}
