private void tlbMenu_DeleteClick()
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record.?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!ValidarIngreso())
{
ClientBE objE_Client = new ClientBE();
objE_Client.IdClient = int.Parse(gvClient.GetFocusedRowCellValue("IdClient").ToString());
objE_Client.Login = Parametros.strUsuarioLogin;
objE_Client.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Client.IdCompany = Parametros.intEmpresaId;
ClientBL objBL_Client = new ClientBL();
objBL_Client.Elimina(objE_Client);
XtraMessageBox.Show("The record was successfully deleted.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Cargar();
}
}
Cursor = Cursors.Default;
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cboClient_EditValueChanged(object sender, EventArgs e)
{
if (cboClient.EditValue != null)
{
BSUtils.LoaderLook(cboClientBrand, new ClientBrandBL().ListaCertificate(Convert.ToInt32(cboClient.EditValue)), "BrandCertificate", "IdClientBrand", true);
if (pOperacion == Operacion.Nuevo)
{
txtNumberInvoice.Text = CreateNumberInvoice(Convert.ToInt32(cboClient.EditValue));
}
ClientBE objE_Client = null;
objE_Client = new ClientBL().Selecciona(Convert.ToInt32(cboClient.EditValue));
if (objE_Client != null)
{
txtPercentComision.EditValue = objE_Client.PercentComision1;
}
List <ClientAddressBE> lstClientAddress = null;
lstClientAddress = new ClientAddressBL().ListaTodosActivo(Convert.ToInt32(cboClient.EditValue));
if (lstClientAddress.Count > 0)
{
txtAddress.Text = lstClientAddress[0].Destination;
}
List <ClientContactBE> lstClientContact = null;
lstClientContact = new ClientContactBL().ListaTodosActivo(Convert.ToInt32(cboClient.EditValue));
if (lstClientContact.Count > 0)
{
txtContact.Text = lstClientContact[0].Name + " " + lstClientContact[0].FirtsName;
txtOccupation.Text = lstClientContact[0].Occupation;
}
}
}
public ClientBE Selecciona(int IdClient)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Client_Selecciona");
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient);
IDataReader reader = db.ExecuteReader(dbCommand);
ClientBE Client = null;
while (reader.Read())
{
Client = new ClientBE();
Client.IdClient = Int32.Parse(reader["IdClient"].ToString());
Client.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Client.NameClient = reader["NameClient"].ToString();
Client.IdCorporation = Int32.Parse(reader["IdCorporation"].ToString());
Client.NameCorporation = reader["NameCorporation"].ToString();
Client.IdEvaluation = Int32.Parse(reader["IdEvaluation"].ToString());
Client.NameEvaluation = reader["NameEvaluation"].ToString();
Client.RevenueDate = DateTime.Parse(reader["RevenueDate"].ToString());
Client.Certificate = reader["Certificate"].ToString();
Client.PercentComision1 = Decimal.Parse(reader["PercentComision1"].ToString());
Client.PercentComision2 = Decimal.Parse(reader["PercentComision2"].ToString());
Client.PercentComision3 = Decimal.Parse(reader["PercentComision3"].ToString());
Client.Comment = reader["Comment"].ToString();
Client.Situation = reader["Situation"].ToString();
Client.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Client);
}
public Int32 Inserta(ClientBE pItem)
{
int intIdClient = 0;
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Client_Inserta");
db.AddOutParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pNameClient", DbType.String, pItem.NameClient);
db.AddInParameter(dbCommand, "pIdCorporation", DbType.Int32, pItem.IdCorporation);
db.AddInParameter(dbCommand, "pIdEvaluation", DbType.Int32, pItem.IdEvaluation);
db.AddInParameter(dbCommand, "pRevenueDate", DbType.DateTime, pItem.RevenueDate);
db.AddInParameter(dbCommand, "pCertificate", DbType.String, pItem.Certificate);
db.AddInParameter(dbCommand, "pPercentComision1", DbType.Decimal, pItem.PercentComision1);
db.AddInParameter(dbCommand, "pPercentComision2", DbType.Decimal, pItem.PercentComision2);
db.AddInParameter(dbCommand, "pPercentComision3", DbType.Decimal, pItem.PercentComision3);
db.AddInParameter(dbCommand, "pComment", DbType.String, pItem.Comment);
db.AddInParameter(dbCommand, "pFlagState", DbType.Boolean, pItem.FlagState);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
intIdClient = (int)db.GetParameterValue(dbCommand, "pIdClient");
return(intIdClient);
}
public ClientBE SeleccionaDescripcion(int IdCompany, string NameClient)
{
try
{
ClientDL Client = new ClientDL();
ClientBE objEmp = Client.SeleccionaDescripcion(IdCompany, NameClient);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public ClientBE Selecciona(int IdClient)
{
try
{
ClientDL Client = new ClientDL();
ClientBE objEmp = Client.Selecciona(IdClient);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(ClientBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Client_Elimina");
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
}
public void InicializarModificar()
{
if (gvClient.RowCount > 0)
{
ClientBE objClient = new ClientBE();
objClient.IdClient = int.Parse(gvClient.GetFocusedRowCellValue("IdClient").ToString());
frmRegClientEdit objManClientEdit = new frmRegClientEdit();
objManClientEdit.pOperacion = frmRegClientEdit.Operacion.Modificar;
objManClientEdit.IdClient = objClient.IdClient;
objManClientEdit.StartPosition = FormStartPosition.CenterParent;
objManClientEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
private string CreateNumberInvoice(int IdClient)
{
string strNumberInvoice = "";
try
{
Cursor = Cursors.WaitCursor;
string strAbrevClient = "";
int intNumero = 0;
string strNumero = "";
ClientBE objE_Client = null;
objE_Client = new ClientBL().Selecciona(IdClient);
if (objE_Client != null)
{
strAbrevClient = objE_Client.Certificate;
}
intNumero = new InvoiceBL().SeleccionaBusquedaCount(Parametros.intEmpresaId, Convert.ToInt32(cboClient.EditValue));
strNumero = FuncionBase.AgregarCaracter(intNumero.ToString(), "0", 5);
strNumberInvoice = strAbrevClient + Parametros.intPeriodo.ToString().Substring(2, 2) + strNumero;
Cursor = Cursors.Default;
return(strNumberInvoice);
}
catch (Exception ex)
{
Cursor = Cursors.Default;
return(strNumberInvoice);
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void ExportarExcel(string filename)
{
Excel._Application xlApp;
Excel._Workbook xlLibro;
Excel._Worksheet xlHoja;
Excel.Sheets xlHojas;
xlApp = new Excel.Application();
filename = Path.Combine(Directory.GetCurrentDirectory(), "Excel\\InspectionCertificate.xlsx");
xlLibro = xlApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlHojas = xlLibro.Sheets;
xlHoja = (Excel._Worksheet)xlHojas[1];
Cursor.Current = Cursors.WaitCursor;
string strNameStatus = "";
decimal decComision = 0;
int intPercent = 0;
decimal decTotal = 0;
decimal decTotalComision = 0;
string strComision = "";
ClientBE objE_Client = null;
objE_Client = new ClientBL().Selecciona(Convert.ToInt32(cboClient.EditValue));
if (objE_Client != null)
{
decComision = objE_Client.PercentComision1;
}
xlHoja.Shapes.AddPicture(Path.Combine(Directory.GetCurrentDirectory(), "Logo.jpg"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 1, 1, 100, 60);
try
{
int Row = 7;
int Secuencia = 1;
xlHoja.Cells[4, 2] = cboClient.Text;
int[] rows = gvInspectionCertificate.GetSelectedRows();
for (int i = 0; i < rows.Length; i++)
{
strNameStatus = "";
xlHoja.Cells[Row, 1] = gvInspectionCertificate.GetRowCellValue(rows[i], "NumberCertificate").ToString();
xlHoja.Cells[Row, 2] = BSUtils.GetDateFormat(DateTime.Parse(gvInspectionCertificate.GetRowCellValue(rows[i], "IssueDate").ToString()));
xlHoja.Cells[Row, 3] = gvInspectionCertificate.GetRowCellValue(rows[i], "NumberPO").ToString();
xlHoja.Cells[Row, 4] = gvInspectionCertificate.GetRowCellValue(rows[i], "NumberOI").ToString();
xlHoja.Cells[Row, 5] = gvInspectionCertificate.GetRowCellValue(rows[i], "NumberInvoice").ToString();
xlHoja.Cells[Row, 6] = gvInspectionCertificate.GetRowCellValue(rows[i], "NameVendor").ToString();
xlHoja.Cells[Row, 7] = gvInspectionCertificate.GetRowCellValue(rows[i], "Amount").ToString();
xlHoja.Cells[Row, 8] = gvInspectionCertificate.GetRowCellValue(rows[i], "NameTypeShipping").ToString();
strNameStatus = gvInspectionCertificate.GetRowCellValue(rows[i], "NameStatus").ToString();
xlHoja.Cells[Row, 9] = strNameStatus;
if (strNameStatus == "ACTIVE" || strNameStatus == "FINISHED")
{
decTotal = decTotal + decimal.Parse(gvInspectionCertificate.GetRowCellValue(rows[i], "Amount").ToString());
}
Row = Row + 1;
Secuencia = Secuencia + 1;
}
decTotalComision = decTotal * decComision;
intPercent = Convert.ToInt32(decComision * 100);
strComision = "COMMISSION " + intPercent.ToString() + " % US$ :";
xlHoja.Cells[Row + 2, 6].EntireRow.Font.Bold = true;
xlHoja.Cells[Row + 2, 6].EntireRow.Font.Size = 12;
xlHoja.Cells[Row + 2, 6] = "TOTAL US$ : ";
xlHoja.Cells[Row + 3, 6].EntireRow.Font.Bold = true;
xlHoja.Cells[Row + 3, 6].EntireRow.Font.Size = 12;
xlHoja.Cells[Row + 3, 6] = strComision;
xlHoja.Cells[Row + 2, 7].EntireRow.Font.Bold = true;
xlHoja.Cells[Row + 2, 7].EntireRow.Font.Size = 12;
xlHoja.Cells[Row + 2, 7] = decTotal;
xlHoja.Cells[Row + 3, 7].EntireRow.Font.Bold = true;
xlHoja.Cells[Row + 3, 7].EntireRow.Font.Size = 12;
xlHoja.Cells[Row + 3, 7] = decTotalComision;
xlLibro.SaveAs("C:\\Excel\\InspectionCertificate.xlsx", Excel.XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlLibro.Close(true, Missing.Value, Missing.Value);
xlApp.Quit();
Cursor.Current = Cursors.Default;
BSUtils.OpenExcel("C:\\Excel\\InspectionCertificate.xlsx");
//XtraMessageBox.Show("It was imported correctly \n The file was generated C:\\Excel\\InspectionCertificate.xlsx", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
Cursor.Current = Cursors.Default;
MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void ImportarExcel()
{
if (strFleExcel == "")
{
return;
}
Excel._Application xlApp;
Excel._Workbook xlLibro;
Excel._Worksheet xlHoja;
Excel.Sheets xlHojas;
xlApp = new Excel.Application();
xlLibro = xlApp.Workbooks.Open(strFleExcel, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlHojas = xlLibro.Sheets;
xlHoja = (Excel._Worksheet)xlHojas[1];
int Secuencia = 2;
int _row = 2;
int _totRow = 2;
try
{
List <StyleBE> lstStyle = new List <StyleBE>();
while (FuncionBase.IsNumeric((string)xlHoja.get_Range("A" + _row, Missing.Value).Text.ToString().Trim()))
{
//Declaracion de variables
int IdCompany = 0;
int intIdClient = 0;
string strNameClient = "";
string strNameStyle = "";
DateTime RevenueDate = new DateTime(2010, 1, 1);
string strDescription = "";
int intIdClientDepartment = 0;
string strNameDivision = "";
int IdMediaUnit = 0;
string strAbbreviate = "";
strNameClient = (string)xlHoja.get_Range("B" + _row, Missing.Value).Text.ToString().Trim();
ClientBE objE_Client = null;
objE_Client = new ClientBL().SeleccionaDescripcion(Parametros.intEmpresaId, strNameClient);
if (objE_Client != null)
{
intIdClient = objE_Client.IdClient;
strNameStyle = (string)xlHoja.get_Range("C" + _row, Missing.Value).Text.ToString().Trim();
RevenueDate = Convert.ToDateTime(xlHoja.get_Range("D" + _row, Missing.Value).Text.ToString().Trim());
strDescription = (string)xlHoja.get_Range("E" + _row, Missing.Value).Text.ToString().Trim();
strNameDivision = (string)xlHoja.get_Range("F" + _row, Missing.Value).Text.ToString().Trim();
ClientDepartmentBE objE_ClientDepartment = null;
objE_ClientDepartment = new ClientDepartmentBL().SeleccionaDescripcion(intIdClient, strNameDivision);
if (objE_ClientDepartment != null)
{
intIdClientDepartment = objE_ClientDepartment.IdClientDepartment;
}
else
{
XtraMessageBox.Show("N° Secuencia : " + Secuencia.ToString() + "\n Division: " + strNameDivision, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
this.Dispose();
this.Close();
}
strAbbreviate = (string)xlHoja.get_Range("G" + _row, Missing.Value).Text.ToString().Trim();
MediaUnitBE objE_MediaUnit = null;
objE_MediaUnit = new MediaUnitBL().SeleccionaAbreviatura(Parametros.intEmpresaId, strAbbreviate);
if (objE_MediaUnit != null)
{
IdMediaUnit = objE_MediaUnit.IdMediaUnit;
}
else
{
XtraMessageBox.Show("N° Secuencia : " + Secuencia.ToString() + "\n Media Unit: " + strAbbreviate, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
this.Dispose();
this.Close();
}
StyleBE objE_Style = new StyleBE();
objE_Style.IdStyle = 0;
objE_Style.IdCompany = Parametros.intEmpresaId;
objE_Style.IdClient = intIdClient;
objE_Style.NameStyle = strNameStyle;
objE_Style.RevenueDate = RevenueDate;
objE_Style.Description = strDescription;
objE_Style.IdClientDepartment = intIdClientDepartment;
objE_Style.IdMediaUnit = IdMediaUnit;
objE_Style.FlagState = true;
objE_Style.Login = Parametros.strUsuarioLogin;
objE_Style.Machine = WindowsIdentity.GetCurrent().Name.ToString();
lstStyle.Add(objE_Style);
}
Application.DoEvents();
_row++;
Secuencia++;
}
StyleBL objBL_Style = new StyleBL();
objBL_Style.InsertaMasivo(lstStyle);
XtraMessageBox.Show("Los Datos se guardaron conrrectamente.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
this.Close();
}
catch (Exception ex)
{
xlApp.Quit();
XtraMessageBox.Show(ex.Message + "\n N° Secuencia : " + Secuencia.ToString(), ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
public Int32 Inserta(ClientBE pItem, List <ClientAddressBE> pListaClientAddress, List <ClientContactBE> pListaClientContact, List <ClientDepartmentBE> pListaClientDepartment, List <ClientDocumentBE> pListaClientDocument, List <ClientGoalBE> pListaClientGoal, List <ClientBrandBE> pListaClientBrand)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ClientDL Client = new ClientDL();
ClientAddressDL ClientAddress = new ClientAddressDL();
ClientContactDL ClientContact = new ClientContactDL();
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDocumentDL ClientDocument = new ClientDocumentDL();
ClientGoalDL ClientGoal = new ClientGoalDL();
ClientBrandDL ClientBrand = new ClientBrandDL();
int IdClient = 0;
IdClient = Client.Inserta(pItem);
foreach (var item in pListaClientAddress)
{
item.IdClient = IdClient;
ClientAddress.Inserta(item);
}
foreach (var item in pListaClientContact)
{
item.IdClient = IdClient;
ClientContact.Inserta(item);
}
foreach (var item in pListaClientDepartment)
{
item.IdClient = IdClient;
ClientDepartment.Inserta(item);
}
foreach (var item in pListaClientDocument)
{
item.IdClient = IdClient;
ClientDocument.Inserta(item);
}
foreach (var item in pListaClientGoal)
{
item.IdClient = IdClient;
ClientGoal.Inserta(item);
}
foreach (var item in pListaClientBrand)
{
item.IdClient = IdClient;
ClientBrand.Inserta(item);
}
ts.Complete();
return(IdClient);
}
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(ClientBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ClientDL Client = new ClientDL();
ClientAddressDL ClientAddress = new ClientAddressDL();
ClientContactDL ClientContact = new ClientContactDL();
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDocumentDL ClientDocument = new ClientDocumentDL();
ClientGoalDL ClientGoal = new ClientGoalDL();
ClientBrandDL ClientBrand = new ClientBrandDL();
//Client SENSOR
List <ClientAddressBE> lstClientAddress = null;
lstClientAddress = new ClientAddressDL().ListaTodosActivo(pItem.IdClient);
foreach (var item in lstClientAddress)
{
ClientAddress.Elimina(item);
}
//Client VERIFICACIÓN
List <ClientContactBE> lstClientContact = null;
lstClientContact = new ClientContactDL().ListaTodosActivo(pItem.IdClient);
foreach (var item in lstClientContact)
{
ClientContact.Elimina(item);
}
//Client MOVIMIENTO
List <ClientDepartmentBE> lstClientDepartment = null;
lstClientDepartment = new ClientDepartmentDL().ListaTodosActivo(pItem.IdClient);
foreach (var item in lstClientDepartment)
{
ClientDepartment.Elimina(item);
}
//Client DIAGNOSTICO
List <ClientDocumentBE> lstClientDocument = null;
lstClientDocument = new ClientDocumentDL().ListaTodosActivo(pItem.IdClient);
foreach (var item in lstClientDocument)
{
ClientDocument.Elimina(item);
}
//CLIENT GOAL
List <ClientGoalBE> lstClientGoal = null;
lstClientGoal = new ClientGoalDL().ListaTodosActivo(pItem.IdClient);
foreach (var item in lstClientGoal)
{
ClientGoal.Elimina(item);
}
//Client BRAND
List <ClientBrandBE> lstClientBrand = null;
lstClientBrand = new ClientBrandDL().ListaTodosActivo(pItem.IdClient);
foreach (var item in lstClientBrand)
{
ClientBrand.Elimina(item);
}
Client.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(ClientBE pItem, List <ClientAddressBE> pListaClientAddress, List <ClientContactBE> pListaClientContact, List <ClientDepartmentBE> pListaClientDepartment, List <ClientDocumentBE> pListaClientDocument, List <ClientGoalBE> pListaClientGoal, List <ClientBrandBE> pListaClientBrand)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ClientDL Client = new ClientDL();
ClientAddressDL ClientAddress = new ClientAddressDL();
ClientContactDL ClientContact = new ClientContactDL();
ClientDepartmentDL ClientDepartment = new ClientDepartmentDL();
ClientDocumentDL ClientDocument = new ClientDocumentDL();
ClientGoalDL ClientGoal = new ClientGoalDL();
ClientBrandDL ClientBrand = new ClientBrandDL();
foreach (var item in pListaClientAddress)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdClient = pItem.IdClient;
ClientAddress.Inserta(item);
}
else
{
ClientAddress.Actualiza(item);
}
}
foreach (var item in pListaClientContact)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdClient = pItem.IdClient;
ClientContact.Inserta(item);
}
else
{
ClientContact.Actualiza(item);
}
}
foreach (var item in pListaClientDepartment)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdClient = pItem.IdClient;
ClientDepartment.Inserta(item);
}
else
{
ClientDepartment.Actualiza(item);
}
}
foreach (var item in pListaClientDocument)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdClient = pItem.IdClient;
ClientDocument.Inserta(item);
}
else
{
ClientDocument.Actualiza(item);
}
}
foreach (var item in pListaClientGoal)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdClient = pItem.IdClient;
ClientGoal.Inserta(item);
}
else
{
ClientGoal.Actualiza(item);
}
}
foreach (var item in pListaClientBrand)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdClient = pItem.IdClient;
ClientBrand.Inserta(item);
}
else
{
ClientBrand.Actualiza(item);
}
}
Client.Actualiza(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
void ExportarExcel(string filename)
{
Excel._Application xlApp;
Excel._Workbook xlLibro;
Excel._Worksheet xlHoja;
Excel.Sheets xlHojas;
xlApp = new Excel.Application();
filename = Path.Combine(Directory.GetCurrentDirectory(), "Excel\\ProductionProgramClient.xlsx");
xlLibro = xlApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlHojas = xlLibro.Sheets;
xlHoja = (Excel._Worksheet)xlHojas[1];
Cursor.Current = Cursors.WaitCursor;
try
{
int Row = 6;
int Secuencia = 1;
List <ReporteProgramProductionBE> lstReporteProgramProduction = null;
lstReporteProgramProduction = new ReporteProgramProductionBL().ListadoClient(Parametros.intEmpresaId, Convert.ToInt32(cboClient.EditValue), Convert.ToInt32(txtPeriodo.EditValue));
if (lstReporteProgramProduction.Count > 0)
{
string strTitulo = "";
strTitulo = "SUMMARY PROG PROD " + cboClient.Text.ToString() + " " + txtPeriodo.Text.ToString();
xlHoja.Cells[2, 1] = strTitulo;
decimal decComision = 0;
ClientBE objE_Client = null;
objE_Client = new ClientBL().Selecciona(Convert.ToInt32(cboClient.EditValue));
if (objE_Client != null)
{
decComision = objE_Client.PercentComision1;
}
xlHoja.Shapes.AddPicture(Path.Combine(Directory.GetCurrentDirectory(), "Logo.jpg"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 1, 1, 100, 60);
foreach (var item in lstReporteProgramProduction)
{
xlHoja.Cells[Row, 2] = item.TotalUnits;
xlHoja.Cells[Row, 3] = item.TotalFob;
xlHoja.Cells[Row, 4] = decComision;
Row = Row + 1;
Secuencia = Secuencia + 1;
}
}
xlLibro.SaveAs("C:\\Excel\\ProductionProgramClient.xlsx", Excel.XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlLibro.Close(true, Missing.Value, Missing.Value);
xlApp.Quit();
Cursor.Current = Cursors.Default;
BSUtils.OpenExcel("C:\\Excel\\ProductionProgramClient.xlsx");
//XtraMessageBox.Show("It was imported correctly \n The file was generated C:\\Excel\\Classification.xlsx", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
Cursor.Current = Cursors.Default;
MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
