// DELETE: api/FM/5
public object Options([FromBody] ServEmail model)
{
int result = ServEmailBLL.Delete(model);
if (result > 0)
{
return(new { result = 0 });
}
return(new { result = 1 });
}
internal static int Delete(ServEmail servEmail)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
int i = cn.Execute(@"delete from ServEmail where ServEmailID = @ServEmailID", servEmail);
cn.Close();
return(i);
}
}
internal static int Insert(ServEmail servEmail)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
int i = cn.Execute(@"insert into ServEmail(ServEmailTime,ServEmailTitle,ServEmailContent,ServEmailAuthor)values (@ServEmailTime,@ServEmailTitle,@ServEmailContent,@ServEmailAuthor)", servEmail);
cn.Close();
return(i);
}
}
public static int Delete(ServEmail servEmail)
{
return(ServEmailDAL.Delete(servEmail));
}
public static int Insert(ServEmail servEmail)
{
return(ServEmailDAL.Insert(servEmail));
}