/// <summary>
/// Code to get next available Blatt Number
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetNewBlattNumber(EDeliveryNotes ObjEDeliveryNotes)
{
try
{
ObjEDeliveryNotes = ObjDdeliveryNotes.GetNewBlattNumber(ObjEDeliveryNotes);
}
catch (Exception ex)
{
throw;
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to fetch non active deliveries from database
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetNonActiveDelivery(EDeliveryNotes ObjEDeliveryNotes)
{
try
{
ObjEDeliveryNotes = ObjDdeliveryNotes.GetNonActiveDelivery(ObjEDeliveryNotes);
}
catch (Exception ex)
{
throw;
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to fetch positions for delivery notes module
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetPositions(EDeliveryNotes ObjEDeliveryNotes)
{
try
{
ObjEDeliveryNotes = ObjDdeliveryNotes.GetPositions(ObjEDeliveryNotes);
}
catch (Exception ex)
{
throw;
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to get Blatt details after saving
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetBlattDetails(EDeliveryNotes ObjEDeliveryNotes)
{
try
{
ObjEDeliveryNotes = ObjDdeliveryNotes.GetBlattDetails(ObjEDeliveryNotes);
}
catch (Exception ex)
{
throw;
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to fetch non active deliveries from database
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetNonActiveDelivery(EDeliveryNotes ObjEDeliveryNotes)
{
DataSet dsPositions = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_NonActivedelivery]";
cmd.Parameters.AddWithValue("@ProjectID", ObjEDeliveryNotes.ProjectID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsPositions);
}
ObjEDeliveryNotes.dtNonActivedelivery = dsPositions.Tables[0];
if (ObjEDeliveryNotes.dtNonActivedelivery.Rows.Count > 0 && dsPositions.Tables[1].Rows.Count > 0)
{
ObjEDeliveryNotes.BlattID = dsPositions.Tables[1].Rows[0]["BlattID"] == DBNull.Value
? -1 : Convert.ToInt32(dsPositions.Tables[1].Rows[0]["BlattID"]);
ObjEDeliveryNotes.BlattName = dsPositions.Tables[1].Rows[0]["BlattNumber"] == DBNull.Value
? "" : dsPositions.Tables[1].Rows[0]["BlattNumber"].ToString();
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Error While Retrieving the Positions");
}
else
{
throw new Exception("Error While Retrieving the Positions");
}
}
finally
{
SQLCon.Close();
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to get Blatt details after saving
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetBlattDetails(EDeliveryNotes ObjEDeliveryNotes)
{
DataSet dsPositions = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_BlattDetails]";
cmd.Parameters.AddWithValue("@BlattID", ObjEDeliveryNotes.BlattID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsPositions);
}
ObjEDeliveryNotes.dtNonActivedelivery = dsPositions.Tables[0];
ObjEDeliveryNotes.dtPositions = dsPositions.Tables[1];
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Laden der LV Position");
}
else
{
throw new Exception("Error While Retrieving the Positions");
}
}
finally
{
SQLCon.Close();
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to get next available Blatt Number
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetNewBlattNumber(EDeliveryNotes ObjEDeliveryNotes)
{
DataSet dsDeliveryNumbers = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_NewBlattNumber]";
cmd.Parameters.AddWithValue("@ProjectID", ObjEDeliveryNotes.ProjectID);
object ObjReturn = cmd.ExecuteScalar();
if (ObjReturn != null)
{
ObjEDeliveryNotes.BlattName = ObjReturn.ToString();
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Datenabruf zur neuen BLATT Nummer");
}
else
{
throw new Exception("Error While Retrieving the New Blatt Number");
}
}
finally
{
SQLCon.Close();
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to get Saved blatt numbers from database
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes GetBlattNumbers(EDeliveryNotes ObjEDeliveryNotes)
{
DataSet dsBlattNumbers = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Get_BlattNumbers]";
cmd.Parameters.AddWithValue("@ProjectID", ObjEDeliveryNotes.ProjectID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsBlattNumbers);
}
ObjEDeliveryNotes.dtBlattNumbers = dsBlattNumbers.Tables[0];
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Datenabruf zu den Positionskennzahlen für Aufmasse");
}
else
{
throw new Exception("Error While Retrieving the Delivery Numbers");
}
}
finally
{
SQLCon.Close();
}
return(ObjEDeliveryNotes);
}
/// <summary>
/// Code to save a delivery
/// </summary>
/// <param name="ObjEDeliveryNotes"></param>
/// <returns></returns>
public EDeliveryNotes SaveDelivery(EDeliveryNotes ObjEDeliveryNotes)
{
DataSet dsBlattDetails = new DataSet();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = SQLCon.Sqlconn();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[P_Ins_BlattDetails]";
cmd.Parameters.AddWithValue("@BlattID", ObjEDeliveryNotes.BlattID);
cmd.Parameters.AddWithValue("@ProjetcID", ObjEDeliveryNotes.ProjectID);
cmd.Parameters.AddWithValue("@BlattNumber", ObjEDeliveryNotes.BlattName);
cmd.Parameters.AddWithValue("@IsActiveDelivery", ObjEDeliveryNotes.ISActiveDelivery);
cmd.Parameters.AddWithValue("@Delivery", ObjEDeliveryNotes.dtDelivery);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsBlattDetails);
}
int iValue = 0;
if (dsBlattDetails != null & dsBlattDetails.Tables.Count > 0)
{
string str = dsBlattDetails.Tables[0].Rows[0][0].ToString();
if (!int.TryParse(str, out iValue))
{
throw new Exception(str);
}
else if (dsBlattDetails.Tables.Count > 1)
{
ObjEDeliveryNotes.BlattID = iValue;
ObjEDeliveryNotes.dtPositions = dsBlattDetails.Tables[1];
if (dsBlattDetails.Tables.Count > 2)
{
ObjEDeliveryNotes.dtBlattNumbers = dsBlattDetails.Tables[2];
}
}
}
}
}
catch (Exception ex)
{
if (ex.Message.Contains("UNIQUE"))
{
throw new Exception("Diese BLATT Nummer wurde bereits vergeben. Bitte machen Sie eine neue Angabe.");
}
else if
(ex.Message.Contains("Valid"))
{
throw new Exception("Bitte machen Sie gültige Mengenangaben für alle Positionen");
}
else
{
throw new Exception("Error While Saving Delivery");
}
}
finally
{
SQLCon.Close();
}
return(ObjEDeliveryNotes);
}
