public static int Update(AnketPuan p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MySQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "update anketpuan set hesapid=?hesapid,anketid=?anketid,soruid=?soruid,ip=?ip where id=?id", conneciton)) { cmd.Parameters.Add("id", p.ID, MSqlDbType.VarChar); cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar); cmd.Parameters.Add("anketid", p.AnketID, MSqlDbType.BigInt); cmd.Parameters.Add("soruid", p.SoruID, MSqlDbType.BigInt); cmd.Parameters.Add("ip", p.IP, MSqlDbType.VarChar); rowsAffected = cmd.ExecuteNonQuery(); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static int Delete(AnketPuan p) { int rowsAffected = 0; using (MConnection conneciton = new MConnection(MClientProvider.MySQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "delete from anketpuan where id=?id", conneciton)) { cmd.Parameters.Add("id", p.ID, MSqlDbType.VarChar); rowsAffected = cmd.ExecuteNonQuery(); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static AnketPuan GetAnketPuan(System.String pid) { AnketPuan rvAnketPuan = new AnketPuan(); using (MConnection conneciton = new MConnection(MClientProvider.MySQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(CommandType.Text, "select * from anketpuan where id=?id limit 1", conneciton)) { cmd.Parameters.Add("id", pid, MSqlDbType.VarChar); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvAnketPuan = new AnketPuan(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToInt64(IDR["anketid"]), MConvert.NullToInt64(IDR["soruid"]), MConvert.NullToString(IDR["ip"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvAnketPuan); }
public static AnketPuan GetAnketPuan(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { AnketPuan rvAnketPuan = new AnketPuan(); using (MConnection conneciton = new MConnection(MClientProvider.MySQL)) { switch (conneciton.State) { case System.Data.ConnectionState.Closed: conneciton.Open(); break; } using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton)) { if (parameters != null) { foreach (MParameter item in parameters) { cmd.Parameters.Add(item); } } using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvAnketPuan = new AnketPuan(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToInt64(IDR["anketid"]), MConvert.NullToInt64(IDR["soruid"]), MConvert.NullToString(IDR["ip"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvAnketPuan); }
public void Remove(AnketPuan obj) { this.List.Remove(obj); }
public int IndexOf(AnketPuan obj) { return(this.List.IndexOf(obj)); }
public bool Contains(AnketPuan obj) { return(this.List.Contains(obj)); }
public void Insert(int index, AnketPuan obj) { this.List.Insert(index, obj); }
public int Add(AnketPuan obj) { return(this.List.Add(obj)); }