public int InsertDoorStylexOutsideEdgeProfile(DoorStyle pDoorStyle)
{
try
{
DoorStylexOutsideEdgeProfile doorStylexInside = new DoorStylexOutsideEdgeProfile();
foreach (var item in pDoorStyle.listOutsideProfile)
{
doorStylexInside.CreationDate = DateTime.Now;
doorStylexInside.ModificationDate = DateTime.Now;
doorStylexInside.OutsideEdgeProfile = new OutsideEdgeProfile()
{
Id = item.Id
};
doorStylexInside.DoorStyle = new DoorStyle()
{
Id = pDoorStyle.Id
};
doorStylexInside.Status = new Status()
{
Id = pDoorStyle.Status.Id
};
_AD.InsertDoorStylexOutsideEdgeProfile(doorStylexInside);
}
return(1);
}
catch (Exception ex)
{
throw;
}
}
public bool UpdateDoorStylexOutsideEdgeProfile(DoorStylexOutsideEdgeProfile pDoorStylexOutsideEdgeProfile)
{
try
{
_AD.UpdateDoorStylexOutsideEdgeProfile(pDoorStylexOutsideEdgeProfile);
return(true);
}
catch (Exception ex)
{
throw;
}
}
public void UpdateDoorStylexOutsideEdgeProfile(DoorStylexOutsideEdgeProfile pDoorStylexOutsideEdgeProfile)
{
string sql = @"[spUpdateDoorStylexOutsideEdgeProfile] '{0}', '{1}', '{2}', '{3}', '{4}'";
sql = string.Format(sql, pDoorStylexOutsideEdgeProfile.Id, pDoorStylexOutsideEdgeProfile.DoorStyle.Id, pDoorStylexOutsideEdgeProfile.OutsideEdgeProfile.Id, pDoorStylexOutsideEdgeProfile.Status.Id,
pDoorStylexOutsideEdgeProfile.ModificationUser);
try
{
_MB.EjecutarSQL(_CN, sql);
}
catch (Exception err)
{
throw err;
}
}
public int InsertDoorStylexOutsideEdgeProfile(DoorStylexOutsideEdgeProfile pDoorStylexOutsideEdgeProfile)
{
string sql = @"[spInsertDoorStylexOutsideEdgeProfile] '{0}', '{1}', '{2}', '{3}', '{4}'";
sql = string.Format(sql, pDoorStylexOutsideEdgeProfile.DoorStyle.Id, pDoorStylexOutsideEdgeProfile.OutsideEdgeProfile.Id, pDoorStylexOutsideEdgeProfile.Status.Id,
pDoorStylexOutsideEdgeProfile.CreatorUser, pDoorStylexOutsideEdgeProfile.ModificationUser);
try
{
return(_MB.EjecutarSQL(_CN, sql));
}
catch (Exception err)
{
throw err;
}
}
public DoorStylexOutsideEdgeProfile GetDoorStylexOutsideEdgeProfileById(int Id)
{
DoorStylexOutsideEdgeProfile doorxoutside = new DoorStylexOutsideEdgeProfile();
string sql = @"[spGetDoorStylexOutsideEdgeProfile] '{0}' ";
sql = string.Format(sql, Id);
try
{
DataSet ds = new DataSet();
ds = _MB.CreaDS(ds, "DoorStylexOutsideEdgeProfile", sql, _CN);
if (ds.Tables["DoorStylexOutsideEdgeProfile"].Rows.Count > 0)
{
foreach (DataRow item in ds.Tables["DoorStylexOutsideEdgeProfile"].Rows)
{
doorxoutside = new DoorStylexOutsideEdgeProfile()
{
Id = int.Parse(item["Id"].ToString()),
DoorStyle = new DoorStyle()
{
Id = int.Parse(item["IdDoorStyle"].ToString()), Description = item["DescripDoorStyle"].ToString()
},
OutsideEdgeProfile = new OutsideEdgeProfile()
{
Id = int.Parse(item["IdOutsideEdgeProfile"].ToString()), Description = item["DescriptOEP"].ToString(),
},
Status = new Status()
{
Id = int.Parse(item["IdStatus"].ToString()), Description = item["DescripStatus"].ToString()
},
CreationDate = (item["CreationDate"].ToString() != "") ? DateTime.Parse(item["CreationDate"].ToString()) : DateTime.Parse("01/01/1900"),
ModificationDate = (item["ModificationDate"].ToString() != "") ? DateTime.Parse(item["ModificationDate"].ToString()) : DateTime.Parse("01/01/1900"),
CreatorUser = int.Parse(item["CreatorUser"].ToString()),
ModificationUser = int.Parse(item["ModificationUser"].ToString()),
};
}
}
return(doorxoutside);
}
catch (Exception)
{
throw;
}
}