public bool AddGuestbookMSG(TGuestbook model)
{
var NowTime = DateTime.Now;
model.BoredSetTime = NowTime;
return(_bendguestbookDal.AddGuestbookMSG(model));
}
public ActionResult EditorBendInfoMSG(TGuestbook model)
{
var result = false;
result = _bendguestbookBll.UpdateGuestbookMSG(model);
return(RedirectToAction("BendGuestbookIndex", "BendGuestbook"));
}
public ActionResult AddGuestbookMSG(TGuestbook model)
{
var result = false;
result = _bendguestbookBll.AddGuestbookMSG(model);
return(RedirectToAction("BendGuestbookIndex", "BendGuestbook"));
}
public bool AddGuestbookMSG(TGuestbook model)
{
var result = false;
const string AddGuestbookMSGsql = @"
INSERT INTO dbo.TGuestbook
( BoredTital, BoredName,BoredBody,BoredSetTime,BoredTelphone,BoredEmail,BoredIndex)
VALUES ( @BoredTital,
@BoredName,
@BoredBody,
@BoredSetTime,
@BoredTelphone,
@BoredEmail,
@BoredIndex
)";
try
{
using (DbConnection conn = DbFactory.CreateConnection())
{
result = conn.Execute(AddGuestbookMSGsql, model) > 0;
return(result);
}
}
catch (System.Exception ex)
{
throw;
}
}
public ActionResult AddGuestbookMSG(TGuestbook model)
{
BendGuestbookBll _bendguestbookBll = new BendGuestbookBll();
var result = false;
result = _bendguestbookBll.AddGuestbookMSG(model);
return(RedirectToAction("HomeIndex", "Home"));
}
public bool UpdateGuestbookMSG(TGuestbook model)
{
const string UpdateGuestbookMSGsql = @"
UPDATE dbo.TGuestbook
SET BoredTital = @BoredTital,
BoredName = @BoredName,
BoredBody = @BoredBody,
BoredSetTime = @BoredSetTime,
BoredTelphone = @BoredTelphone,
BoredEmail = @BoredEmail,
BoredIndex = @BoredIndex
WHERE ID=@ID" ;
using (DbConnection conn = DbFactory.CreateConnection())
{
var result = conn.Execute(UpdateGuestbookMSGsql, model) > 0;
return(result);
}
}
public bool UpdateGuestbookMSG(TGuestbook model)
{
return(_bendguestbookDal.UpdateGuestbookMSG(model));
}
