private ExchangeCompositeType HeaderReq()
{
try
{
var ect = new ExchangeCompositeType();
ect.iIdClient = int.Parse(ddlClient.SelectedValue);
ect.iIdExchangeType = int.Parse(ddlExchange.SelectedValue);
ect.iIdPlant = int.Parse(ddlPlant.SelectedValue);
ect.iIdPriority = int.Parse(ddlPriority.SelectedValue);;
ect.iProductEngener = int.Parse(ddlEngeenerProduct.SelectedValue);
ect.iSerie = int.Parse(ddlSerie.SelectedValue);
ect.sContact = txtContact.Text.Trim();
ect.sDescription = txtDescription.Text.Trim();
ect.sIssue = txtIssue.Text.Trim();
ect.sMeasure = txtAction.Text.Trim();
ect.sProyect = txtProyectPlataformDescription.Text.Trim();
ect.sReason = txtReason.Text.Trim();
ect.dLimitDate = calLimite.SelectedDate.Value;
ect.sLastFolio = txtLastFolio.Text.Trim();
return(ect);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void Quote()
{
if (ddlNoPartCot.Items.Count > 0)
{
pnQuote.Visible = true;
pnQuoteNon.Visible = false;
var plct = new PartListCompositeType();
var plm = new PartListManager();
var ect = new ExchangeCompositeType();
var em = new ExchangeManager();
plct = plm.getPartListById(int.Parse(ddlNoPartCot.SelectedValue.ToString()));
ect = em.getExchangeById(int.Parse(lblIdExchange.Text));
lblNoPartC.Text = plct.iNumber.ToString();
lblNoPartClientC.Text = plct.iNumberClient.ToString();
lblProyectc.Text = ect.sProyect.ToString();
lblPartList.Text = plct.iIdPart.ToString();
lblDescriptionC.Text = "Descripcion del Cambio: " + ect.sDescription.ToString();
ddlAfectationCot.DataBind();
calculate();
}
else
{
pnQuote.Visible = false;
pnQuoteNon.Visible = true;
}
}
protected void btnGenerateFolio_Click(object sender, EventArgs e)
{
try
{
util.GetActionMenu(mpMenu.SelectedItem.Value);
var ect = new ExchangeCompositeType();
var em = new ExchangeManager();
var tem = new TaskExchangeManager(); //Add
ect = em.getExchangeById(int.Parse(lblIdExchange.Text));
int iMax = tem.getMaxTimingByIdExchange(ect); //Add
DateTime dAplication = calAplicationDate.SelectedDate.Value;
dAplication.AddDays(iMax * 7); //Add
tem.UpdateTime_byGenerate(int.Parse(lblIdExchange.Text), calAplicationDate.SelectedDate.Value, ((RadButton)sender).ID);
//Add DateTime dAplication = DateTime.Parse(txtAplicationDate.Text);
ect.dAplicationDate = dAplication;
ect.iStatus = 12;
//Add em.UpdateExchange(ect);
em.UpdateExchangeDate(ect);
lblFolioGen.Text = ((DateTime)ect.dAplicationDate).ToShortDateString().ToString();
pnGenerateFolio.Visible = false;
pnFolio.Visible = true;
}
catch (AccessViolationException ave)
{
Alert.Permisos(this.Page);
}
catch (Exception ex)
{
util.ErroDisplay(1, ex.Message, ref lblMessage);
}
}
private ExchangeCompositeType Data2Exchange(DataTable dt)
{
var ect = new ExchangeCompositeType();
try
{
if (dt.Rows[0].ItemArray[18].ToString() != "")
{
ect.dAplicationDate = DateTime.Parse(dt.Rows[0].ItemArray[18].ToString());
}
if (dt.Rows[0].ItemArray[8].ToString() != "")
{
ect.dLimitDate = DateTime.Parse(dt.Rows[0].ItemArray[8].ToString());
}
if (dt.Rows[0].ItemArray[27].ToString() != "")
{
ect.dInitChange = DateTime.Parse(dt.Rows[0].ItemArray[27].ToString());
}
ect.iIdClient = int.Parse(dt.Rows[0].ItemArray[13].ToString());
ect.iIdExchange = int.Parse(dt.Rows[0].ItemArray[0].ToString());
ect.iIdExchangeType = int.Parse(dt.Rows[0].ItemArray[12].ToString());
ect.iIdPlant = int.Parse(dt.Rows[0].ItemArray[11].ToString());
ect.iIdPriority = int.Parse(dt.Rows[0].ItemArray[15].ToString());
ect.iProductEngener = int.Parse(dt.Rows[0].ItemArray[17].ToString());
ect.iSerie = int.Parse(dt.Rows[0].ItemArray[16].ToString());
ect.iStatus = int.Parse(dt.Rows[0].ItemArray[10].ToString());
ect.sClient = dt.Rows[0].ItemArray[19].ToString();
ect.sContact = dt.Rows[0].ItemArray[4].ToString();
ect.sDescription = dt.Rows[0].ItemArray[1].ToString();
ect.sExchangeType = dt.Rows[0].ItemArray[20].ToString();
ect.sFolio = dt.Rows[0].ItemArray[5].ToString();
ect.sFolioPre = dt.Rows[0].ItemArray[6].ToString();
ect.sIssue = dt.Rows[0].ItemArray[2].ToString();
ect.sLastFolio = dt.Rows[0].ItemArray[9].ToString();
ect.sMeasure = dt.Rows[0].ItemArray[3].ToString();
ect.sPlant = dt.Rows[0].ItemArray[21].ToString();
ect.sPriority = dt.Rows[0].ItemArray[22].ToString();
ect.sProductEngener = dt.Rows[0].ItemArray[23].ToString();
ect.sProyect = dt.Rows[0].ItemArray[7].ToString();
ect.sReason = dt.Rows[0].ItemArray[14].ToString();
ect.sSerie = dt.Rows[0].ItemArray[24].ToString();
if (dt.Rows[0].ItemArray[25].ToString() != "0" && dt.Rows[0].ItemArray[25].ToString() != null &&
dt.Rows[0].ItemArray[25].ToString() != "")
{
ect.iReview = int.Parse(dt.Rows[0].ItemArray[25].ToString());
ect.iTimingExchange = int.Parse(dt.Rows[0].ItemArray[26].ToString());
}
else
{
ect.iReview = 0;
ect.iTimingExchange = 0;
}
return(ect);
}
catch
{
return(null);
}
}
public ExchangeCompositeType getExchangeByPreFolioUnique(String sPrefolio)
{
var ect = new ExchangeCompositeType();
var e = new Exchange();
ect = e.getExchangeByPreFolioUnique(sPrefolio);
return(ect);
}
private void UpdateExchange(int iIdExchange)
{
try
{
var em = new ExchangeManager();
Exchange = em.getExchangeById(iIdExchange);
}
catch (Exception ex)
{
throw new Exception();
}
}
protected void btnUpdateExchange_Documents_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
util.GetActionMenu(mpMenu.SelectedItem.Value);
CamposRequeridos();
var ect = HeaderReq();
var ectNow = new ExchangeCompositeType();
var em = new ExchangeManager();
ect = em.getExchangeById(int.Parse(lblIdExchange.Text.Trim()));
ect.iStatus = 2;
em.UpdateExchange(ect, ((RadButton)sender).ID);
ectNow = em.getExchangeByPreFolioUnique(ect.sFolioPre);
lblIdExchange.Text = ectNow.iIdExchange.ToString();
if (ddlExchange.SelectedItem.Text.Contains("Cambio"))
{
var adm = new AffectationDocumentsManager();
if (adm.GetCountAffectationDocumentsByIdExchange(int.Parse(lblIdExchange.Text.ToString())) > 0)
{
adm.UpdateAffectationDocuments(Afectacion());
}
else
{
adm.AddAffectationDocuments(Afectacion());
}
}
BlockControls();
btnClean.Visible = true;
btnGenetate.Visible = false;
lblPrefolio.Visible = true;
lblPrefolioTitle.Visible = true;
btnUpdateExchange_Documents.Visible = false;
btnExchangeUpdate.Visible = true;
lblPrefolio.Text = ectNow.sFolioPre;
txtSrchPreFol.Text = ectNow.sFolioPre;
gvExchange.DataBind();
}
catch (AccessViolationException ave)
{
Alert.Permisos(this.Page);
}
catch (ArgumentException ae)
{
util.ErroDisplay(3, ae.Message, ref lblMessage);
}
catch (Exception ex)
{
util.ErroDisplay(1, ex.Message, ref lblMessage);
}
}
public MailMessage CreateMail(ExchangeCompositeType ect, string sIPAddress, int iPort, String sType, String sText)
{
string body;
string subject = "SACI - Notificación Instrucción.";
MailMessage eMail;
body = "<HTML><HEAD><META http-equiv=Content-Type content=text/html; charset=UTF-8>"
+ "</HEAD><BODY><DIV><p><FONT face=Arial color=#000000 size=2>"
//+ "Correo Prueba Desarrollo"
+ "<table width='391' border='0' cellspacing='5' >"
+ " <tr>"
+ " <td width='12'><b></td>"
+ " <td width='101'></td>"
+ " <td width='255'><B>Estimado usuario: </td>"
+ " <td width='5'> </td>"
+ " </tr>"
+ " <tr>"
+ " <td> </td>"
+ " <td><B></td>"
+ " <td><B> Sele informa que el: " + sType + "</td>"
+ " <td> </td>"
+ " </tr>"
+ " <tr>"
+ " <td> </td>"
+ " <td>Descripción: </td>"
+ " <td><B>" + ect.sDescription + "</td>"
+ " <td> </td>"
+ " </tr>"
+ " <tr>"
+ " <td> </td>"
+ " <td>Proyecto: </td>"
+ " <td>" + ect.sProyect + "</td>"
+ " <td> </td>"
+ " </tr>"
+ " <tr>"
+ " <td> </td>"
+ " <td><B>Ha Sido: </td>"
+ " <td><B>" + sText + "</td>"
+ " <td> </td>"
+ " </tr>"
+ "</table></FONT></DIV></body></html>";
String mail = System.Configuration.ConfigurationSettings.AppSettings["mailAddres"].ToString();
eMail = MakeMail(mail, subject, body);
return(eMail);
}
//Add
public errorCompositeType UpdateExchangeDate(ExchangeCompositeType ectExchange)
{
var lstError = new errorCompositeType();
try
{
var et = new Exchange();
et.UpdateExchangeDateById(ectExchange);
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public PDFManager(int iExchange, string serverPath)
{
ServerPath = serverPath;
ex = new ExchangeCompositeType();
adct = new affectationDocumentsCompositeType();
var em = new ExchangeManager();
ex = em.getExchangeById(iExchange);
var adm = new AffectationDocumentsManager();
adct = adm.GetAffectationDocumentsByIdExchange(iExchange);
var objAutorization = new TaskAutorizationManager();
dtAutorization = objAutorization.GetAll(iExchange);
var objPartList = new PartListExchangeManager();
lPartList = new List <PartListExchangeCompositeType>();
lPartList = objPartList.getAllPartListExchange(iExchange);
lockClose = true;
}
private void HeaderReq(ref ExchangeCompositeType ect, bool bGenerate)
{
try
{
ect.iIdClient = int.Parse(ddlClient.SelectedValue);
ect.iIdExchangeType = int.Parse(ddlExchange.SelectedValue);
ect.iIdPlant = int.Parse(ddlPlant.SelectedValue);
ect.iIdPriority = int.Parse(ddlPriority.SelectedValue);;
ect.iProductEngener = int.Parse(ddlEngeenerProduct.SelectedValue);
ect.iSerie = int.Parse(ddlSerie.SelectedValue);
ect.sContact = txtContact.Text.Trim();
ect.sDescription = txtDescription.Text.Trim();
ect.sIssue = txtIssue.Text.Trim();
ect.sMeasure = txtAction.Text.Trim();
ect.sProyect = txtProyectPlataformDescription.Text.Trim();
ect.sReason = txtReason.Text.Trim();
ect.dLimitDate = calLimitDate.SelectedDate.Value;
ect.sLastFolio = txtLastFolio.Text.Trim();
if (bGenerate)
{
ect.iStatus = 6;
var em = new ExchangeManager();
//SITI - CAFC 24102011 Corrección para generar el folio acorde a la letra inicial
String sFolio = ddlSerie.SelectedItem.Text.Substring(0, 1) + DateTime.Today.Year.ToString().Substring(2, 2) +
ddlExchange.SelectedItem.Text.Substring(0, 1) + String.Format("{0:0000}", em.GetNumberFolio());
ect.sFolio = sFolio;
ect.sFolioPre = "0";
}
else
{
ect.iStatus = 2;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void btnGenetate_Click(object sender, EventArgs e)
{
try
{
util.GetActionMenu(mpMenu.SelectedItem.Value);
lblMessage.Text = "";
Util.validateDatesHomeEnd(calLimitDate.SelectedDate.ToString(), "Fecha Limite");
CamposRequeridos();
var em = new ExchangeManager();
var ect = new ExchangeCompositeType();
HeaderReq(ref ect, true);
em.AddExchange(ect, true);
var ectNow = em.getExchangeByPreFolioUnique(0.ToString());
lblIdExchange.Text = ectNow.iIdExchange.ToString();
AddDocumentosAfectados();
BlockControls();
btnClean.Visible = true;
btnGenetate.Visible = false;
lblPrefolio.Visible = true;
lblPrefolioTitle.Visible = true;
btnUpdateExchangeOk.Visible = false;
btnExchangeUpdate.Visible = true;
lblPrefolio.Text = ectNow.sFolio; //Add
txtSrchPreFol.Text = ectNow.sFolio; //Add
}
catch (AccessViolationException ave)
{
Alert.Permisos(this.Page);
}
catch (ArgumentException ae)
{
util.ErroDisplay(3, ae.Message, ref lblMessage);
}
catch (Exception ex)
{
util.ErroDisplay(1, ex.Message, ref lblMessage);
}
}
public errorCompositeType AddExchange(ExchangeCompositeType ectExchange, bool bInicial)
{
var lstError = new errorCompositeType();
try
{
var et = new Exchange();
et.InsertExchange(ectExchange, bInicial);
//var mail = new BuzonManager();
//Action asyncMail = mail.SendMail_SMTP(swap, "Mensaje de prueba", "Prueba de envio");
//mail.SendMail_SMTP(null, "Test", "Test");
lstError.bError = true;
lstError.sError = "";
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
private void Menu_Confirmacion(string title, int iIdExchange)
{
if (Menu_Generic(title, iIdExchange, 7))
{
var ect = new ExchangeCompositeType();
var em = new ExchangeManager();
pnAnalize.Visible = true;
calAplicationDate.MinDate = DateTime.Now;
calAplicationDate.SelectedDate = DateTime.Now;
ect = em.getExchangeById(int.Parse(lblIdExchange.Text.ToString()));
if (ect.dAplicationDate == null || ect.dAplicationDate.ToString() == "" || ect.dAplicationDate.ToString() == "0" || ect.dAplicationDate.ToString().Substring(0, 10) == "01/01/0001")
{
pnGenerateFolio.Visible = true;
pnFolio.Visible = false;
}
else
{
pnGenerateFolio.Visible = false;
pnFolio.Visible = true;
lblFolioGen.Text = ((DateTime)ect.dAplicationDate).ToShortDateString();
}
}
}
protected void btnUpdateExchangeOk_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
util.GetActionMenu(mpMenu.SelectedItem.Value);
var em = new ExchangeManager();
ExchangeCompositeType ect = em.getExchangeById(int.Parse(lblIdExchange.Text));
HeaderReq(ref ect, false);
em.UpdateExchange(ect, ((RadButton)sender).ID);
ExchangeCompositeType ectNow = em.getExchangeByPreFolioUnique(ect.sFolioPre);
lblIdExchange.Text = ectNow.iIdExchange.ToString();
AddDocumentosAfectados();
BlockControls();
btnClean.Visible = true;
btnGenetate.Visible = false;
lblPrefolio.Visible = true;
lblPrefolioTitle.Visible = true;
btnUpdateExchangeOk.Visible = false;
btnExchangeUpdate.Visible = true;
lblPrefolio.Text = ectNow.sFolio;
txtSrchPreFol.Text = ectNow.sFolio;
}
catch (AccessViolationException ave)
{
Alert.Permisos(this.Page);
}
catch (ArgumentException ae)
{
util.ErroDisplay(3, ae.Message, ref lblMessage);
}
catch (Exception ex)
{
util.ErroDisplay(1, ex.Message.ToString(), ref lblMessage);
}
}
public int getMaxTimingByIdExchange(ExchangeCompositeType ect)
{
int a = te.GetMaxTimingTaskExchangeByIdExchange(ect);
return(a);
}
private void selectedExchange(int iIdExchange)
{
var ex = new ExchangeCompositeType();
var em = new ExchangeManager();
ViewState["Exchange"] = iIdExchange;
ex = em.getExchangeById(iIdExchange);
if (ex != null)
{
lblPrefolio.Text = ex.sFolio;
lblIdExchange.Text = ex.iIdExchange.ToString();
try
{
ddlExchange.SelectedValue = ex.iIdExchangeType.ToString();
ddlPlant.SelectedValue = ex.iIdPlant.ToString();
ddlPriority.SelectedValue = ex.iIdPriority.ToString();
ddlClient.SelectedValue = ex.iIdClient.ToString();
ddlSerie.SelectedValue = ex.iSerie.ToString();
ddlEngeenerProduct_Asignacion(iIdExchange, ex.iProductEngener);
}
catch (Exception e)
{
Response.Redirect("/Error/PageError.aspx?ex=" + iIdExchange + "er=ddl", true);
}
txtAction.Text = ex.sMeasure;
txtContact.Text = ex.sContact;
txtDescription.Text = ex.sDescription;
txtIssue.Text = ex.sIssue;
try
{
calLimitDate.SelectedDate = ex.dInitChange as DateTime?;
}
catch (Exception e)
{
calLimitDate.SelectedDate = null;
}
txtLastFolio.Text = ex.sLastFolio;
txtProyectPlataformDescription.Text = ex.sProyect;
txtReason.Text = ex.sReason;
BlockControls();
CleanControls();
if (ex.sExchangeType.Contains("Cambio"))
{
pnDocuments.Visible = true;
var adm = new AffectationDocumentsManager();
var adct = adm.GetAffectationDocumentsByIdExchange(iIdExchange);
chkAMEF.Checked = adct.bAMEF;
chkCost.Checked = adct.bCost;
chkDevices.Checked = adct.bDevices;
chkDrawing.Checked = adct.bDrawing;
chkEspecification.Checked = adct.bEspecifications;
chkHOE.Checked = adct.bHOE;
chkMedia.Checked = adct.bMedia;
chkMold.Checked = adct.bMold;
chkOthers.Checked = adct.bOthers;
chkPlan.Checked = adct.bPlan;
chkSAP.Checked = adct.bSAP;
chkSing.Checked = adct.bSingOff;
}
else
{
pnDocuments.Visible = false;
}
lblPrefolio.Text = ex.sFolio;
txtSrchPreFol.Text = ex.sFolio;
lblPrefolio.Visible = true;
lblPrefolioTitle.Visible = true;
}
else
{
CleanControlsExchange();
}
}
private void selectedExchange(int iIdExchange)
{
var ex = new ExchangeCompositeType();
var em = new ExchangeManager();
lblMessage.Text = string.Empty;
try
{
ex = em.getExchangeById(iIdExchange);
if (ex != null)
{
lblPrefolio.Text = ex.sFolioPre;
lblIdExchange.Text = ex.iIdExchange.ToString();
ddlExchange.SelectedValue = ex.iIdExchangeType.ToString();
ddlPlant.SelectedValue = ex.iIdPlant.ToString();
ddlPriority.SelectedValue = ex.iIdPriority.ToString();
ddlClient.SelectedValue = ex.iIdClient.ToString();
ddlSerie.SelectedValue = ex.iSerie.ToString();
ddlEngeenerProduct_Asignacion(iIdExchange, ex.iProductEngener);
txtAction.Text = ex.sMeasure;
txtContact.Text = ex.sContact;
txtDescription.Text = ex.sDescription;
txtIssue.Text = ex.sIssue;
if (ex.dLimitDate != null)
{
calLimite.SelectedDate = (DateTime)ex.dLimitDate;
}
txtLastFolio.Text = ex.sLastFolio;
txtProyectPlataformDescription.Text = ex.sProyect;
txtReason.Text = ex.sReason;
BlockControls();
CleanControls();
if (ex.sExchangeType.ToString() == "Cambio")
{
pnDocuments.Visible = true;
var adct = new affectationDocumentsCompositeType();
var adm = new AffectationDocumentsManager();
adct = adm.GetAffectationDocumentsByIdExchange(iIdExchange);
chkAMEF.Checked = adct.bAMEF;
chkCost.Checked = adct.bCost;
chkDevices.Checked = adct.bDevices;
chkDrawing.Checked = adct.bDrawing;
chkEspecification.Checked = adct.bEspecifications;
chkHOE.Checked = adct.bHOE;
chkMedia.Checked = adct.bMedia;
chkMold.Checked = adct.bMold;
chkOthers.Checked = adct.bOthers;
chkPlan.Checked = adct.bPlan;
chkSAP.Checked = adct.bSAP;
chkSing.Checked = adct.bSingOff;
}
else
{
pnDocuments.Visible = false;
}
lblPrefolio.Text = ex.sFolioPre;
txtSrchPreFol.Text = ex.sFolioPre;
lblPrefolio.Visible = true;
lblPrefolioTitle.Visible = true;
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
