internal CONTACTINFO Get()
{
CONTACTINFO contactInfo = new CONTACTINFO();
using (con = new SqlConnection(connectionString))
{
string checkSql = @"SELECT * FROM TCONTACTINFO";
using (SqlCommand checkCmd = new SqlCommand(checkSql, con))
{
con.Open();
SqlDataReader checkReader = checkCmd.ExecuteReader();
if (checkReader.Read())
{
contactInfo = new CONTACTINFO()
{
ID = (int)checkReader["ID"],
EMAIL = (string)checkReader["EMAIL"],
PHONE = (string)checkReader["PHONE"],
ADDRESS = (string)checkReader["ADDRESS"],
FACEBOOK = (string)checkReader["FACEBOOK"],
INSTAGRAM = (string)checkReader["INSTAGRAM"],
TWITTER = (string)checkReader["TWITTER"]
};
}
}
}
return(contactInfo);
}
public ActionResult UpdateContactInfo(CONTACTINFO contactInfo)
{
try
{
if (ModelState.IsValid)
{
contactInfoDA.Update(contactInfo);
return(RedirectToAction("ContactInfo", "Admin"));
}
else
{
ViewBag.Error = "Try Again.";
return(View("ContactInfo", contactInfo));
}
}
catch (Exception ex)
{
ViewBag.Error = "Try Again.";
return(View("ContactInfo", contactInfo));
}
}
internal void Insert(CONTACTINFO contactInfo)
{
using (con = new SqlConnection(connectionString))
{
string sqlQuery = $@"INSERT INTO TCONTACTINFO (ADDRESS, PHONE, EMAIL, FACEBOOK, TWITTER, INSTAGRAM) VALUES
(@ADDRESS, @PHONE, @EMAIL, @FACEBOOK, @TWITTER, @INSTAGRAM)";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@PHONE", contactInfo.PHONE);
cmd.Parameters.AddWithValue("@EMAIL", contactInfo.EMAIL);
cmd.Parameters.AddWithValue("@ADDRESS", contactInfo.ADDRESS);
cmd.Parameters.AddWithValue("@TWITTER", contactInfo.TWITTER);
cmd.Parameters.AddWithValue("@INSTAGRAM", contactInfo.INSTAGRAM);
cmd.Parameters.AddWithValue("@FACEBOOK", contactInfo.FACEBOOK);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
internal void Update(CONTACTINFO contactInfo)
{
using (con = new SqlConnection(connectionString))
{
string sqlQuery = $@"UPDATE TCONTACTINFO SET ADDRESS=@ADDRESS, PHONE=@PHONE, EMAIL=@EMAIL, FACEBOOK=@FACEBOOK, TWITTER=@TWITTER, INSTAGRAM=@INSTAGRAM WHERE ID=@ID";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@PHONE", contactInfo.PHONE);
cmd.Parameters.AddWithValue("@EMAIL", contactInfo.EMAIL);
cmd.Parameters.AddWithValue("@ADDRESS", contactInfo.ADDRESS);
cmd.Parameters.AddWithValue("@TWITTER", contactInfo.TWITTER);
cmd.Parameters.AddWithValue("@INSTAGRAM", contactInfo.INSTAGRAM);
cmd.Parameters.AddWithValue("@FACEBOOK", contactInfo.FACEBOOK);
cmd.Parameters.AddWithValue("@ID", contactInfo.ID);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public ActionResult ContactInfo()
{
if (Session["ID"] == null)
{
return(RedirectToAction("Index"));
}
CONTACTINFO contactInfo = contactInfoDA.Get();
if (contactInfo.ID <= 0)
{
contactInfo.PHONE = "";
contactInfo.EMAIL = "";
contactInfo.ADDRESS = "";
contactInfo.FACEBOOK = "";
contactInfo.TWITTER = "";
contactInfo.INSTAGRAM = "";
contactInfoDA.Insert(contactInfo);
contactInfo = contactInfoDA.Get();
}
return(View(contactInfo));
}
public ActionResult _ContactInfo()
{
CONTACTINFO contactInfo = contactInfoDA.Get();
return(PartialView(contactInfo));
}
