public JsonResult DeleteQuestionSource(EPortal.Models.Questionsource QuestionSourceinfo)
{
int result = 0;
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
string errormsg = string.Empty;
// validation = EPortal.Utility.Utility.ValidateProperty(orgdata.Code, "Required");
using (EPortalEntities entity = new EPortalEntities())
{
var checkreferance = (from r in entity.Questions
where r.OrganizationID == orgid &&
r.SourceId == QuestionSourceinfo.Id
select r).FirstOrDefault();
if (checkreferance != null)
{
errormsg = "Operation conflict:Operation cannot be performed.Record already in Used.";
}
else
{
entity.Entry(QuestionSourceinfo).State = System.Data.Entity.EntityState.Deleted;
result = entity.SaveChanges();
}
}
return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetQuestionSourceInfo(EPortal.Models.Questionsource QuestionSourceinfo)
{
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
List <QuestionTypeliSt> questiontypelist = new List <QuestionTypeliSt>();
QuestionSourceList QuestionSourceinfoQuestionSource = new QuestionSourceList();
using (EPortalEntities entity = new EPortalEntities())
{
QuestionSourceinfoQuestionSource = (from o in entity.Questionsources
where o.Id == QuestionSourceinfo.Id &&
o.OrganizationID == orgid
select new QuestionSourceList
{
Id = o.Id,
SourceCode = o.SourceCode,
SourceName = o.SourceName,
ResourceText = o.ResourceText,
QuestionTypeId = o.QuestionTypeId,
Operation = "Edit"
}).FirstOrDefault();
questiontypelist = (from qt in entity.QuestionTypes
where qt.OrganizationID == orgid
select new QuestionTypeliSt
{
QuestionTypeId = qt.Id,
QuestionTypeCode = qt.TypeCode,
QuestionTypeName = qt.TypeName
}).ToList();
}
questiontypelist.Insert(0, new QuestionTypeliSt {
QuestionTypeId = "0", QuestionTypeCode = "Select", QuestionTypeName = "Select"
});
return(Json(new { sourcedata = QuestionSourceinfoQuestionSource, atypelist = questiontypelist }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveQuestionSource(EPortal.Models.Questionsource QuestionSourceInfo, string sourcetestinfo)
{
string errormsg = "";
int result = 0;
//if ((QuestionSourceInfo.SourceCode != "" || QuestionSourceInfo.SourceCode != null) && (QuestionSourceInfo.SourceName != "" || QuestionSourceInfo.SourceName != null))
{
//string orgid = Session["OrgId"].ToString();
string orgid = User.OrgId;
using (EPortalEntities entity = new EPortalEntities())
{
if (QuestionSourceInfo.Operation == "Create")
{
var questionsourcedub = (from qs in entity.Questionsources
where qs.OrganizationID == orgid &&
qs.QuestionTypeId == QuestionSourceInfo.QuestionTypeId &&
qs.SourceCode == QuestionSourceInfo.SourceCode
select qs).FirstOrDefault();
if (questionsourcedub == null)
{
QuestionSourceInfo.ResourceText = sourcetestinfo;
QuestionSourceInfo.Id = Guid.NewGuid().ToString();
QuestionSourceInfo.OrganizationID = orgid;
QuestionSourceInfo.RowState = true;
QuestionSourceInfo.CreateDateTime = System.DateTime.Now;
entity.Entry(QuestionSourceInfo).State = System.Data.Entity.EntityState.Added;
entity.Questionsources.Add(QuestionSourceInfo);
try
{
result = entity.SaveChanges();
}
catch (Exception ex)
{
}
}
else
{
errormsg = "Question Source Code already exist Selected Question Type.";
}
}
else
{
EPortal.Models.Questionsource usedata = (from o in entity.Questionsources
where o.OrganizationID == orgid &&
o.Id == QuestionSourceInfo.Id
select o
).FirstOrDefault();
usedata.SourceCode = QuestionSourceInfo.SourceCode;
usedata.SourceName = QuestionSourceInfo.SourceName;
usedata.ResourceText = sourcetestinfo;
entity.Entry(usedata).State = System.Data.Entity.EntityState.Modified;
try
{
result = entity.SaveChanges();
}
catch (Exception ex)
{
}
}
}
}
//else
//{
// if (QuestionSourceInfo.SourceCode != "" || QuestionSourceInfo.SourceCode != null)
// {
// errormsg = "Please enter SourceCode.";
// }
// if (QuestionSourceInfo.SourceName != "" || QuestionSourceInfo.SourceName != null)
// {
// errormsg = "Please enter Name.";
// }
// if (QuestionSourceInfo.ResourceText != "" || QuestionSourceInfo.ResourceText != null)
// {
// errormsg = "Please enter Question Source Description.";
// }
//}
return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
}
