public int InsertTopRailxHorizontalDivisions(TopRailxHorizontalDivisions pTopRailxHorizontalDivisions) { try { return(_AD.InsertTopRailxHorizontalDivisions(pTopRailxHorizontalDivisions)); } catch (Exception ex) { throw; } }
public bool UpdateTopRailxHorizontalDivisions(TopRailxHorizontalDivisions pTopRailxHorizontalDivisions) { try { _AD.UpdateTopRailxHorizontalDivisions(pTopRailxHorizontalDivisions); return(true); } catch (Exception ex) { throw; } }
public void UpdateTopRailxHorizontalDivisions(TopRailxHorizontalDivisions pTop) { string sql = @"[spUpdateTopRailxHorizontalDivisions] '{0}', '{1}', '{2}', '{3}', '{4}'"; sql = string.Format(sql, pTop.Id, pTop.TopRail.Id, pTop.HorizontalDivisions.Id, pTop.Status.Id, pTop.ModificationUser); try { _MB.EjecutarSQL(_CN, sql); } catch (Exception err) { throw err; } }
public int InsertTopRailxHorizontalDivisions(TopRailxHorizontalDivisions pTop) { string sql = @"[spInsertTopRailxHorizontalDivisions] '{0}', '{1}', '{2}', '{3}', '{4}'"; sql = string.Format(sql, pTop.TopRail.Id, pTop.HorizontalDivisions.Id, pTop.Status.Id, pTop.CreatorUser, pTop.ModificationUser); try { return(_MB.EjecutarSQL(_CN, sql)); } catch (Exception err) { throw err; } }
public TopRailxHorizontalDivisions GetTopRailxHorizontalDivisionsById(int Id) { TopRailxHorizontalDivisions topdiv = new TopRailxHorizontalDivisions(); string sql = @"[spGetTopRailxHorizontalDivisions] '{0}' "; sql = string.Format(sql, Id); try { DataSet ds = new DataSet(); ds = _MB.CreaDS(ds, "TopRailxHorizontalDivisions", sql, _CN); if (ds.Tables["TopRailxHorizontalDivisions"].Rows.Count > 0) { foreach (DataRow item in ds.Tables["TopRailxHorizontalDivisions"].Rows) { topdiv = new TopRailxHorizontalDivisions() { Id = int.Parse(item["Id"].ToString()), TopRail = new TopRail() { Id = int.Parse(item["IdTopRail"].ToString()), Description = item["DescripTopRail"].ToString(), }, HorizontalDivisions = new HorizontalDivisions() { Id = int.Parse(item["IdTopRail"].ToString()), Quantity = int.Parse(item["HorizontalDivision"].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(topdiv); } catch (Exception) { throw; } }