public static List <BusinessCard> getBusinessCards(int companyID)
{
List <BusinessCard> listCards = new List <BusinessCard>();
//todo modify webconfig
string cs = ConfigurationManager.ConnectionStrings["LinqConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("select * from Employee where companyID = '" + companyID + "'", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
BusinessCard obj = new BusinessCard();
obj.employerID = Convert.ToInt32(rdr["employeeID"]);
obj.name = rdr["name"].ToString();
obj.address = rdr["address"].ToString();
obj.email = rdr["email"].ToString();
obj.jobTitle = rdr["jobTitle"].ToString();
obj.phoneNumber = rdr["phoneNumber"].ToString();
listCards.Add(obj);
}
}
return(listCards);
}
public static void deleteRecord(BusinessCard card)
{
string cs = ConfigurationManager.ConnectionStrings["LinqConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("delete from Employee where employeeID=@Id", con);
con.Open();
cmd.Parameters.AddWithValue("Id", card.employerID);
cmd.ExecuteNonQuery();
}
}
public void insert_Click(object sender, EventArgs e)
{
var newBC = new BusinessCard();
newBC.name = newName.Text;
newBC.jobTitle = newTitle.Text;
newBC.address = newAddress.Text;
newBC.phoneNumber = newPhone.Text;
newBC.email = newEmail.Text;
newBC.companyID = companyID;
AccessLayer.addRecord(newBC);
insertModal.Attributes["style"] = "display:none";
Response.Redirect(Request.RawUrl);
}
public static void addRecord(BusinessCard obj)
{
string cs = ConfigurationManager.ConnectionStrings["LinqConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("insert into Employee (Name, JobTitle, PhoneNumber, Address, Email, CompanyId) values (@Name, @JobTitle, @PhoneNumber, @Address, @Email, @CompanyId)", con);
con.Open();
cmd.Parameters.AddWithValue("Name", obj.name);
cmd.Parameters.AddWithValue("JobTitle", obj.jobTitle);
cmd.Parameters.AddWithValue("PhoneNumber", obj.phoneNumber);
cmd.Parameters.AddWithValue("Address", obj.address);
cmd.Parameters.AddWithValue("Email", obj.email);
cmd.Parameters.AddWithValue("CompanyId", obj.companyID);
cmd.ExecuteNonQuery();
}
}
public static void updateRecord(BusinessCard card)
{
string cs = ConfigurationManager.ConnectionStrings["LinqConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("update Employee set name=@Name,address=@Address,phoneNumber=@phoneNumber," +
"email=@email,jobTitle=@jobTitle where employeeID=@Id", con);
con.Open();
cmd.Parameters.AddWithValue("Id", card.employerID);
cmd.Parameters.AddWithValue("Name", card.name);
cmd.Parameters.AddWithValue("Address", card.address);
cmd.Parameters.AddWithValue("phoneNumber", card.phoneNumber);
cmd.Parameters.AddWithValue("email", card.email);
cmd.Parameters.AddWithValue("jobTitle", card.jobTitle);
cmd.ExecuteNonQuery();
}
}
