public void r104Implementation(Contratado_Solicitud_PrestamoModel instance)
{
// This is the placeholder for method implementation.
int contratadoId = Convert.ToInt32(instance.Contratado_Id);
int tipoOperacionId = 8; //Solicitud
bool resultado;
int mensajeSistemaId;
string mensajeSistema;
string notasSolicitud = "";
string notasAutorizacionRechazo = "";
string solicitudPrestamoKey = "";
decimal montoSolicitado = 0;
int contratadoSolicitudPrestamoId = Convert.ToInt32(instance.Contratado_Solicitud_Prestamo_Id);
SharedBusinessRules sr = new SharedBusinessRules();
resultado = sr.AdministrarSolicitudPrestamo(tipoOperacionId, contratadoId, contratadoSolicitudPrestamoId, 0, notasSolicitud, notasAutorizacionRechazo, solicitudPrestamoKey, montoSolicitado, out mensajeSistema, out mensajeSistemaId);
if (resultado)
{
Result.ShowAlert("Solicitud Creada Exitosamente.");
}//if(resultado)
else
{
Result.ShowAlert(mensajeSistema);
}//else if(resultado)
}
public void r104Implementation(Contratado_Solicitud_DocumentoModel instance)
{
// This is the placeholder for method implementation.
int tipoDocumentoId = Convert.ToInt32(instance.Definicion_Solicitud_Documento_Id);
//string destinatario;
int contratadoId = Convert.ToInt32(instance.Contratado_Id);
int tipoOperacionId = 8; //Solicitud
bool resultado;
int mensajeSistemaId;
string mensajeSistema;
/*
* if(instance.Destinatario.ToString() != null)
* {
* destinatario = instance.Destinatario.ToString();
* }
*/
SharedBusinessRules sr = new SharedBusinessRules();
resultado = sr.AdministrarSolicitudDocumento(tipoOperacionId, tipoDocumentoId, contratadoId, out mensajeSistema, out mensajeSistemaId);
if (resultado)
{
Result.ShowAlert("Solicitud Creada Exitosamente.");
}//if(resultado)
else
{
Result.ShowAlert(mensajeSistema);
}//else if(resultado)
}
public void r115Implementation(AusentismoModel instance)
{
// This is the placeholder for method implementation.
int mensajeSistemaId = 0;
string mensajeSistema = "";
int contratadoParametro = (int)instance.Contratado_Id;
DateTime fechaSolicitudParametro = (DateTime)instance.Fecha_Solicitud_Ausentismo;
int diasSolicitadosParametro = (int)instance.Dias_Ausentismo_Solicitados;
DateTime fechaInicioVacaciones = (DateTime)instance.Fecha_Inicio_Ausentismo;
DateTime fechaFinVacaciones = (DateTime)instance.Fecha_Fin_Ausentismo;
int tipoOperacionId = 7;//Cancelación
int contratadoSolicitudVacacionesId = (int)instance.Contratado_Solicitud_Vacaciones_Id;
string solicitudVacacionesKey = instance.Solicitud_Vacaciones_Key.ToString();
int estatusSolicitudId = 5; //Cancelación
DateTime fechaAutorizacionRechazo = DateTime.Today; //Para insertar a la solicitud se pone el día de hoy ya que el sp no los tomara en cuenta
string autorizadoRechazadoPorId = UserId.ToString();
string notasAutorizacionRechazo = "";
int diasAutorizados = (int)instance.Dias_Autorizados; // (int)instance.Dias_Solicitados; ;
DateTime fechaInicioVacacionesAutorizado = DateTime.Today; //Para insertar a la solicitud se pone el día de hoy ya que el sp no los tomara en cuenta
DateTime fechaFinVacacionesAutorizado = DateTime.Today; //Para insertar a la solicitud se pone el día de hoy ya que el sp no los tomara en cuenta
string html = "";
SharedBusinessRules sb = new SharedBusinessRules();
bool resultadoGuardarSolicitudVacaciones = sb.AdministrarSolicitudVacaciones(
tipoOperacionId
, contratadoSolicitudVacacionesId
, solicitudVacacionesKey
, contratadoParametro
, fechaSolicitudParametro
, diasSolicitadosParametro
, fechaInicioVacaciones
, fechaFinVacaciones
, estatusSolicitudId
, fechaAutorizacionRechazo //fechaAutorizacionRechazo
, autorizadoRechazadoPorId
, notasAutorizacionRechazo
, diasAutorizados
, fechaInicioVacacionesAutorizado
, fechaFinVacacionesAutorizado
, out html
, out mensajeSistema
, out mensajeSistemaId
);
if (resultadoGuardarSolicitudVacaciones)
{
mensajeSistemaId = 677;
mensajeSistema = "Solicitud Cancelada exitosamente";
Result.ShowAlert(mensajeSistema);
}
else// if (!resultadoGuardarSolicitudVacaciones)
{
mensajeSistemaId = 678;
mensajeSistema = "Ha ocurrido un Errorl al Cancelar la Solicitud";
Result.ShowAlert(mensajeSistema);
} //else// if (!resultadoGuardarSolicitudVacaciones)
} //public void r115Implementation(AusentismoModel instance)
public void r100Implementation(Carga_SGMMSVModel instance)
{
// This is the placeholder for method implementation.
bool resultado;
string mensajeSistema;
int mensajeSistemaId;
SharedBusinessRules sr = new SharedBusinessRules();
resultado = sr.CargarSGMMYSV(out mensajeSistemaId, out mensajeSistema);
if (resultado)
{
Result.ShowAlert(mensajeSistema);
}//if(resultado)
else
{
Result.ShowAlert("Ocurrió un error al tratar de procesar los datos.");
}//else if(resultado)
}
public void r100Implementation(Temporal_Cargador_ContratadoModel instance)
{
// This is the placeholder for method implementation.
SharedBusinessRules sr = new SharedBusinessRules();
bool resultado = false;
int mensajeSistemaId = 0;
string mensajeSistema = "";
resultado = sr.ProcesarTemporalCargaContratado(out mensajeSistemaId, out mensajeSistema);
if (resultado)
{
Result.ShowAlert("Registros procesados con éxito");
}
else
{
Result.ShowAlert("Ocurrió un error; " + mensajeSistema);
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
filename = String.Format("AAT_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
// AAT
string CustCode = "40116011";
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
DataTable dt = new DataTable();
var connString = string.Format(@"Provider=Microsoft.Jet.OleDb.4.0; Data Source={0};Extended Properties=""Text;HDR=YES;FMT=Delimited""", Path.GetDirectoryName(filename));
using (OleDbConnection con = new OleDbConnection(connString))
{
try
{
using (SqlProcedure sp = new SqlProcedure("sp_AAT_Order_ClearData"))
{
sp.ExecuteNonQuery();
}
if (con.State != ConnectionState.Open)
{
con.Open();
}
var query = "SELECT * FROM [" + Path.GetFileName(filename) + "]";
using (var adapter = new OleDbDataAdapter(query, con))
{
adapter.Fill(dt);
if (dt.Columns.Count == 39)
{
bool boolStatusInsert = false;
foreach (DataRow _item in dt.Rows)
{
if (boolStatusInsert)
{
if (_item[38].ToString() == "W")
{
MyCompany.Data.Objects.AATOrderImport Order = new MyCompany.Data.Objects.AATOrderImport();
Order.OrderBy = CustCode;
Order.DeliveryDestination = _item[8].ToString();
Order.CustomerMatCode = _item[11].ToString();
string[] scpdTemp = SharedBusinessRules.getMaterial(_item[11].ToString(), CustCode, _item[8].ToString(), "AAT").Split(':');
Order.PartsDevision = scpdTemp[1];
Order.CustomerPO = _item[12].ToString();
Order.ReliabilityDevision = "F";
Order.DeliveryDate = Convert.ToDateTime(_item[35].ToString().Substring(0, 4).Trim() + "-" + _item[35].ToString().Substring(4, 2).Trim() + "-" + _item[35].ToString().Substring(6, 2).Trim());
Order.Quantity = _item[32].ToString();
Order.Unit = _item[33].ToString();
Order.PlngPeriod = "D";
Order.SAPCode = scpdTemp[0];
Order.Insert();
}
}
else
{
boolStatusInsert = true;
}
}
}
else if (dt.Columns.Count == 30)
{
bool boolStatusInsert = false;
foreach (DataRow _item in dt.Rows)
{
if (boolStatusInsert)
{
MyCompany.Data.Objects.AATOrderImport Order = new MyCompany.Data.Objects.AATOrderImport();
Order.OrderBy = CustCode;
Order.DeliveryDestination = _item[8].ToString();
Order.CustomerMatCode = _item[11].ToString();
string[] scpdTemp = SharedBusinessRules.getMaterial(_item[11].ToString(), CustCode, _item[8].ToString(), "AAT").Split(':');
Order.PartsDevision = scpdTemp[1];
Order.CustomerPO = _item[12].ToString();
Order.ReliabilityDevision = "F";
Order.DeliveryDate = Convert.ToDateTime(_item[28].ToString().Substring(0, 4).Trim() + "-" + _item[28].ToString().Substring(4, 2).Trim() + "-" + _item[28].ToString().Substring(6, 2).Trim());
Order.Quantity = _item[25].ToString();
Order.Unit = _item[26].ToString();
Order.PlngPeriod = "D";
Order.SAPCode = scpdTemp[0];
Order.Insert();
}
else
{
boolStatusInsert = true;
}
}
}
}
con.Close();
}
catch (Exception ex)
{
}
}
}
}
public void r105Implementation(Contratado_AdminModel instance)
{
// This is the placeholder for method implementation.
bool resultado;
int tipoMovimientoPersonalId = 0;
DateTime fechaMovimientoPersonal = Convert.ToDateTime("01/01/1900");
int motivoMovimientoPersonalId = 0;
int personaId = Convert.ToInt32(instance.Persona_Id);
int contratadoId = Convert.ToInt32(instance.Contratado_Id);
int contratanteEstructuraOrganizacionalId = Convert.ToInt32(instance.Contratante_Estructura_Organizacional_Id);
int pagadoraId = 0;
int contratantePuestoId = 0;
int contratanteId = 0;
int clienteId = 0;
int contratanteNuevaEstructuraOrganizacionalId = 0;
int pagadoraNuevaId = 0;
int contratantePuestoNuevoId = 0;
int contratanteNuevoId = 0;
int clienteNuevoId = 0;
DateTime fechaContratacion = Convert.ToDateTime("01/01/1900");
DateTime fechaAntiguedad = Convert.ToDateTime("01/01/1900");
int tipoEmpleadoId = 0;
int tipoContratadoId = 0;
int turnoLaboralId = 0;
int mensajeSistemaId;
string mensajeSistema;
if (instance.Tipo_Movimiento_Personal_Id != null)
{
tipoMovimientoPersonalId = Convert.ToInt32(instance.Tipo_Movimiento_Personal_Id);
if (instance.Fecha_Movimiento_Personal != null)
{
fechaMovimientoPersonal = Convert.ToDateTime(instance.Fecha_Movimiento_Personal);
}
if (instance.Motivo_Movimiento_Personal_Id != null)
{
motivoMovimientoPersonalId = Convert.ToInt32(instance.Motivo_Movimiento_Personal_Id);
if (instance.Pagadora_Id != null)
{
pagadoraId = Convert.ToInt32(instance.Pagadora_Id);
}
if (instance.Contratante_Puesto_Id != null)
{
contratantePuestoId = Convert.ToInt32(instance.Contratante_Puesto_Id);
}
if (instance.Contratante_Id != null)
{
contratanteId = Convert.ToInt32(instance.Contratante_Id);
}
if (instance.Cliente_Id != null)
{
clienteId = Convert.ToInt32(instance.Cliente_Id);
}
if (instance.Nueva_Estructura_Organizacional_Id != null)
{
contratanteNuevaEstructuraOrganizacionalId = Convert.ToInt32(instance.Nueva_Estructura_Organizacional_Id);
}
if (instance.Nueva_Pagadora_Id != null)
{
pagadoraNuevaId = Convert.ToInt32(instance.Nueva_Pagadora_Id);
}
if (instance.Nuevo_Contratante_Puesto_Id != null)
{
contratantePuestoNuevoId = Convert.ToInt32(instance.Nuevo_Contratante_Puesto_Id);
}
if (instance.Nuevo_Contratante_Id != null)
{
contratanteNuevoId = Convert.ToInt32(instance.Nuevo_Contratante_Id);
}
if (instance.Nuevo_Cliente_Id != null)
{
clienteNuevoId = Convert.ToInt32(instance.Nuevo_Cliente_Id);
}
SharedBusinessRules sr = new SharedBusinessRules();
resultado = sr.AdministrarMovimientoPersonal(tipoMovimientoPersonalId, personaId, contratadoId, fechaMovimientoPersonal, motivoMovimientoPersonalId, contratanteEstructuraOrganizacionalId, pagadoraId, contratantePuestoId, contratanteId, clienteId, contratanteNuevaEstructuraOrganizacionalId, pagadoraNuevaId, contratantePuestoNuevoId, contratanteNuevoId, clienteNuevoId, fechaContratacion, fechaAntiguedad, tipoContratadoId, tipoEmpleadoId, turnoLaboralId, out mensajeSistemaId, out mensajeSistema);
if (resultado)
{
Result.ShowAlert("Se ha actualizado con éxito al contratado.");
}
else
{
Result.ShowAlert(mensajeSistema);
}
}
else
{
Result.ShowAlert("Debe seleccionar un motivo de movimiento de personal.");
this.PreventDefault();
}
}
else
{
Result.ShowAlert("Debe seleccionar un tipo de movimiento de personal.");
this.PreventDefault();
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("THM_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
// HATC Order
string CustCode = string.Empty; // "40108011";
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
int totalLine = 0, totalOrder = 1;
using (SqlProcedure sp = new SqlProcedure("sp_THM_Order_ClearData"))
{
sp.ExecuteNonQuery();
}
while ((line = sr.ReadLine()) != null)
{
totalLine++;
if (line.Length > 0)
{
#region Format
// "000000000000" is Supply Part
string shipto = line.Substring(145, 5) + "-" + line.Substring(22, 6);
if ((line.Substring(140, 5) == "45320" || line.Substring(140, 5) == "05386") && line.Substring(10, 12) != "000000000000")
{
MyCompany.Models.THMOrderImport Order = new MyCompany.Models.THMOrderImport();
Order.DeliveryDestination = line.Substring(145, 5) + "-" + line.Substring(22, 6);
Order.OrderBy = "40101011";
Order.CustomerMatCode = line.Substring(28, 18).Trim().Replace(" ", "");
string[] materialTemp = SharedBusinessRules.getMaterial(line.Substring(28, 18).Trim().Replace(" ", ""), Order.OrderBy, line.Substring(22, 6), line.Substring(145, 5)).Split(':');
if (materialTemp.Length > 1)
{
Order.SAPCode = materialTemp[0];
Order.PartsDevision = materialTemp[1];
Order.DeliveryDestinationCode = materialTemp[2];
Order.Key1 = materialTemp[3];
Order.Key2 = materialTemp[4];
Order.Key3 = materialTemp[5];
}
Order.CustomerPO = line.Substring(10, 12).Trim();
Order.ReliabilityDevision = "P"; //Realiability = [Forcast=F,Order=P]
Order.DeliveryDate = Convert.ToDateTime(line.Substring(118, 4).Trim() + "-" + line.Substring(122, 2).Trim() + "-" + line.Substring(124, 2).Trim());
Order.Quantity = line.Substring(126, 7).Trim();
Order.Unit = "ST"; // SD Fixd Data Unit = ST
//SD Fixd Data Unit = ST, Periad = D, Realiability = [Forcast=F,Order=P]
Order.PlngPeriod = "D"; // Periad = D
Order.PlantCode = line.Substring(22, 6) + " Add. " + line.Substring(94, 4).Trim();
Order.AddCode = totalOrder.ToString();
Order.Arrivaltime = line.Substring(116, 2) + ":00:00";
Order.FromTo = line.Substring(88, 5).Trim() + ":" + line.Substring(145, 5);
Order.Filename = fn;
Order.Insert();
totalOrder++;
}
#endregion
}
}
sr.Close();
}
}
//// Save file
//string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
//filename = String.Format("THM_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
//AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
//string CustCode = "40101010";
//filename = Server.MapPath("~/Files/") + filename;
//if (File.Exists(filename))
//{
// string line = string.Empty;
// using (StreamReader sr = new StreamReader(filename))
// {
// using (SqlProcedure sp = new SqlProcedure("sp_THM_Order_ClearData"))
// {
// sp.ExecuteNonQuery();
// }
// while ((line = sr.ReadLine()) != null)
// {
// if (line.Length > 0)
// {
// //string shipto = line.Substring(145, 5) + "-" + line.Substring(22, 6);
// if ((line.Substring(140, 5) == "45320" || line.Substring(140, 5) == "05386") && line.Substring(10, 12) != "000000000000")
// //if ((line.Substring(140, 5).Trim() == "CRS1" || line.Substring(140, 5) == "45320") && line.Substring(10, 12) != "000000000000")
// {
// //string[] item = line.Split(Convert.ToChar("|"));
// MyCompany.Models.THMOrderImport Order = new MyCompany.Models.THMOrderImport();
// Order.OrderBy = CustCode;
// Order.DeliveryDestination = ""; //Not sure
// Order.CustomerMatCode = line.Substring(28, 18).Replace(" ","");
// Order.PartsDevision = "1";
// Order.CustomerPO = line.Substring(10, 12);
// Order.ReliabilityDevision = "P";
// Order.DeliveryDate =Convert.ToDateTime( line.Substring(118, 4) + "-" + line.Substring(122, 2) + "-" + line.Substring(124, 2));
// Order.Quantity = float.Parse(line.Substring(126, 7)).ToString().Trim();
// Order.Unit = "ST";
// Order.PlngPeriod = "D";
// string[] materialTemp = SharedBusinessRules.getMaterial(Order.CustomerMatCode, Order.OrderBy, PlantCode, LocationCode).Split(':');
// if (materialTemp.Length > 1)
// {
// Order.SAPCode = materialTemp[0];
// Order.PartsDevision = materialTemp[1];
// Order.DeliveryDestinationCode = materialTemp[2];
// }
// Order.Insert();
// }
// }
// }
// sr.Close();
// }
//}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("IMCT_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
// HATC Order
string CustCode = "40111011";
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
//using (SqlProcedure sp = new SqlProcedure("sp_IMCT_Order_ClearData"))
//{
// sp.ExecuteNonQuery();
//}
int i = 1;
while ((line = sr.ReadLine()) != null)
{
if (line.Length > 0)
{
if (!line.Contains("ISUZU"))
{
MyCompany.Models.IMCTOrderImport Order = new MyCompany.Models.IMCTOrderImport();
Order.OrderBy = CustCode;
Order.DeliveryDestination = line.Substring(120, 5).Trim();
Order.CustomerMatCode = line.Substring(35, 10).Trim();
Order.CustomerPO = line.Substring(2, 10).Trim();
Order.ReliabilityDevision = "P";
Order.DeliveryDate = Convert.ToDateTime(line.Substring(50, 4).Trim() + "-" + line.Substring(54, 2).Trim() + "-" + line.Substring(56, 2).Trim());
Order.Quantity = float.Parse(line.Substring(58, 6)).ToString().Trim();
Order.Unit = "ST";
Order.PlngPeriod = "D";
string[] materialTemp = SharedBusinessRules.getMaterial(line.Substring(35, 10).Trim().Replace(" ", ""), CustCode, line.Substring(120, 5).Trim(), "IMCT").Split(':');
if (materialTemp.Length > 1)
{
Order.SAPCode = materialTemp[0];
Order.PartsDevision = materialTemp[1];
Order.DeliveryDestinationCode = materialTemp[2];
Order.Key1 = materialTemp[3];
Order.Key2 = materialTemp[4];
Order.Key3 = materialTemp[5];
}
Order.AddCode = i.ToString();
Order.PlantCode = "";
Order.Arrivaltime = line.Substring(159, 2).Trim() + ":" + line.Substring(161, 2).Trim();
Order.FromTo = "RTP:" + line.Substring(120, 5).Trim();
Order.Filename = fn;
Order.Insert();
i++;
}
}
}
sr.Close();
}
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("TSM_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
using (SqlProcedure sp = new SqlProcedure("sp_TSM_Forcast_ClearData"))
{
sp.ExecuteNonQuery();
}
string[] strCol = { "DeliveryDestination", "CustomerMatCode", "CustomerPO", "Quantity", "DeliveryDate", "FromTo", "StatusCode", "DeliveryDateOld" };
DataTable dt = new DataTable();
foreach (string strItem in strCol)
{
if (strItem == "Quantity")
{
dt.Columns.Add(strItem, typeof(int));
}
else
{
dt.Columns.Add(strItem);
}
}
while ((line = sr.ReadLine()) != null)
{
string[] item = ParseCsvRow(line);
if (item.Length > 1 && (item[1].Trim() == "NEW" || item[1].Trim() == "RES"))
{
dt.Rows.Add(item[2].Trim(), item[3].Trim(), item[7].Trim(), Convert.ToInt32(item[9].Trim()), item[10].Trim(), "RTP:" + item[2].Trim(), item[1].Trim(), item[11].Trim());
}
}
DataTable dtTemp = dt.AsEnumerable()
.GroupBy(r => new { Col1 = r["DeliveryDestination"], Col2 = r["CustomerMatCode"], Col3 = r["CustomerPO"], Col4 = r["DeliveryDate"], Col5 = r["FromTo"], Col6 = r["StatusCode"], Col7 = r["DeliveryDateOld"] })
.Select(g =>
{
var row = dt.NewRow();
row["DeliveryDestination"] = g.Key.Col1;
row["CustomerMatCode"] = g.Key.Col2;
row["CustomerPO"] = g.Key.Col3;
row["Quantity"] = g.Sum(r => r.Field <int>("Quantity"));
row["DeliveryDate"] = g.Key.Col4;
row["FromTo"] = g.Key.Col5;
row["StatusCode"] = g.Key.Col6;
row["DeliveryDateOld"] = g.Key.Col7;
return(row);
}).CopyToDataTable();
string CustCode = "40102011";
foreach (DataRow item in dtTemp.Rows)
{
string[] dmy = Convert.ToString(item[4]).Split('/');
MyCompany.Models.TSMForcastImport Forcast = new MyCompany.Models.TSMForcastImport();
Forcast.OrderBy = CustCode;
Forcast.DeliveryDestination = Convert.ToString(item[0]);
Forcast.CustomerMatCode = Convert.ToString(item[1]);
Forcast.CustomerPO = Convert.ToString(item[2]);
Forcast.ReliabilityDevision = "P";
Forcast.Quantity = Convert.ToInt32(Convert.ToString(item[3]));
Forcast.Unit = "ST";
Forcast.PlngPeriod = "D";
Forcast.DeliveryDate = Convert.ToDateTime(dmy[0] + "-" + dmy[1] + "-20" + dmy[2]);
string[] materialTemp = SharedBusinessRules.getMaterial(Forcast.CustomerMatCode, CustCode, Forcast.DeliveryDestination, "TSM").Split(':');
if (materialTemp.Length > 1)
{
Forcast.SAPCode = materialTemp[0];
Forcast.PartsDevision = materialTemp[1];
Forcast.DeliveryDestinationCode = materialTemp[2];
Forcast.Key1 = materialTemp[3];
Forcast.Key2 = materialTemp[4];
Forcast.Key3 = materialTemp[5];
}
Forcast.FileName = fn;
if (Convert.ToString(item[6]) == "RES")
{
string[] dmyOld = Convert.ToString(item[7]).Split('/');
Forcast.DeliveryDateOld = Convert.ToDateTime(dmyOld[0] + "-" + dmyOld[1] + "-20" + dmyOld[2]);
}
Forcast.Condition = Convert.ToString(item[6]);
Forcast.Insert();
}
}
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("HATC_{0}_FORCAST_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
using (SqlProcedure sp = new SqlProcedure("sp_IMCT_Forcast_ClearData"))
{
sp.ExecuteNonQuery();
}
sr.ReadLine();
while ((line = sr.ReadLine()) != null)
{
string DeliveryDestination = line.Substring(33, 6).Trim();
string OrderBy = "40111011";
string CusMatCode = line.Substring(41, 10);
string locCode = line.Substring(39, 2).Trim();
string[] materialTemp = SharedBusinessRules.getMaterial(CusMatCode, OrderBy, DeliveryDestination, "IMCT").Split(':');
int startPointDate = 92;
int startPointQty = 148;
for (int w = 1; w <= 6; w++)
{
DateTime dateOld = Convert.ToDateTime(line.Substring(startPointDate, 4).ToString() + "-" + line.Substring(startPointDate + 4, 2).ToString() + "-" + line.Substring(startPointDate + 6, 2).ToString());
int subPointDate = 8;
int subPointQty = 0;
for (int d = 1; d <= 6; d++)
{
DateTime dateDrliveryDate;
if (line.Substring(startPointDate + subPointDate, 4).ToString().Trim() != string.Empty)
{
dateDrliveryDate = Convert.ToDateTime(line.Substring(startPointDate + subPointDate, 4).ToString() + "-" + line.Substring(startPointDate + subPointDate + 4, 2).ToString() + "-" + line.Substring(startPointDate + subPointDate + 6, 2).ToString());
}
else
{
dateDrliveryDate = dateOld.AddDays(d - 1);
}
int numQty = Convert.ToInt32(line.Substring(startPointQty + subPointQty, 6).ToString());
MyCompany.Models.IMCTForcastImport forcast = new MyCompany.Models.IMCTForcastImport();
forcast.OrderBy = OrderBy;
forcast.DeliveryDestination = DeliveryDestination + "-" + locCode;
forcast.CustomerMatCode = CusMatCode;
if (materialTemp.Length > 1)
{
forcast.SAPCode = materialTemp[0];
forcast.PartsDevision = materialTemp[1];
forcast.DeliveryDestinationCode = materialTemp[2];
forcast.Key1 = materialTemp[3];
forcast.Key2 = materialTemp[4];
forcast.Key3 = materialTemp[5];
}
forcast.CustomerPO = "";
forcast.ReliabilityDevision = "F";
forcast.Unit = "ST";
forcast.PlngPeriod = "D";
forcast.DeliveryDate = dateDrliveryDate;
forcast.Quantity = numQty;
forcast.FileName = fn;
forcast.Insert();
subPointDate += 8;
subPointQty += 6;
}
startPointDate += 100;
startPointQty += 100;
}
}
}
}
}
public void r109Implementation(Contratado_Solicitud_VacacionesModel instance)
{
// This is the placeholder for method implementation.
bool resultadoValidarVacaciones = false;
int mensajeSistemaId = 0;
string mensajeSistema = "";
int contratadoParametro = (int)instance.Contratado_Id;
DateTime fechaSolicitudParametro = (DateTime)instance.Fecha_Solicitud;
int diasSolicitadosParametro = (int)instance.Dias_Solicitados;
DateTime fechaInicioVacaciones = (DateTime)instance.Fecha_Inicio_Vacaciones;
DateTime fechaFinVacaciones = (DateTime)instance.Fecha_Fin_Vacaciones;
SharedBusinessRules sb = new SharedBusinessRules();
int tipoOperacionId = 7; //Cancelación
int contratadoSolicitudVacacionesId = (int)instance.Contratado_Solicitud_Vacaciones_Id; //(int)instance.Contratado_Solicitud_Vacaciones_Id;
string solicitudVacacionesKey = instance.Solicitud_Vacaciones_Key.ToString();
int estatusSolicitudId = (int)instance.Estatus_Solicitud_Id; //Creación
DateTime fechaAutorizacionRechazo = DateTime.Today; //Para insertar a la solicitud se pone el día de hoy ya que el sp no los tomara en cuenta
string autorizadoRechazadoPorId = UserId.ToString();
string notasAutorizacionRechazo = "";
int diasAutorizados = (int)instance.Dias_Solicitados;;
DateTime fechaInicioVacacionesAutorizado = DateTime.Today; //Para insertar a la solicitud se pone el día de hoy ya que el sp no los tomara en cuenta
DateTime fechaFinVacacionesAutorizado = DateTime.Today; //Para insertar a la solicitud se pone el día de hoy ya que el sp no los tomara en cuenta
string html = "";
bool resultadoGuardarSolicitudVacaciones = sb.AdministrarSolicitudVacaciones(
tipoOperacionId
, contratadoSolicitudVacacionesId
, solicitudVacacionesKey
, contratadoParametro
, fechaSolicitudParametro
, diasSolicitadosParametro
, fechaInicioVacaciones
, fechaFinVacaciones
, estatusSolicitudId
, fechaAutorizacionRechazo //fechaAutorizacionRechazo
, autorizadoRechazadoPorId
, notasAutorizacionRechazo
, diasAutorizados
, fechaInicioVacacionesAutorizado
, fechaFinVacacionesAutorizado
, out html
, out mensajeSistema
, out mensajeSistemaId
);
if (resultadoGuardarSolicitudVacaciones)
{
//mensajeSistemaId = 87;
//mensajeSistema = "Solicitud se ha creado exitosamente";
//Result.ShowAlert(mensajeSistema);
Result.Continue();
}
else // if (!resultadoGuardarSolicitudVacaciones)
{
mensajeSistemaId = 86;
//mensajeSistema = mensajeSistema;
Result.ShowAlert(mensajeSistema);
} //else// if (!resultadoGuardarSolicitudVacaciones)
}//public void r109Implementation(Contratado_Solicitud_VacacionesModel instance)
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("THM_{0}_FORCAST_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
string LocationCode = string.Empty;
// HATC Order
string CustCode = string.Empty;
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
//List<MyCompany.Models.HATCForcastImport> HATCList = new List<MyCompany.Models.HATCForcastImport>();
string CustMatNo = string.Empty, year = string.Empty, PlantCode = string.Empty;
Dictionary <int, string> dueDate = new Dictionary <int, string>();
Dictionary <int, double> orderQty = new Dictionary <int, double>();
int lineIndex = -1;
using (SqlProcedure sp = new SqlProcedure("sp_THM_Forcast_ClearData"))
{
sp.ExecuteNonQuery();
}
string ReliabilityDevision = string.Empty;
while ((line = sr.ReadLine()) != null)
{
if (lineIndex >= 0)
{
lineIndex++;
}
switch (lineIndex)
{
case 3:
year = line.Substring(40, 4);
string[] ln = line.Split(' ');
LocationCode = ln[3];
break;
case 5:
try
{
dueDate.Clear();
orderQty.Clear();
// get Part and Delivery Date
CustMatNo = line.Substring(0, line.IndexOf("DATE")).Trim();
string[] data = line.Substring(line.IndexOf("DATE") + 4, (line.IndexOf("TOTAL") - line.IndexOf("DATE") - 4)).Trim().Split(' ');
int colIndex = 0;
for (int i = 0; i < data.Length; i++)
{
if (!string.IsNullOrEmpty(data[i].Trim()))
{
string[] _dueDate = data[i].Split('/');
if (_dueDate.Length > 0)
{
dueDate.Add(colIndex, String.Format("{0}-{1}-{2}", year, _dueDate[1], _dueDate[0]));
colIndex++;
}
}
}
}
catch (Exception ex)
{
}
break;
case 6: try
{
line = line.Substring(line.IndexOf("QTY.") + 4, line.Length - line.IndexOf("QTY.") - 10);
int colIndex = 0;
while (line.Length >= 7)
{
string qty = line.Substring(0, 7).Trim();
qty = String.IsNullOrEmpty(qty) ? "0" : qty;
orderQty.Add(colIndex, Convert.ToDouble(qty));
line = line.Substring(7, line.Length - 7);
colIndex++;
}
}
catch (Exception ex)
{
}
break;
case 11:
PlantCode = line.Substring(16, 17).Trim();
for (int i = 0; i < dueDate.Count; i++)
{
//[XXXX]03 => 40138011 => HATC-P
//[XXXX]xx => 40108011 => HATC
MyCompany.Models.THMForcastImport forcast = new MyCompany.Models.THMForcastImport();
forcast.OrderBy = "40101011";
forcast.DeliveryDestination = PlantCode + "-" + LocationCode;
forcast.CustomerMatCode = CustMatNo;
string[] materialTemp = SharedBusinessRules.getMaterial(forcast.CustomerMatCode, forcast.OrderBy, PlantCode, LocationCode).Split(':');
if (materialTemp.Length > 1)
{
forcast.SAPCode = materialTemp[0];
forcast.PartsDevision = materialTemp[1];
forcast.DeliveryDestinationCode = materialTemp[2];
}
forcast.CustomerPO = "";
forcast.ReliabilityDevision = ReliabilityDevision;
forcast.Unit = "ST";
forcast.PlngPeriod = "D";
forcast.DeliveryDate = Convert.ToDateTime(dueDate[i]);
forcast.Quantity = orderQty[i].ToString();
forcast.FileName = fn;
forcast.Insert();
}
break;
default:
break;
}
if (line.Trim().StartsWith("PART ORDER SCHEDULE (MAIL)") || line.Trim().StartsWith("PURCHASE SHEET (MAIL)"))
{
if (line.Trim().StartsWith("PART ORDER SCHEDULE (MAIL)"))
{
ReliabilityDevision = "F";
}
else if (line.Trim().StartsWith("PURCHASE SHEET (MAIL)"))
{
ReliabilityDevision = "P";
}
lineIndex = 0;
}
}
sr.Close();
}
}
//// Save file
//string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
//filename = String.Format("THM_{0}_FORCAST_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
//AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
//// HATC Order
//string CustCode = "40101010";
//filename = Server.MapPath("~/Files/") + filename;
//if (File.Exists(filename))
//{
// string line = string.Empty;
// using (StreamReader sr = new StreamReader(filename))
// {
// int rowsCount = 0;
// int i = 0;
// List<string> str = new List<string>();
// string CustPartNo = string.Empty, CustomerCode = string.Empty, Desination = string.Empty;
// using (SqlProcedure sp = new SqlProcedure("sp_THM_Forcast_ClearData"))
// {
// sp.ExecuteNonQuery();
// }
// while ((line = sr.ReadLine()) != null)
// {
// rowsCount++;
// if (rowsCount % 16 == 0)
// {
// //Get Customer code
// CustomerCode = str[2].Substring(5, 10).Trim();
// Desination = str[9].Substring(8, 10).Trim();
// //Get Customer Part No && Array Date
// //string[] arrStrLine6;
// //arrStrLine6 = str[5].Split(Convert.ToChar(" "));
// //int getRow5 = 0;
// List<MQtyOrder> QtyOfDate = new List<MQtyOrder>();
// //CustPartNo = str[5].Split(Convert.ToChar(" "));
// CustPartNo = str[5].Substring(0, 31);
// #region DateOfOrder
// if (str[5].Substring(33, 4) == "DATE")
// {
// //MessageBox.Show("Line OK");
// string Month = "";
// int startPostition = 0;
// int endPostition = 0;
// string flagPosition = "End";
// //string flagSavePosition = "No";
// //Merge stirng Date
// for (int iRow5 = 37; iRow5 < str[5].Length; iRow5++)
// {
// if (str[5].Substring(iRow5, 1) != " ")
// {
// if (flagPosition == "End")
// {
// startPostition = iRow5;
// flagPosition = "Start";
// }
// if (str[5].Substring(iRow5, 5) == "TOTAL")
// {
// //MessageBox.Show("End Line !!!");
// //return;
// break;
// }
// else
// {
// Month = Month + str[5].Substring(iRow5, 1);
// }
// }
// else
// {
// if (flagPosition == "Start")
// {
// //flagPosition = "End";
// //}
// flagPosition = "End";
// endPostition = iRow5;
// //flagSavePosition = "NO";
// }
// if (Month != "")
// {
// //Save Date
// MQtyOrder Qty = new MQtyOrder();
// Qty.OrderDate = Month;
// Qty.startPosition = startPostition;
// Qty.endPosition = endPostition;
// QtyOfDate.Add(Qty);
// //MessageBox.Show(Month + " : " + startPostition + "," + endPostition);
// Month = "";
// }
// }
// }
// #endregion
// #region QtyOfOrder
// if (str[6].Substring(33, 4) == "QTY.")
// {
// //for (int iRow6 = 37; iRow6 < str[6].Length; iRow6++)
// //{
// //}
// for (int iQty = 0; iQty < QtyOfDate.Count; iQty++)
// {
// //MQtyOrder Qty = new MQtyOrder();
// //Qty = QtyOfDate[iQty];
// //Qty.OrderQty =
// string Qty = str[6].Substring(QtyOfDate[iQty].startPosition, QtyOfDate[iQty].endPosition - QtyOfDate[iQty].startPosition).ToString().Trim();
// if (Qty == "")
// {
// QtyOfDate[iQty].OrderQty = 0;
// }
// else
// {
// QtyOfDate[iQty].OrderQty = Convert.ToInt32(Qty);
// }
// //QtyOfDate[iQty].OrderQty = str[6].Substring(QtyOfDate[iQty].startPosition, QtyOfDate[iQty].endPosition - QtyOfDate[iQty].startPosition);
// }
// }
// #endregion
// #region ShowData
// //List<MT05> Data = new List<MT05>();
// for (int iShow = 0; iShow < QtyOfDate.Count; iShow++)
// {
// MyCompany.Data.Objects.THMForcastImport Order = new MyCompany.Data.Objects.THMForcastImport();
// Order.OrderBy = CustomerCode;
// Order.DeliveryDestination = Desination;
// Order.CustomerMatCode = CustPartNo;
// Order.PartsDevision = "1";
// Order.CustomerPO = "Not sure";
// Order.ReliabilityDevision = "P";
// //Order.DeliveryDate = QtyOfDate[iShow].OrderDate;
// //Order.Quantity = Convert.ToDecimal( QtyOfDate[iShow].OrderQty);
// Order.Unit = "ST";
// Order.PlngPeriod = "D";
// Order.SAPCode = "";//SharedBusinessRules.getSAPCode(Order.CustomerMatCode);
// Order.Insert();
// }
// #endregion
// str.Clear();
// //rowsCount = 1;
// }
// }
// else
// {
// str.Add(line);
// }
// }
// sr.Close();
// }
//}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("TSM_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
filename = Server.MapPath("~/Files/") + filename;
string extfile = Path.GetExtension(filename);
string fileCsv = filename.Replace(extfile, ".csv");
ExcelToCSVCoversion(filename, fileCsv);
if (File.Exists(fileCsv))
{
DataTable dt = new DataTable();
var connString = string.Format(@"Provider=Microsoft.Jet.OleDb.4.0; Data Source={0};Extended Properties=""Text;HDR=YES;FMT=Delimited""", Path.GetDirectoryName(filename));
using (OleDbConnection con = new OleDbConnection(connString))
{
var query = "SELECT * FROM [" + Path.GetFileName(fileCsv) + "]";
using (var adapter = new OleDbDataAdapter(query, con))
{
adapter.Fill(dt);
if (dt.Columns.Count == 18)
{
DataTable dtTemp = dt.AsEnumerable()
.GroupBy(r => new { Col1 = r["PLACE"], Col2 = r["P-NO"], Col3 = r["DUE"] })
.Select(g =>
{
var row = dt.NewRow();
row["PLACE"] = g.Key.Col1;
row["P-NO"] = g.Key.Col2;
row["QTY"] = g.Sum(r => r.Field <int>("QTY"));
row["DUE"] = g.Key.Col3;
return(row);
}).CopyToDataTable();
string CustCode = "40104011";
foreach (DataRow item in dtTemp.Rows)
{
MyCompany.Models.KMTForcastImport Forcast = new MyCompany.Models.KMTForcastImport();
Forcast.OrderBy = CustCode;
Forcast.DeliveryDestination = item[5].ToString();
string[] arrCus = item[1].ToString().Split('-');
Forcast.CustomerMatCode = arrCus[0].ToString().Substring(arrCus[0].Length - 5) + "-" + arrCus[1].Substring(0, 4);
string[] materialTemp = SharedBusinessRules.getMaterial(Forcast.CustomerMatCode, Forcast.OrderBy, item[5].ToString(), "KMT").Split(':');
if (materialTemp.Length > 1)
{
Forcast.SAPCode = materialTemp[0];
if (materialTemp[1] == "1A")
{
Forcast.PartsDevision = "1";
}
else if (materialTemp[1] == "1B")
{
Forcast.PartsDevision = "2";
}
else
{
Forcast.PartsDevision = materialTemp[1];
}
Forcast.DeliveryDestinationCode = materialTemp[2];
Forcast.Key1 = materialTemp[3];
Forcast.Key2 = materialTemp[4];
Forcast.Key3 = materialTemp[5];
}
Forcast.CustomerPO = "";
Forcast.ReliabilityDevision = "P";
Forcast.Unit = "ST";
Forcast.PlngPeriod = "D";
Forcast.DeliveryDate = Convert.ToDateTime(item[4]);
Forcast.Quantity = Convert.ToInt32(item[7].ToString());
Forcast.FileName = fn;
Forcast.Insert();
}
}
else if (dt.Columns.Count == 16)
{
DataTable dtTemp = dt.AsEnumerable()
.GroupBy(r => new { Col1 = r["RCV PLACE"], Col2 = r["ITEMNO"], Col3 = r["DUE"] })
.Select(g =>
{
var row = dt.NewRow();
row["RCV PLACE"] = g.Key.Col1;
row["ITEMNO"] = g.Key.Col2;
row["QTY"] = g.Sum(r => r.Field <int>("QTY"));
row["DUE"] = g.Key.Col3;
return(row);
}).CopyToDataTable();
string CustCode = "40104011";
foreach (DataRow item in dtTemp.Rows)
{
MyCompany.Models.KMTForcastImport Forcast = new MyCompany.Models.KMTForcastImport();
Forcast.OrderBy = CustCode;
Forcast.DeliveryDestination = item[7].ToString();
string[] arrCus = item[1].ToString().Split('-');
Forcast.CustomerMatCode = arrCus[0].ToString().Substring(arrCus[0].Length - 5) + "-" + arrCus[1].Substring(0, 4);
string[] materialTemp = SharedBusinessRules.getMaterial(Forcast.CustomerMatCode, Forcast.OrderBy, item[7].ToString(), "KMT").Split(':');
if (materialTemp.Length > 1)
{
Forcast.SAPCode = materialTemp[0];
if (materialTemp[1] == "1A")
{
Forcast.PartsDevision = "1";
}
else if (materialTemp[1] == "1B")
{
Forcast.PartsDevision = "2";
}
else
{
Forcast.PartsDevision = materialTemp[1];
}
Forcast.DeliveryDestinationCode = materialTemp[2];
Forcast.Key1 = materialTemp[3];
Forcast.Key2 = materialTemp[4];
Forcast.Key3 = materialTemp[5];
}
Forcast.CustomerPO = "";
Forcast.ReliabilityDevision = "F";
Forcast.Unit = "ST";
Forcast.PlngPeriod = "D";
Forcast.DeliveryDate = Convert.ToDateTime(item[5]);
Forcast.Quantity = Convert.ToInt32(item[6].ToString());
Forcast.FileName = fn;
Forcast.Insert();
}
}
}
}
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
filename = String.Format("MMTH_{0}_FORVAST_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
using (SqlProcedure sp = new SqlProcedure("sp_MMTH_Order_ClearData"))
{
sp.ExecuteNonQuery();
}
while ((line = sr.ReadLine()) != null)
{
string[] arr = line.Split('|');
if (!arr[4].Contains("9999999999999999"))
{
string plantCode = arr[2];
string yyyy = arr[3].Substring(0, 4);
string MM = arr[3].Substring(4, 2);
string partNo = arr[4];
string dayOld = arr[11];
for (int d = 12; d <= arr.Length - 1; d += 2)
{
if (arr[d - 1] == "00")
{
break;
}
if (Convert.ToInt32(dayOld) > Convert.ToInt32(arr[d - 1]))
{
DateTime dtTemp = Convert.ToDateTime(yyyy + "-" + MM + "-01");
dtTemp = dtTemp.AddMonths(1);
MM = dtTemp.Month.ToString();
yyyy = dtTemp.Year.ToString();
}
MyCompany.Models.MMTHForcastImport forcast = new MyCompany.Models.MMTHForcastImport();
forcast.OrderBy = "40113011";
forcast.DeliveryDestination = plantCode;
forcast.CustomerMatCode = partNo.Trim();
string[] materialTemp = SharedBusinessRules.getMaterial(forcast.CustomerMatCode, "40113011", plantCode, "MMTh").Split(':');
if (materialTemp.Length > 1)
{
forcast.SAPCode = materialTemp[0];
forcast.PartsDevision = materialTemp[1];
forcast.DeliveryDestinationCode = materialTemp[2];
}
forcast.CustomerPO = "";
forcast.ReliabilityDevision = "F";
forcast.Unit = "ST";
forcast.PlngPeriod = "D";
forcast.DeliveryDate = Convert.ToDateTime(yyyy + "-" + MM + "-" + arr[d - 1]);
forcast.Quantity = Convert.ToInt32(arr[d]);
forcast.Insert();
dayOld = arr[d - 1];
}
}
}
}
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("HATC_{0}_FORCAST_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
string LocationCode = string.Empty;
// HATC Order
string CustCode = string.Empty;
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
//List<MyCompany.Models.HATCForcastImport> HATCList = new List<MyCompany.Models.HATCForcastImport>();
string CustMatNo = string.Empty, year = string.Empty, PlantCode = string.Empty;
Dictionary <int, string> dueDate = new Dictionary <int, string>();
Dictionary <int, double> orderQty = new Dictionary <int, double>();
int lineIndex = -1;
using (SqlProcedure sp = new SqlProcedure("sp_HATC_Forcast_ClearData"))
{
sp.ExecuteNonQuery();
}
string ReliabilityDevision = string.Empty;
while ((line = sr.ReadLine()) != null)
{
if (lineIndex >= 0)
{
lineIndex++;
}
switch (lineIndex)
{
case 3:
year = line.Substring(40, 4);
string[] ln = line.Split(' ');
LocationCode = ln[3];
break;
case 5:
try
{
dueDate.Clear();
orderQty.Clear();
// get Part and Delivery Date
CustMatNo = line.Substring(0, line.IndexOf("DATE")).Trim();
string[] data = line.Substring(line.IndexOf("DATE") + 4, (line.IndexOf("TOTAL") - line.IndexOf("DATE") - 4)).Trim().Split(' ');
int colIndex = 0;
for (int i = 0; i < data.Length; i++)
{
if (!string.IsNullOrEmpty(data[i].Trim()))
{
string[] _dueDate = data[i].Split('/');
if (_dueDate.Length > 0)
{
dueDate.Add(colIndex, String.Format("{0}-{1}-{2}", year, _dueDate[1], _dueDate[0]));
colIndex++;
}
}
}
}
catch (Exception ex)
{
}
break;
case 6: try
{
line = line.Substring(line.IndexOf("QTY.") + 4, line.Length - line.IndexOf("QTY.") - 10);
int colIndex = 0;
while (line.Length >= 7)
{
string qty = line.Substring(0, 7).Trim();
qty = String.IsNullOrEmpty(qty) ? "0" : qty;
orderQty.Add(colIndex, Convert.ToDouble(qty));
line = line.Substring(7, line.Length - 7);
colIndex++;
}
}
catch (Exception ex)
{
}
break;
case 11:
PlantCode = line.Substring(16, 17).Trim();
for (int i = 0; i < dueDate.Count; i++)
{
//[XXXX]03 => 40138011 => HATC-P
//[XXXX]xx => 40108011 => HATC
MyCompany.Models.HATCForcastImport forcast = new MyCompany.Models.HATCForcastImport();
forcast.OrderBy = PlantCode.EndsWith("03") ? "40138011" : "40108011";
forcast.DeliveryDestination = PlantCode + "-" + LocationCode;
forcast.CustomerMatCode = CustMatNo;
string[] materialTemp = SharedBusinessRules.getMaterial(forcast.CustomerMatCode, PlantCode.EndsWith("03") ? "40138011" : "40108011", PlantCode, LocationCode).Split(':');
if (materialTemp.Length > 1)
{
forcast.SAPCode = materialTemp[0];
if (materialTemp[1] == "1A")
{
forcast.PartsDevision = "1";
}
else if (materialTemp[1] == "1B")
{
forcast.PartsDevision = "2";
}
else
{
forcast.PartsDevision = materialTemp[1];
}
forcast.DeliveryDestinationCode = materialTemp[2];
forcast.Key1 = materialTemp[3];
forcast.Key2 = materialTemp[4];
forcast.Key3 = materialTemp[5];
}
forcast.CustomerPO = "";
forcast.ReliabilityDevision = ReliabilityDevision;
forcast.Unit = "ST";
forcast.PlngPeriod = "D";
forcast.DeliveryDate = Convert.ToDateTime(dueDate[i]);
forcast.Quantity = Convert.ToInt32(orderQty[i].ToString());
forcast.FileName = fn;
forcast.Insert();
}
break;
default:
break;
}
if (line.Trim().StartsWith("PART ORDER SCHEDULE (MAIL)") || line.Trim().StartsWith("PURCHASE SHEET (MAIL)"))
{
if (line.Trim().StartsWith("PART ORDER SCHEDULE (MAIL)"))
{
ReliabilityDevision = "F";
}
else if (line.Trim().StartsWith("PURCHASE SHEET (MAIL)"))
{
ReliabilityDevision = "P";
}
lineIndex = 0;
}
}
sr.Close();
}
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
// Save file
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
string fn = filename;
filename = String.Format("MMTH_{0}_ORDER_{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), filename);
AsyncFileUpload1.SaveAs(Server.MapPath("~/Files/") + filename);
// HATC Order
string CustCode = "40113011";
filename = Server.MapPath("~/Files/") + filename;
if (File.Exists(filename))
{
string line = string.Empty;
using (StreamReader sr = new StreamReader(filename))
{
using (SqlProcedure sp = new SqlProcedure("sp_MMTH_Order_ClearData"))
{
sp.ExecuteNonQuery();
}
int i = 1;
while ((line = sr.ReadLine()) != null)
{
if (line.Length > 0)
{
if (line.Contains("T099") && !line.Contains("9999999999"))
{
string[] item = line.Split(Convert.ToChar("|"));
MyCompany.Models.MMTHOrderImport Order = new MyCompany.Models.MMTHOrderImport();
Order.OrderBy = CustCode;
Order.DeliveryDestination = item[2];
Order.CustomerMatCode = item[7].Trim();
string[] materialTemp = SharedBusinessRules.getMaterial(item[7].Trim(), CustCode, item[2], "MMTh").Split(':');
if (materialTemp.Length > 1)
{
Order.SAPCode = materialTemp[0];
Order.PartsDevision = materialTemp[1];
Order.DeliveryDestinationCode = materialTemp[2];
Order.Key1 = materialTemp[3];
Order.Key2 = materialTemp[4];
Order.Key3 = materialTemp[5];
}
Order.CustomerPO = item[4].Trim();
Order.ReliabilityDevision = "P";
Order.DeliveryDate = Convert.ToDateTime(item[5].Substring(0, 4).Trim() + "-" + item[5].Substring(5, 2).Trim() + "-" + item[5].Substring(8, 2).Trim());
Order.Quantity = float.Parse(item[8]).ToString().Trim();
Order.Unit = "ST";
Order.PlngPeriod = "D";
Order.AddCode = item[3] + ":" + item[6] + ":" + item[11] + ": :" + item[26] + ":" + i.ToString();
Order.PlantCode = item[10];
Order.Arrivaltime = "00:00:00";
Order.FromTo = item[1] + ":PLANT-" + item[2];
Order.Filename = fn;
Order.Insert();
i++;
}
}
}
sr.Close();
}
}
}
