public DataSet GetInvoiceDetails(EInvoice ObjEInvoice)
{
DataSet dsOTTO = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_ProjectDetailsforOTTOMaster]";
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsOTTO);
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Laden der Daten zu Projekt");
}
else
{
throw new Exception("Error Occured While Retreiving Invoice details");
}
}
finally
{
SQLCon.Sqlconn().Close();
}
return(dsOTTO);
}
public void GetInvoiceDetails(EInvoice ObjEInvoice)
{
try
{
if (ObjEInvoice != null)
{
ObjEInvoice.dsInvoice = ObjDInvoice.GetInvoiceDetails(ObjEInvoice);
}
}
catch (Exception ex)
{
throw;
}
}
public void GetProjectDetails(EInvoice ObjEInvoice)
{
try
{
if (ObjEInvoice != null)
{
ObjEInvoice.dsProject = ObjDInvoice.GetProjectDetails();
}
}
catch (Exception ex)
{
throw;
}
}