private void btnAddContact_Click(object sender, EventArgs e)
{
try
{
if (ObjESupplier.SupplierID > 0)
{
if (ObjESupplier == null)
{
ObjESupplier = new ESupplier();
}
ObjESupplier.ContactPersonID = -1;
frmSupplierMaster frm = new frmSupplierMaster("Contact");
frm.ObjEsupplier = ObjESupplier;
frm.ShowDialog();
if (frm.DialogResult == DialogResult.OK)
{
BindContactData(ObjESupplier.SupplierID);
Setfocus(gvContact, "ContactPersonID", ObjESupplier.ContactPersonID);
if (Utility._IsGermany == true)
{
frmOTTOPro.UpdateStatus("Vorgang abgeschlossen: Speichern der Lieferanten-Kontaktdaten");
}
else
{
frmOTTOPro.UpdateStatus("Supplier Contact saved successfully");
}
}
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtFullName.Text.Trim()))
{
throw new Exception("Vollständiger Name Cannot be empty");
}
if (!dxValidationProvider1.Validate())
{
return;
}
if (ObjESupplier == null)
{
ObjESupplier = new ESupplier();
}
ParseSupplierDetails();
ObjBSupplier = new BSupplier();
ObjESupplier = ObjBSupplier.SaveSupplierDetails(ObjESupplier);
BindSupplierData();
cmbSupplier.EditValue = ObjESupplier.SupplierID;
if (Utility._IsGermany)
{
frmOTTOPro.UpdateStatus("Vorgang abgeschlossen: Speichern der Lieferantendaten ");
}
else
{
frmOTTOPro.UpdateStatus("Supplier data saved successfully");
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
private void btnAddArticles_Click(object sender, EventArgs e)
{
try
{
if (ObjESupplier.SupplierID > 0)
{
if (ObjESupplier == null)
{
ObjESupplier = new ESupplier();
}
ObjESupplier.WGWAID = -1;
frmSaveArticle frm = new frmSaveArticle();
frm.ObjEsupplier = ObjESupplier;
frm.ShowDialog();
if (frm.DialogResult == DialogResult.OK)
{
BindArticleData(ObjESupplier.SupplierID);
Setfocus(gvArticles, "WGWAID", ObjESupplier.WGWAID);
if (Utility._IsGermany == true)
{
frmOTTOPro.UpdateStatus("Vorgang abgeschlossen: Speichern des Artikels");
}
else
{
frmOTTOPro.UpdateStatus("Article saved successfully");
}
}
}
}
catch (Exception ex) { Utility.ShowError(ex); }
}
/// <summary>
/// Code to delete suppliers from supplier proposal
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier DeleteSuipplierProposal(ESupplier ObjESupplier)
{
try
{
ObjDSupplier.DeleteSuipplierProposal(ObjESupplier);
}
catch (Exception ex) { throw; }
return(ObjESupplier);
}
/// <summary>
/// Code to fetch project LV sections using projectid for supplier proposal module
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier GetLVSectionForProposal(ESupplier ObjEsupplier)
{
try
{
ObjDSupplier.GetLVSectionforProposal(ObjEsupplier);
}
catch (Exception ex) { throw ex; }
return(ObjEsupplier);
}
/// <summary>
/// Code to chcek supplier and article mapping
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier CheckSupplierArticle(ESupplier ObjESupplier)
{
try
{
ObjESupplier = ObjDSupplier.CheckSupplierArticle(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to save supplier selection for all positions
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier SaveBulkSelection(ESupplier ObjESupplier)
{
try
{
ObjESupplier = ObjDSupplier.SaveBulkSelection(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to save deleted positions from supplier proposal module
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier SaveDeletePosition(ESupplier ObjEsupplier)
{
try
{
ObjEsupplier = ObjDSupplier.SaveDeletePosition(ObjEsupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjEsupplier);
}
/// <summary>
/// Code to update proposal values to positions from price comparision module
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier SaveProposaleValues(ESupplier ObjESupplier)
{
try
{
ObjESupplier = ObjDSupplier.SaveProposaleValues(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to save Supplier price to proposal positions from supplier proposal module
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier SaveSupplierPrice(ESupplier ObjESupplier)
{
try
{
ObjESupplier = ObjDSupplier.SaveSupplierPrice(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to fetch positions from database based on supplier proposalID
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier GetPositionsByProposalID(ESupplier ObjESupplier)
{
try
{
ObjDSupplier.GetPositionsByProposalID(ObjESupplier);
}
catch (Exception ex)
{
throw ex;
}
return(ObjESupplier);
}
/// <summary>
/// Code to fetch Supplier proposals for proce comparision module
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier GetUpdateSupplierProposal(ESupplier ObjEsupplier)
{
try
{
ObjEsupplier = ObjDSupplier.GetUpdateSupplierProposal(ObjEsupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjEsupplier);
}
/// <summary>
/// Code to save Supplier proposal
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier SaveSupplierProposal(ESupplier ObjEsupplier)
{
try
{
ObjDSupplier.SaveSupplierProposal(ObjEsupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjEsupplier);
}
/// <summary>
/// Code to fetch saved adn not saved supplier proposal Numbers
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier GetProposalNumber(ESupplier ObjEsupplier)
{
try
{
ObjDSupplier.GetProposalNumber(ObjEsupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjEsupplier);
}
/// <summary>
/// Code to fetch Supplier details along with EMails
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <param name="ProposalID"></param>
/// <param name="ProjectID"></param>
/// <returns></returns>
public ESupplier GetSupplierMail(ESupplier ObjEsupplier, int ProposalID, int ProjectID)
{
try
{
ObjEsupplier = ObjDSupplier.GetSupplierMail(ObjEsupplier, ProposalID, ProjectID);
}
catch (Exception ex)
{
throw;
}
return(ObjEsupplier);
}
/// <summary>
/// Code to save Supplier and Article mapping form Price comparision module
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier SaveArticleFromProposal(ESupplier ObjESupplier)
{
try
{
ObjESupplier = ObjDSupplier.SaveArticleFromProposal(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to save Supplier articles from Supplier master to database
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier SaveArticle(ESupplier ObjEsupplier)
{
try
{
ObjEsupplier = ObjDSupplier.SaveArticle(ObjEsupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjEsupplier);
}
private void btnSaveContact_Click(object sender, EventArgs e)
{
try
{
ParseSupplierContactsDetails();
if (ObjBSupplier == null)
{
ObjBSupplier = new BSupplier();
}
_ObjEsupplier = ObjBSupplier.SaveSupplierContactDetails(_ObjEsupplier);
}
catch (Exception ex) { Utility.ShowError(ex); }
}
/// <summary>
/// Code to fetch suppliers while merging new article with existing proposal
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier GetSuppliersForProposalMerge(ESupplier ObjESupplier)
{
try
{
if (ObjDSupplier == null)
{
ObjDSupplier = new DSupplier();
}
ObjDSupplier.GetSuppliersForProposalMerge(ObjESupplier);
}
catch (Exception ex) { throw ex; }
return(ObjESupplier);
}
/// <summary>
/// Code fetch positions from database for not saved supplier propsoal by passing ProjectID, LVSection, Articles as imput parameters
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier GetPositionsforsupplierProposal(ESupplier ObjESupplier)
{
try
{
if (ObjDSupplier == null)
{
ObjDSupplier = new DSupplier();
}
ObjDSupplier.GetPositionsforsupplierProposal(ObjESupplier);
}
catch (Exception ex) { throw ex; }
return(ObjESupplier);
}
private void frmSpreadsheetControl_Load(object sender, EventArgs e)
{
try
{
ESupplier ObjESupplier = new ESupplier();
BSupplier ObjBSupplier = new BSupplier();
ObjBSupplier.GetSupplier(ObjESupplier);
cmbSupplier.DataSource = ObjESupplier.dtSupplier;
cmbSupplier.DisplayMember = "FullName";
cmbSupplier.ValueMember = "SupplierID";
}
catch (Exception ex) { Utility.ShowError(ex); }
}
private void btnOk_Click(object sender, EventArgs e)
{
try
{
if (ObjBSupplier == null)
{
ObjBSupplier = new BSupplier();
}
if (ObjESupplier == null)
{
ObjESupplier = new ESupplier();
}
int IValue = 0;
if (gvSupplier.FocusedRowHandle >= 0 &&
int.TryParse(Convert.ToString(gvSupplier.GetFocusedRowCellValue("SupplierID")), out IValue))
{
ObjESupplier.SupplierID = IValue;
ObjESupplier = ObjBSupplier.CheckSupplierArticle(ObjESupplier);
if (!string.IsNullOrEmpty(ObjESupplier.strArticleExists))
{
var _result = XtraMessageBox.Show("Der Artikel gehört nicht zum ausgewählten Lieferant, wollen Sie ihn dennoch hinzufügen?", "Bestätigen..?", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (Convert.ToString(_result).ToLower() == "ok")
{
ObjBSupplier.SaveArticleFromProposal(ObjESupplier);
}
else
{
return;
}
}
if (!string.IsNullOrEmpty(ObjESupplier.strSupplierExists))
{
var _result = XtraMessageBox.Show("Für diesen Lieferanten existiert bereits ein Preisangebot. Wollen Sie ein weiteres Preisangebot hinzufügen?", "Bestätigen..?", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (Convert.ToString(_result).ToLower() != "ok")
{
return;
}
}
_IsSave = true;
this.Close();
}
else
{
throw new Exception("Bitte wählen Sie den Lieferanten, der hinzugefügt werden soll");
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
/// <summary>
/// Code to fetch positions based on supplier proposalID for price comparision module
/// </summary>
/// <param name="ObjESupplier"></param>
/// <param name="_IsCalculate"></param>
/// <returns></returns>
public ESupplier GetProposalPostions(ESupplier ObjESupplier, bool _IsCalculate = true)
{
try
{
ObjESupplier = ObjDSupplier.GetProposalPostions(ObjESupplier);
ObjESupplier.dtPositions.Columns["Cheapest"].Caption = "Niedrigstpreis";
DataTable dtTemp = ObjESupplier.dtPositions.Clone();
ChangeCultureInfo(dtTemp);
foreach (DataColumn dc in dtTemp.Columns)
{
if (dc.ColumnName.Contains("Check"))
{
dc.DataType = System.Type.GetType("System.Boolean");
dc.Caption = "";
}
else if (dtTemp.Columns[dc.ColumnName + "Check"] != null)
{
dc.DataType = System.Type.GetType("System.Decimal");
}
else if (dc.ColumnName.Contains("Multi"))
{
dc.DataType = System.Type.GetType("System.Decimal");
}
}
foreach (DataRow dr in ObjESupplier.dtPositions.Rows)
{
dtTemp.ImportRow(dr);
}
ObjESupplier.dtPositions = new DataTable();
ChangeCultureInfo(ObjESupplier.dtPositions);
ObjESupplier.dtPositions = dtTemp.Copy();
ObjESupplier.dtPositions.Columns.Add("SID", typeof(int));
int iindex = 0;
foreach (DataRow dr in ObjESupplier.dtPositions.Rows)
{
iindex++;
dr["SID"] = iindex;
}
if (_IsCalculate)
{
ObjESupplier = CalculateCheapestValues(ObjESupplier);
}
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to fetch supplier list from database and bind to grid control
/// </summary>
public void BindSupplierData()
{
try
{
ObjESupplier = ObjBSupplier.GetSuppliersForProposal(ObjESupplier);
if (ObjESupplier.dtSupplierForproposal != null)
{
gcSupplier.DataSource = ObjESupplier.dtSupplierForproposal;
gvSupplier.BestFitColumns();
}
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// Code to Update proposal date to supplier proposal after sending to Supplier
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier UpdateProposalDate(ESupplier ObjESupplier)
{
try
{
if (ObjDSupplier == null)
{
ObjDSupplier = new DSupplier();
}
ObjESupplier = ObjDSupplier.UpdateProposalDate(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to Delete Supplier and article mapping
/// </summary>
/// <param name="ObjESupplier"></param>
/// <returns></returns>
public ESupplier DeleteSupplierArticleMap(ESupplier ObjESupplier)
{
try
{
if (ObjDSupplier == null)
{
ObjDSupplier = new DSupplier();
}
ObjESupplier = ObjDSupplier.DeleteSupplierArticleMap(ObjESupplier);
}
catch (Exception ex)
{
throw;
}
return(ObjESupplier);
}
/// <summary>
/// Code to fetch supplier list from database
/// </summary>
/// <param name="ObjEsupplier"></param>
/// <returns></returns>
public ESupplier GetSupplier(ESupplier ObjEsupplier)
{
try
{
if (ObjEsupplier != null)
{
DataSet ds = ObjDSupplier.GetSupplier();
ObjEsupplier.dtSupplier = ds.Tables[0];
ObjEsupplier.dtContact = ds.Tables[1];
ObjEsupplier.dtAddress = ds.Tables[2];
ObjEsupplier.dtArticle = ds.Tables[3];
}
}
catch (Exception ex) { throw; }
return(ObjEsupplier);
}
private void gcArticleDelete_ItemClick(object sender, EventArgs e)
{
try
{
if (ObjBSupplier == null)
{
ObjBSupplier = new BSupplier();
}
int IVlaue = 0;
if (int.TryParse(Convert.ToString(gvArticles.GetFocusedRowCellValue("WGWAID")), out IVlaue))
{
ObjESupplier.WGWAID = IVlaue;
ObjESupplier = ObjBSupplier.DeleteSupplierArticleMap(ObjESupplier);
BindArticleData(ObjESupplier.SupplierID);
}
}
catch (Exception ex) { Utility.ShowError(ex); }
}
private void btnAddSupplier_Click(object sender, EventArgs e)
{
try
{
if (ObjESupplier == null)
{
ObjESupplier = new ESupplier();
}
ObjESupplier.SupplierID = -1;
frmAddSupplier Obj = new frmAddSupplier(ObjESupplier);
Obj.ShowDialog();
if (Obj._IsContinue)
{
BindSupplierData();
Utility.Setfocus(gvSupplier, "SupplierID", ObjESupplier.SupplierID);
}
}
catch (Exception ex) {}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!this.dxValidationProvider1.Validate())
{
return;
}
if (_ObjEsupplier == null)
{
_ObjEsupplier = new ESupplier();
}
ParseSupplierDetails();
ObjBSupplier = new BSupplier();
ObjBSupplier.SaveArticle(_ObjEsupplier);
this.Close();
}
catch (Exception ex) { Utility.ShowError(ex); }
}
