public static int SaveMeetingsPage(InformPageModel ifp)
{
String strConn = ConfigurationManager.ConnectionStrings["Halfpint"].ToString();
using (var conn = new SqlConnection(strConn))
{
try
{
var cmd = new SqlCommand("", conn)
{
CommandType = System.Data.CommandType.StoredProcedure,
CommandText = ("SaveMeetingsPage")
};
var param = new SqlParameter("@headerContent", ifp.HeaderContent);
cmd.Parameters.Add(param);
param = new SqlParameter("@mainContent", ifp.MainContent);
cmd.Parameters.Add(param);
param = new SqlParameter("@footerContent", ifp.FooterContent);
cmd.Parameters.Add(param);
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Nlogger.LogError(ex);
return(0);
}
}
return(1);
}
public JsonResult Save([Bind(Include = "HeaderContent," +
"MainContent,FooterContent")] InformPageModel ifp)
{
if (ModelState.IsValid)
{
//check for not allowed input
DTO dto = DbInform.ValidateInput(ifp);
int iRetval = 0;
if (dto.ReturnValue == 1)
{
iRetval = DbInform.SaveInformPage(ifp);
}
if (iRetval != 1)
{
}
return(Json(dto));
}
else
{
return(null);
}
}
public JsonResult Save([Bind(Include = "HeaderContent," +
"MainContent,FooterContent")] InformPageModel ifp)
{
if (ModelState.IsValid)
{
if (ifp.FooterContent == null)
{
ifp.FooterContent = "<p></p>";
}
else
{
if (ifp.FooterContent.Length == 0)
{
ifp.FooterContent = "<p></p>";
}
}
if (ifp.HeaderContent == null)
{
ifp.HeaderContent = "<p></p>";
}
else
{
if (ifp.HeaderContent.Length == 0)
{
ifp.HeaderContent = "<p></p>";
}
}
if (ifp.MainContent == null)
{
ifp.MainContent = "<p></p>";
}
else
{
if (ifp.MainContent.Length == 0)
{
ifp.MainContent = "<p></p>";
}
}
//check for not allowed input
DTO dto = DbInform.ValidateInput(ifp);
int iRetval = 0;
if (dto.ReturnValue == 1)
{
iRetval = DbInform.SaveMeetingsPage(ifp);
}
return(Json(dto));
}
else
{
return(null);
}
}
public static InformPageModel GetMeetingsPage()
{
var ifp = new InformPageModel();
String strConn = ConfigurationManager.ConnectionStrings["Halfpint"].ToString();
SqlDataReader rdr = null;
using (var conn = new SqlConnection(strConn))
{
try
{
var cmd = new SqlCommand("", conn)
{
CommandType = System.Data.CommandType.StoredProcedure,
CommandText = ("GetMeetingsPage")
};
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int pos = rdr.GetOrdinal("HeaderContent");
ifp.HeaderContent = "";
if (!rdr.IsDBNull(pos))
{
ifp.HeaderContent = rdr.GetString(pos);
}
pos = rdr.GetOrdinal("MainContent");
ifp.MainContent = "";
if (!rdr.IsDBNull(pos))
{
ifp.MainContent = rdr.GetString(pos);
}
pos = rdr.GetOrdinal("FooterContent");
ifp.FooterContent = "";
if (!rdr.IsDBNull(pos))
{
ifp.FooterContent = rdr.GetString(pos);
}
}
rdr.Close();
}
catch (Exception ex)
{
Nlogger.LogError(ex);
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
}
return(ifp);
}
public static DTO ValidateInput(InformPageModel ifp)
{
string message = "";
var dto = new DTO {
ReturnValue = 1, IsSuccessful = true
};
string headerContent = ifp.HeaderContent.ToLower();
if (!IsValidContent(headerContent, ref message))
{
dto.Message = "Header Content: " + message;
dto.IsSuccessful = false;
dto.ReturnValue = 0;
return(dto);
}
string mainContent = ifp.MainContent.ToLower();
if (!IsValidContent(mainContent, ref message))
{
dto.Message = "Main Content: " + message;
dto.IsSuccessful = false;
dto.ReturnValue = 0;
return(dto);
}
string footerContent = ifp.FooterContent.ToLower();
if (!IsValidContent(footerContent, ref message))
{
dto.Message = "Footer Content: " + message;
dto.IsSuccessful = false;
dto.ReturnValue = 0;
return(dto);
}
return(dto);
}
public ActionResult Edit()
{
InformPageModel ifp = DbInform.GetInformPage();
return(View(ifp));
}
//
// GET: /Meetings/
public ActionResult Index()
{
InformPageModel ifp = DbInform.GetMeetingsPage();
return(View(ifp));
}
