public ContCardPic GetContCardPICByID(long contCardPICID) { ContCardPic contCardPic = new ContCardPic(); try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } string query = "SELECT contcardpicid,contcardid,picdtm,picname,picdata FROM contcardpic WHERE contcardpicid=@id "; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@id", contCardPICID); using (NpgsqlDataReader npgsqlDataReader = npgsqlCommand.ExecuteReader()) { if (npgsqlDataReader.Read()) { MappingDataReaderToContCardpic(npgsqlDataReader, contCardPic); } } } } } catch (Exception ex) { throw ex; } return(contCardPic); }
public bool InsertContCardPIC(ContCardPic contCardPic) { bool result = false; try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } contCardPic.ContCardPicID = CtsCounter.NextValCtsCounter("CONTCARDPIC_CONTCARDPICID_SEQ"); contCardPic.PicDtm = DateTime.Now; string query = "INSERT INTO contcardpic(contcardpicid,contcardid,picdtm,picname,picdata) VALUES(@contcardpicid,@contcardid,@picdtm,@picname,@picdata) "; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@contcardpicid", contCardPic.ContCardPicID); npgsqlCommand.Parameters.AddWithValue("@contcardid", contCardPic.ContCardID); npgsqlCommand.Parameters.AddWithValue("@picdtm", contCardPic.PicDtm); npgsqlCommand.Parameters.AddWithValue("@picname", contCardPic.PicName); npgsqlCommand.Parameters.AddWithValue("@picdata", contCardPic.PicData); npgsqlCommand.ExecuteNonQuery(); result = true; } } } catch (Exception ex) { throw ex; } return(result); }
public bool UpdateContCardPIC(ContCardPic contCardPic) { bool result = false; try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } string query = "UPDATE contcardpic SET contcardid=@contcardid, picdtm=@picdtm, picname=@picname, picdata=@picdata WHERE contcardpicid=@contcardpicid "; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@contcardpicid", contCardPic.ContCardPicID); npgsqlCommand.Parameters.AddWithValue("@contcardid", contCardPic.ContCardID); npgsqlCommand.Parameters.AddWithValue("@picdtm", contCardPic.PicDtm); npgsqlCommand.Parameters.AddWithValue("@picname", contCardPic.PicName); npgsqlCommand.Parameters.AddWithValue("@picdata", contCardPic.PicData); npgsqlCommand.ExecuteNonQuery(); result = true; } } } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// create new table contcardpic /// </summary> /// <param name="npgsqlDataReader"></param> /// <param name="contCardPIC"></param> private void MappingDataReaderToContCardpic(NpgsqlDataReader npgsqlDataReader, ContCardPic contCardPIC) { contCardPIC.ContCardPicID = npgsqlDataReader.GetInt64(npgsqlDataReader.GetOrdinal("ContCardPicID")); contCardPIC.ContCardID = npgsqlDataReader.GetInt64(npgsqlDataReader.GetOrdinal("ContCardID")); contCardPIC.PicDtm = npgsqlDataReader.GetDateTime(npgsqlDataReader.GetOrdinal("PicDtm")); contCardPIC.PicName = npgsqlDataReader.GetString(npgsqlDataReader.GetOrdinal("PicName")); contCardPIC.PicData = (byte[])npgsqlDataReader[4]; }