public ActionResult ShowRegistration()
{
string DOB = "";
List <StudentInfo> _StudentInfo = new List <StudentInfo>();
DataSet dt = BussinessLogicController.GetSetRecord("exec sp_registration @id='', @Name='',@Email='',@Mobile='',@Course='',@age='',@DOB='',@action='select'");
if (dt.Tables.Count > 0)
{
if (dt.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
_StudentInfo.Add(new StudentInfo()
{
Name = dt.Tables[0].Rows[i]["Name"].ToString(),
id = Convert.ToInt32(dt.Tables[0].Rows[i]["id"]),
Email = dt.Tables[0].Rows[i]["Email"].ToString(),
Mobile = dt.Tables[0].Rows[i]["Mobile"].ToString(),
age = Convert.ToInt32(dt.Tables[0].Rows[0]["age"]),
Course = dt.Tables[0].Rows[i]["Course"].ToString(),
DOB = Convert.ToDateTime(dt.Tables[0].Rows[i]["DOB"])
});
}
}
}
// return View(_StudentInfo);
return(Json(_StudentInfo, JsonRequestBehavior.AllowGet));
}
public ActionResult Update(string id, string Name, string Email, string Mobile, string Course, string age, string DOB)
{
string Message = "";
// int Convertid = Convert.ToInt16(id);
DataSet updaterecord = BussinessLogicController.GetSetRecord("exec sp_registration @id='" + id + "', @Name='" + Name + "',@Email='" + Email + "',@Mobile='" + Mobile + "',@Course='" + Course + "',@age='" + age + "',@DOB='" + DOB + "',@action='update'");
if (updaterecord.Tables.Count > 0)
{
if (updaterecord.Tables[0].Rows.Count > 0)
{
Message = updaterecord.Tables[0].Rows[0]["message"].ToString();
ViewBag.Message = Message;
}
}
return(Json(Message, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Models.StudentInfo collection)
{
string message = "";
if (ModelState.IsValid)
{
string Name = collection.Name;
string Email = collection.Email;
string Mobile = collection.Mobile;
string Course = collection.Course;
int age = collection.age;
DateTime DOB = Convert.ToDateTime(collection.DOB);
// DataSet dt = con.GetRecordWithDataset("DECLARE @ScheduleDateTime DATETIME=getdate();Declare @ExpiryDateTime Datetime = getdate() + 91; exec glivebooks.dbo.[crm_insert_feed_lists] @Website_ID='9',@LoginID='" + ssn + "',@ListingID='" + ListingID + "',@FeedChannelID='" + feedchannelid + "',@ListingCategoryID='" + ListingCategoryID + "',@ListingTitle='" + ListingTitle + "',@ListingHeadline='',@ListingDescription='" + ListingDescription + "',@ScheduleDateTime=@ScheduleDateTime,@Expires=1,@ExpiryDateTime=@ExpiryDateTime,@FeedVisibilityID=3,@ActionButtonID=20,@ListingTopicsIDList='',@VisibilityExceptFriendList='',@VisibilitySpecificFriendList='',@CustomFriendListID='',@ResponseContactFeedChannelID='" + ResponseContactFeedChannelID + "',@FeedID='" + FeedId + "' ");
DataSet dt = BussinessLogicController.GetSetRecord("exec sp_registration @id='', @Name='" + Name + "',@Email='" + Email + "',@Mobile='" + Mobile + "',@Course='" + Course + "',@age='" + age + "',@DOB='" + DOB + "',@action='insert'");
if (dt.Tables.Count > 0)
{
if (dt.Tables[0].Rows.Count > 0)
{
message = dt.Tables[0].Rows[0]["message"].ToString();
ViewBag.Message = message;
}
}
// TODO: Add insert logic here
}
if (message == "")
{
return(View());
}
if (message == "you have successfully registered")
{
ModelState.Clear();
}
// return Json("",message, JsonRequestBehavior.AllowGet);
return(View());
}
// GET: Home/Delete/5
public ActionResult Delete(int id)
{
BussinessLogicController.GetSetRecord("exec sp_registration @id='" + id + "', @Name='',@Email='',@Mobile='',@Course='',@age='',@DOB='',@action='delete'");
return(View("Create"));
}