public Boolean AnularDB(prod_GestionProductivaTechos_CusTalme_Cab_Info info)
{
try
{
using (EntitiesProduccion context = new EntitiesProduccion())
{
var contact = context.prod_GestionProductivaTechos_CusTalme_Cab.FirstOrDefault(minfo => minfo.IdEmpresa == info.IdEmpresa && minfo.IdGestionProductiva == info.IdGestionProductiva);
if (contact != null)
{
contact.Estado = "I";
context.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
mensaje = ex.ToString() + " " + ex.Message;
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
throw new Exception(ex.ToString());
}
}
public Boolean GuardarDB(prod_GestionProductivaTechos_CusTalme_Cab_Info Info, ref decimal Id)
{
try
{
List <prod_GestionProductivaTechos_CusTalme_Cab_Info> Lst = new List <prod_GestionProductivaTechos_CusTalme_Cab_Info>();
using (EntitiesProduccion Context = new EntitiesProduccion())
{
var Address = new prod_GestionProductivaTechos_CusTalme_Cab();
Address.IdEmpresa = Info.IdEmpresa;
Address.IdGestionProductiva = Id = GetId(Info.IdEmpresa);
Address.IdProducto_MateriaPrima = Info.IdProducto_MateriaPrima;
Address.Fecha = Info.Fecha;
Address.IdModeloProd = Info.IdModeloProd;
Address.HrsTurno = Info.HrsTurno;
Address.Tprep = Info.Tprep;
Address.Despacho = Info.Despacho;
Address.Factor = Info.Factor;
Address.Num_Personas = Info.Num_Personas;
Address.Consumo = Info.Consumo;
Address.Chatarra = Info.Chatarra;
Address.IdTurno = Info.IdTurno;
Address.ip = Info.ip;
Address.Fecha_Transac = Info.Fecha_Transac;
Address.nom_pc = Info.nom_pc;
Address.IdUsuarioUltModi = Info.IdUsuarioUltModi;
Address.Fecha_UltMod = Info.Fecha_UltMod;
Address.Estado = "A";
Info.ListaDetalle.ForEach(var => { var.IdGestionProductiva = Address.IdGestionProductiva; var.IdEmpresa = Address.IdEmpresa; });
Context.prod_GestionProductivaTechos_CusTalme_Cab.Add(Address);
Context.SaveChanges();
if (dataDetalle.GuardarDB(Info.ListaDetalle))
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "", "", "", "", "", DateTime.Now);
mensaje = ex.ToString() + " " + ex.Message;
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
throw new Exception(ex.ToString());
}
}
void Get()
{
try
{
Info = new prod_GestionProductivaTechos_CusTalme_Cab_Info();
Info.Chatarra = Convert.ToDouble(txtChatarra.EditValue);
Info.Consumo = Convert.ToDouble(txtConsumo.EditValue);
if (txtDespacho.Text != "")
{
string[] I = txtDespacho.Text.Split(':');
TimeSpan hrI = new TimeSpan(Convert.ToInt16(I[0]), Convert.ToInt16(I[1]), 0);
Info.Despacho = hrI;
}
Info.IdModeloProd = Convert.ToInt32(CmbTipoModelo.EditValue);
Info.Factor = Convert.ToDouble(txtFactor.EditValue);
Info.Fecha = Convert.ToDateTime(dtpFecha.EditValue);
if (txtHrsTurno.Text != "")
{
string[] I = txtHrsTurno.Text.Split(':');
TimeSpan hrI = new TimeSpan(Convert.ToInt16(I[0]), Convert.ToInt16(I[1]), 0);
Info.HrsTurno = hrI;
}
Info.IdEmpresa = param.IdEmpresa;
Info.IdProducto_MateriaPrima = Convert.ToDecimal(cmbMateriaPrima.EditValue);
Info.IdTurno = Convert.ToInt32(CmbTurno.EditValue);
Info.Num_Personas = Convert.ToInt32(txtNumPersona.EditValue);
//Info.Tprep=txtTPrep.Text;
if (txtTPrep.Text != "")
{
string[] I = txtTPrep.Text.Split(':');
TimeSpan hrI = new TimeSpan(Convert.ToInt16(I[0]), Convert.ToInt16(I[1]), 0);
Info.Tprep = hrI;
}
for (int i = 0; i < GridView.RowCount; i++)
{
prod_GestionProductivaTechos_CusTalme_Detalle_Info Item = (prod_GestionProductivaTechos_CusTalme_Detalle_Info)GridView.GetRow(i);
if (Item != null)
{
Info.ListaDetalle.Add(Item);
}
}
Info.IdGestionProductiva = Convert.ToDecimal((txtIdGestion.EditValue == "") ? 0 : txtIdGestion.EditValue);
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
}
}
private void gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
Info = (prod_GestionProductivaTechos_CusTalme_Cab_Info)gridView.GetFocusedRow();
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
}
}
public Boolean AnularDB(prod_GestionProductivaTechos_CusTalme_Cab_Info Info)
{
try
{
cl_parametrosGenerales_Bus param = cl_parametrosGenerales_Bus.Instance;
Info.IdusuarioUltAnu = param.IdUsuario;
Info.Fecha_UltAnu = param.Fecha_Transac;
Info.nom_pc = param.nom_pc;
Info.ip = param.ip;
return(Data.AnularDB(Info));
}
catch (Exception ex)
{
Core.Erp.Info.Log_Exception.LoggingManager.Logger.Log(Core.Erp.Info.Log_Exception.LoggingCategory.Error, ex.Message);
throw new Core.Erp.Info.Log_Exception.DalException(string.Format("", "AnularDB", ex.Message), ex)
{
EntityType = typeof(prod_GestionProductivaTechos_CusTalme_Cab_Bus)
};
}
}
public Boolean GuardarDB(prod_GestionProductivaTechos_CusTalme_Cab_Info Info, ref decimal Id)
{
try
{
Info.Fecha_Transac = param.Fecha_Transac;
Info.Fecha_UltMod = param.Fecha_Transac;;
Info.IdUsuario = param.IdUsuario;
Info.IdUsuarioUltModi = param.IdUsuario;
Info.nom_pc = param.nom_pc;
Info.ip = param.ip;
return(Data.GuardarDB(Info, ref Id));
}
catch (Exception ex)
{
Core.Erp.Info.Log_Exception.LoggingManager.Logger.Log(Core.Erp.Info.Log_Exception.LoggingCategory.Error, ex.Message);
throw new Core.Erp.Info.Log_Exception.DalException(string.Format("", "GuardarDB", ex.Message), ex)
{
EntityType = typeof(prod_GestionProductivaTechos_CusTalme_Cab_Bus)
};
}
}