public JsonResult GetQuestionTypeInfo(EPortal.Models.QuestionType QuestionTypeinfo)
{
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
QuestionTypeList QuestionTypeinfoQuestionType = new QuestionTypeList();
using (EPortalEntities entity = new EPortalEntities())
{
QuestionTypeinfoQuestionType = (from o in entity.QuestionTypes
where o.Id == QuestionTypeinfo.Id &&
o.OrganizationID == orgid
select new QuestionTypeList
{
Id = o.Id,
TypeCode = o.TypeCode,
TypeName = o.TypeName,
Operation = "Edit"
}).FirstOrDefault();
}
return(Json(QuestionTypeinfoQuestionType, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteQuestionType(EPortal.Models.QuestionType QuestionTypeinfo)
{
int result = 0;
string errormsg = string.Empty;
// validation = EPortal.Utility.Utility.ValidateProperty(orgdata.Code, "Required");
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
using (EPortalEntities entity = new EPortalEntities())
{
var checkisusedornot = (from ques in entity.Questions
where ques.OrganizationID == orgid &&
ques.QuestionTypeId == QuestionTypeinfo.Id
select ques).FirstOrDefault();
if (checkisusedornot == null)
{
var checkquestionsoirce = (from qs in entity.Questionsources
where qs.OrganizationID == orgid &&
qs.QuestionTypeId == QuestionTypeinfo.Id
select qs).FirstOrDefault();
if (checkquestionsoirce == null)
{
entity.Entry(QuestionTypeinfo).State = System.Data.Entity.EntityState.Deleted;
result = entity.SaveChanges();
}
else
{
errormsg = "Operation conflict:Operation cannot be performed.Record already in Used.";
}
}
else
{
errormsg = "Operation conflict:Operation cannot be performed.Record already in Used.";
}
}
return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveQuestionType(EPortal.Models.QuestionType QuestionTypeInfo)
{
string errormsg = "";
int result = 0;
//if ((QuestionTypeInfo.TypeCode != "" || QuestionTypeInfo.TypeCode != null) && (QuestionTypeInfo.TypeName != "" || QuestionTypeInfo.TypeName != null))
{
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
using (EPortalEntities entity = new EPortalEntities())
{
if (QuestionTypeInfo.Operation == "Create")
{
var checkquestiontype = (from qt in entity.QuestionTypes
where qt.OrganizationID == orgid &&
qt.TypeCode == QuestionTypeInfo.TypeCode
select qt).FirstOrDefault();
if (checkquestiontype == null)
{
QuestionTypeInfo.Id = Guid.NewGuid().ToString();
QuestionTypeInfo.OrganizationID = orgid;
QuestionTypeInfo.RowState = true;
QuestionTypeInfo.CreateDateTime = System.DateTime.Now;
entity.Entry(QuestionTypeInfo).State = System.Data.Entity.EntityState.Added;
entity.QuestionTypes.Add(QuestionTypeInfo);
try
{
result = entity.SaveChanges();
}
catch (Exception ex)
{
}
}
else
{
errormsg = "Question Type already exist with same Code.";
}
}
else
{
EPortal.Models.QuestionType usedata = (from o in entity.QuestionTypes
where o.OrganizationID == orgid &&
o.Id == QuestionTypeInfo.Id
select o
).FirstOrDefault();
usedata.TypeCode = QuestionTypeInfo.TypeCode;
usedata.TypeName = QuestionTypeInfo.TypeName;
entity.Entry(usedata).State = System.Data.Entity.EntityState.Modified;
try
{
result = entity.SaveChanges();
}
catch (Exception ex)
{
}
}
}
}
//else
//{
// if (QuestionTypeInfo.TypeCode != "" || QuestionTypeInfo.TypeCode != null)
// {
// errormsg = "Please enter TypeCode.";
// }
// if (QuestionTypeInfo.TypeName != "" || QuestionTypeInfo.TypeName != null)
// {
// errormsg = "Please enter Name.";
// }
//}
return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
}