public NotaEntity traerNotaCompleta(string ItemID) { NotaEntity myNota = new NotaEntity(); try { string query = "SELECT * FROM G_Notas Where PK_ID = " + ItemID; ds = _GetAllData(query); if (ds.Tables[0].Rows.Count > 0) { myNota.User_id = ds.Tables[0].Rows[0][enumTableNota.FK_User.ToString()].ToString().Trim() + ""; myNota.User_AdminID = ds.Tables[0].Rows[0][enumTableNota.FK_Techician.ToString()].ToString().Trim() + ""; myNota.User_Tipo = ds.Tables[0].Rows[0][enumTableNota.tipo.ToString()].ToString().Trim() + ""; myNota.User_Titulo = ds.Tables[0].Rows[0][enumTableNota.Title.ToString()].ToString().Trim() + ""; myNota.User_Nota = ds.Tables[0].Rows[0][enumTableNota.description.ToString()].ToString().Trim() + ""; myNota.User_Fecha = ds.Tables[0].Rows[0][enumTableNota.Date.ToString()].ToString().Trim() + ""; myNota.User_MostrarInicio = ds.Tables[0].Rows[0]["estado"].ToString().Trim() + ""; if (myNota.User_Fecha.Equals("")) { myNota.User_Fecha = DateTime.Now.ToShortDateString(); } } //cerrar(); return(myNota); } catch { return(myNota); } }
public void SalvarNota(bool isNew, string NotaID, NotaEntity myNota) { try { string query = "SELECT * FROM G_Notas Where PK_ID = " + NotaID; ds = _GetAllData(query); DataRow dr; if (isNew) { dr = ds.Tables[0].NewRow(); } else { dr = ds.Tables[0].Rows[0]; } dr[enumTableNota.FK_User.ToString()] = myNota.User_UserID; dr[enumTableNota.FK_Techician.ToString()] = myNota.User_AdminID; dr[enumTableNota.tipo.ToString()] = myNota.User_Tipo; dr[enumTableNota.Title.ToString()] = myNota.User_Titulo; dr[enumTableNota.description.ToString()] = myNota.User_Nota; dr[enumTableNota.Date.ToString()] = myNota.User_Fecha; dr["estado"] = myNota.User_MostrarInicio; if (isNew) { ds.Tables[0].Rows.Add(dr); } dest.Update(ds, ds.Tables[0].TableName.ToString()); cerrar(); return; } catch (Exception e) { throw(e); } }