/// <summary>
/// /// Business Logic for retreiving the existing project details to show on project screen
/// </summary>
/// <param name="ObjEProject"></param>
public void GetProjectDetails(EProject ObjEProject)
{
try
{
DataSet dsProjectDetails = ObjDAL.GetProjectDetails(ObjEProject);
if (dsProjectDetails != null)
{
if (dsProjectDetails.Tables.Count > 4)
{
ObjEProject.dtQuerCalc = dsProjectDetails.Tables[4];
}
if (dsProjectDetails.Tables.Count > 3)
{
ObjEProject.dtArticleSettings = dsProjectDetails.Tables[3];
}
if (dsProjectDetails.Tables.Count > 2)
{
ObjEProject.dtDiscount = dsProjectDetails.Tables[2];
}
if (dsProjectDetails.Tables.Count > 1)
{
ObjEProject.dtLVSection = dsProjectDetails.Tables[1];
}
if (dsProjectDetails.Tables.Count > 0)
{
DataTable dtPRojectDetails = dsProjectDetails.Tables[0];
if (dtPRojectDetails != null && dtPRojectDetails.Rows.Count > 0)
{
int iValue = 0;
decimal dValue = 0;
DateTime SubmitDate = DateTime.Now;
bool LockLV = false;
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["ProjectID"]), out iValue))
{
ObjEProject.ProjectID = iValue;
}
else
{
ObjEProject.ProjectID = -1;
}
ObjEProject.ProjectNumber = Convert.ToString(dtPRojectDetails.Rows[0]["ProjectNumber"]);
ObjEProject.ProjectName = Convert.ToString(dtPRojectDetails.Rows[0]["ProjectName"]);
ObjEProject.Location = Convert.ToString(dtPRojectDetails.Rows[0]["Location"]);
ObjEProject.CommissionNumber = Convert.ToString(dtPRojectDetails.Rows[0]["ComissionNumber"]);
ObjEProject.LVRaster = Convert.ToString(dtPRojectDetails.Rows[0]["LV_Raster"]);
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["LV_Sprung"]), out iValue))
{
ObjEProject.LVSprunge = iValue;
}
if (decimal.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Vat"]), out dValue))
{
ObjEProject.Vat = dValue;
}
ObjEProject.ProjectDescription = Convert.ToString(dtPRojectDetails.Rows[0]["ProjectDescription"]);
ObjEProject.KundeID = 1;
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["CustomerID"]), out iValue))
{
ObjEProject.KundeNr = iValue;
}
ObjEProject.KundeName = Convert.ToString(dtPRojectDetails.Rows[0]["CustomerName"]);
ObjEProject.KundeAddress = Convert.ToString(dtPRojectDetails.Rows[0]["Street"]);
ObjEProject.PlannedID = 1;
ObjEProject.PlannerName = Convert.ToString(dtPRojectDetails.Rows[0]["PlannerName"]);
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Planned_Duration"]), out iValue))
{
ObjEProject.ProjectDuration = iValue;
}
if (decimal.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Intern_X"]), out dValue))
{
ObjEProject.InternX = dValue;
}
if (decimal.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Intern_S"]), out dValue))
{
ObjEProject.InternS = dValue;
}
ObjEProject.Submitlocation = Convert.ToString(dtPRojectDetails.Rows[0]["Submit_Location"]);
if (DateTime.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Submit_Date"]), out SubmitDate))
{
ObjEProject.SubmitTime = SubmitDate;
ObjEProject.SubmitDate = SubmitDate;
}
else
{
ObjEProject.SubmitTime = SubmitDate;
ObjEProject.SubmitDate = SubmitDate;
}
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Estimated_LV"]), out iValue))
{
ObjEProject.EstimatedLvs = iValue;
}
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Actual_LV"]), out iValue))
{
ObjEProject.ActualLvs = iValue;
}
ObjEProject.RoundingPriceID = 1;
ObjEProject.Remarks = Convert.ToString(dtPRojectDetails.Rows[0]["Remarks"]);
if (bool.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Lock_LVHierarchy"]), out LockLV))
{
ObjEProject.LockHierarchy = LockLV;
}
if (int.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["Round_Off"]), out iValue))
{
ObjEProject.RoundingPrice = iValue;
}
if (DateTime.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["ProjectStartDate"]), out SubmitDate))
{
ObjEProject.ProjectStartDate = SubmitDate;
}
else
{
ObjEProject.ProjectStartDate = SubmitDate;
}
if (DateTime.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["ProjectEndDate"]), out SubmitDate))
{
ObjEProject.ProjectEndDate = SubmitDate;
}
else
{
ObjEProject.ProjectEndDate = SubmitDate;
}
if (bool.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["IsDisable"]), out LockLV))
{
ObjEProject.IsDisable = LockLV;
}
if (bool.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["IsCumulated"]), out LockLV))
{
ObjEProject.IsCumulated = LockLV;
}
if (bool.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["FinalInvoice"]), out LockLV))
{
ObjEProject.IsFinalInvoice = LockLV;
}
if (bool.TryParse(Convert.ToString(dtPRojectDetails.Rows[0]["ShowVK"]), out LockLV))
{
ObjEProject.ShowVK = LockLV;
}
}
}
}
}
catch (Exception ex)
{
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE")
{
throw new Exception("Fehler beim Laden des Projektes");
}
else
{
throw new Exception("Error Occured While Loading the Project");
}
}
}
/// <summary>
/// /// Business Logic for retreiving the existing project details to show on project screen
/// </summary>
/// <param name="ObjEProject"></param>
public void GetProjectDetails(EProject ObjEProject)
{
try
{
DataTable dtPRojectDetails = ObjDAL.GetProjectDetails(ObjEProject);
if (dtPRojectDetails != null && dtPRojectDetails.Rows.Count > 0)
{
int iValue = 0;
decimal dValue = 0;
DateTime SubmitDate = DateTime.Now;
bool LockLV = false;
if (int.TryParse(dtPRojectDetails.Rows[0]["ProjectID"].ToString(), out iValue))
{
ObjEProject.ProjectID = iValue;
}
else
{
ObjEProject.ProjectID = -1;
}
ObjEProject.ProjectNumber = dtPRojectDetails.Rows[0]["ProjectNumber"].ToString();
ObjEProject.Location = dtPRojectDetails.Rows[0]["Location"].ToString();
ObjEProject.CommissionNumber = dtPRojectDetails.Rows[0]["ComissionNumber"].ToString();
ObjEProject.LVRaster = dtPRojectDetails.Rows[0]["LV_Raster"].ToString();
if (int.TryParse(dtPRojectDetails.Rows[0]["LV_Sprung"].ToString(), out iValue))
{
ObjEProject.LVSprunge = iValue;
}
if (decimal.TryParse(dtPRojectDetails.Rows[0]["Vat"].ToString(), out dValue))
{
ObjEProject.Vat = dValue;
}
ObjEProject.ProjectDescription = dtPRojectDetails.Rows[0]["ProjectDescription"].ToString();
ObjEProject.KundeID = 1;
ObjEProject.KundeNr = dtPRojectDetails.Rows[0]["CustomerNumber"].ToString();
ObjEProject.KundeName = dtPRojectDetails.Rows[0]["CustomerName"].ToString();
ObjEProject.PlannedID = 1;
ObjEProject.PlannerName = dtPRojectDetails.Rows[0]["PlannerName"].ToString();
if (int.TryParse(dtPRojectDetails.Rows[0]["Planned_Duration"].ToString(), out iValue))
{
ObjEProject.ProjectDuration = iValue;
}
if (decimal.TryParse(dtPRojectDetails.Rows[0]["Intern_X"].ToString(), out dValue))
{
ObjEProject.InternX = dValue;
}
if (decimal.TryParse(dtPRojectDetails.Rows[0]["Intern_S"].ToString(), out dValue))
{
ObjEProject.InternS = dValue;
}
ObjEProject.Submitlocation = dtPRojectDetails.Rows[0]["Submit_Location"].ToString();
if (DateTime.TryParse(dtPRojectDetails.Rows[0]["Submit_Date"].ToString(), out SubmitDate))
{
ObjEProject.SubmitTime = SubmitDate;
ObjEProject.SubmitDate = SubmitDate;
}
else
{
ObjEProject.SubmitTime = SubmitDate;
ObjEProject.SubmitDate = SubmitDate;
}
if (int.TryParse(dtPRojectDetails.Rows[0]["Estimated_LV"].ToString(), out iValue))
{
ObjEProject.EstimatedLvs = iValue;
}
if (int.TryParse(dtPRojectDetails.Rows[0]["Actual_LV"].ToString(), out iValue))
{
ObjEProject.ActualLvs = iValue;
}
ObjEProject.RoundingPriceID = 1;
ObjEProject.Remarks = dtPRojectDetails.Rows[0]["Remarks"].ToString();
if (bool.TryParse(dtPRojectDetails.Rows[0]["Lock_LVHierarchy"].ToString(), out LockLV))
{
ObjEProject.LockHierarchy = LockLV;
}
if (int.TryParse(dtPRojectDetails.Rows[0]["Round_Off"].ToString(), out iValue))
{
ObjEProject.RoundingPrice = iValue;
}
if (DateTime.TryParse(dtPRojectDetails.Rows[0]["ProjectStartDate"].ToString(), out SubmitDate))
{
ObjEProject.ProjectStartDate = SubmitDate;
}
else
{
ObjEProject.ProjectStartDate = SubmitDate;
}
if (DateTime.TryParse(dtPRojectDetails.Rows[0]["ProjectEndDate"].ToString(), out SubmitDate))
{
ObjEProject.ProjectEndDate = SubmitDate;
}
else
{
ObjEProject.ProjectEndDate = SubmitDate;
}
}
}
catch (Exception ex)
{
throw new Exception("Error Occured While Loading the Project");
}
}
