public JsonResult UpdateCourseDetailsMaster(SITSPL_tblCourseStructure cs, int Course, decimal Fees,
int Discount, decimal NetAmount, DateTime ValidFrom, DateTime ValidTo, int StructureId, int DurationId, string DurationName
, int StudentCategoryId, bool IsPublished, Int64?BatchId, int StudentSubCategoryId)
{
try
{
db = new CourseDataContext();
bool result = false;
SITSPL_tblCourseStructure coursestr = db.SITSPL_tblCourseStructures.Where(x => x.CourseId == Course &&
x.StructureId == StructureId && x.IsDeleted == false).FirstOrDefault();
DateTime ValidFromdate = DateTime.Parse(Convert.ToDateTime(ValidFrom).ToShortDateString());
DateTime ValidTodate = DateTime.Parse(Convert.ToDateTime(ValidTo).ToShortDateString());
if (ValidFromdate > ValidTodate)
{
return(Json("ValidTo"));
}
else if (coursestr != null)
{
coursestr.CourseId = Course;
coursestr.Fees = Fees;
coursestr.DiscountPercent = Discount;
coursestr.NetAmount = NetAmount;
coursestr.ValidFrom = ValidFrom;
coursestr.ValidTo = ValidTo;
coursestr.DurationId = DurationId;
coursestr.StdCatgId = StudentCategoryId;
coursestr.StudentSubCategoryId = StudentSubCategoryId;
coursestr.BatchId = BatchId;
if (IsPublished)
{
if (!coursestr.IsPublished)
{
coursestr.DatePublished = DateTime.Now;
coursestr.PublishedBy = "Admin";
}
}
coursestr.IsPublished = IsPublished;
coursestr.LastUpdated = DateTime.Now;
coursestr.UpdatedBy = "Admin";
db.SubmitChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
result = false;
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddCourseStructure(SITSPL_tblCourseStructure courseStructure)
{
try
{
bool result = false;
db = new CourseDataContext();
courseStructure.DateCreated = DateTime.Now;
if (courseStructure.IsPublished == true)
{
courseStructure.DatePublished = DateTime.Now;
}
courseStructure.CreatedBy = "Admin";
db.SITSPL_tblCourseStructures.InsertOnSubmit(courseStructure);
db.SubmitChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
