public HomeViewModel()
{
FriendlyMessage = new List <FriendlyMessage>();
Pager = new PaginationInfo();
blog = new BlogInfo();
blogs = new List <BlogInfo>();
service = new ServiceInfo();
services = new List <ServiceInfo>();
aboutus = new AboutUsInfo();
testimonials = new List <TestimonialInfo>();
events = new List <EventInfo>();
Event = new EventInfo();
Filter = new Home_Filter();
}
public bool Set(AboutUsInfo model)
{
bool retrunValue = true;
try
{
string spName = "uspAboutInsertUpdate";
SqlParameter[] param =
{
SqlHelper.SqlParameter("@aboutus_id", System.Data.SqlDbType.Int, model.AboutUsId),
SqlHelper.SqlParameter("@aboutus1", System.Data.SqlDbType.VarChar, model.AboutUs1, true),
SqlHelper.SqlParameter("@aboutus2", System.Data.SqlDbType.VarChar, model.AboutUs2, true),
SqlHelper.SqlParameter("@aboutus3", System.Data.SqlDbType.VarChar, model.AboutUs3, true),
SqlHelper.SqlParameter("@userId", System.Data.SqlDbType.VarChar, model.LoginUser, true)
};
int Resultval = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.StoredProcedure, spName, param);
if (Resultval <= 0)
{
retrunValue = false;
}
}
catch (Exception ex)
{
retrunValue = false;
}
return(retrunValue);
}
public AboutUsInfo Get(AboutUsInfo model)
{
AboutUsInfo returnValue = new AboutUsInfo();
try
{
string spName = "uspAboutInsertUpdate";
SqlParameter[] param =
{
SqlHelper.SqlParameter("@aboutus_id", System.Data.SqlDbType.Int, model.AboutUsId)
};
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.StoredProcedure, spName, param))
{
while (rdr.Read())
{
returnValue.AboutUsId = rdr.GetInt32(0);
returnValue.AboutUs1 = rdr.GetString(1);
returnValue.AboutUs2 = rdr.GetString(2);
returnValue.AboutUs3 = rdr.GetString(3);
}
}
}
catch (Exception ex)
{
}
return(returnValue);
}
private AboutUsInfo Get_About_Us_Values(DataRow dr)
{
AboutUsInfo aboutus = new AboutUsInfo();
aboutus.About_Us_Id = Convert.ToInt32(dr["About_Us_Id"]);
aboutus.About_Us_Template = Convert.ToString(dr["About_Us_Template"]);
aboutus.Header_Image = Convert.ToInt32(dr["Header_Image"]);
aboutus.Alternative_Text = Convert.ToString(dr["Alternative_Text"]);
aboutus.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
aboutus.Created_By = Convert.ToInt32(dr["Created_By"]);
aboutus.Updated_By = Convert.ToInt32(dr["Updated_By"]);
aboutus.Created_On = Convert.ToDateTime(dr["Created_On"]);
aboutus.Updated_On = Convert.ToDateTime(dr["Updated_On"]);
if (dr["File_Type"] != DBNull.Value)
{
aboutus.File_Type = Convert.ToInt32(dr["File_Type"]);
}
if (dr["Unique_Id"] != DBNull.Value)
{
aboutus.Header_Image_Url = Convert.ToString(dr["Unique_Id"]);
}
return(aboutus);
}
public ActionResult About()
{
AboutUs aboutUs = new AboutUs();
//AboutUsInfo returnValue = aboutUs.Get(new AboutUsInfo());
AboutUsInfo returnValue = new AboutUsInfo();
return(View(returnValue));
}
private List <SqlParameter> Set_Values_In_About_Us(AboutUsInfo aboutus)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@About_Us_Id", aboutus.About_Us_Id));
sqlParams.Add(new SqlParameter("@About_Us_Template", aboutus.About_Us_Template));
sqlParams.Add(new SqlParameter("@Header_Image", aboutus.Header_Image));
sqlParams.Add(new SqlParameter("@Alternative_Text", aboutus.Alternative_Text));
sqlParams.Add(new SqlParameter("@Is_Active", aboutus.Is_Active));
sqlParams.Add(new SqlParameter("@Updated_By", aboutus.Updated_By));
sqlParams.Add(new SqlParameter("@Updated_On", aboutus.Updated_On));
return(sqlParams);
}
public AboutUsInfo Get_About_Us_By_Id(int About_Us_Id)
{
AboutUsInfo aboutus = new AboutUsInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@About_Us_Id", About_Us_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_About_Us_By_Id_Sp.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
aboutus = Get_About_Us_Values(dr);
}
return(aboutus);
}
public ActionResult About(AboutUsInfo model)
{
AboutUs aboutUs = new AboutUs();
bool returnVal = true;
if (ModelState.IsValid)
{
if (model.AboutUsId > 0)
{
returnVal = aboutUs.Set(model);
}
else
{
returnVal = aboutUs.Insert(model);
}
}
return(this.Json(returnVal, JsonRequestBehavior.AllowGet));
}
public AboutUsViewModel()
{
FriendlyMessage = new List <FriendlyMessage>();
aboutus = new AboutUsInfo();
}
public void Update_About_Us(AboutUsInfo aboutus)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_About_Us(aboutus), StoredProcedures.Update_About_Us_Sp.ToString(), CommandType.StoredProcedure);
}
public AboutUsInfo Get(AboutUsInfo model)
{
AboutUsDAL obj = new AboutUsDAL();
return(obj.Get(model));
}
public bool Set(AboutUsInfo model)
{
AboutUsDAL obj = new AboutUsDAL();
return(obj.Set(model));
}
public bool Insert(AboutUsInfo model)
{
AboutUsDAL obj = new AboutUsDAL();
return(obj.Insert(model));
}
public void Update_About_Us(AboutUsInfo aboutus)
{
_aboutusRepo.Update_About_Us(aboutus);
}
