public object SaveSmsSetting(ParamSmsSetting PS)
{
try
{
tbl_smsconfiguration objTBL = new tbl_smsconfiguration();
objTBL.GATEWAYUSERID = PS.GatewayUserid;
objTBL.GATEWAYPASSWORD = PS.GatewayPassword;
objTBL.SMSSENDAPI = PS.SmsSendApi;
objTBL.CHECKBALANCEAPI = PS.CheckbalanceApi;
objTBL.DISPLAY = 1;
objTBL.created_date = DateTime.Now;
objGR.tbl_smsconfiguration.Add(objTBL);
objGR.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Sms Settings Saved Succesfully!!"
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object SaveEmail(ParamEmailSettings PR)
{
try
{
tbl_emailsettings obj = new tbl_emailsettings();
obj.fromid = PR.fromid;
obj.host = PR.host;
obj.port = PR.port;
obj.password = PR.password;
obj.Display = 1;
obj.created_date = DateTime.Now;
db.tbl_emailsettings.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Email Settings Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SetStatus(SetStatusParameters obj)
{
try
{
tbl_complaintdetails cobj = db.tbl_complaintdetails.First(r => r.CompID == obj.CompId && r.Display == 1);
if (cobj != null)
{
cobj.CompID = obj.CompId;
cobj.GrievanceAction = obj.GrievanceAction;
cobj.status = obj.Status;
cobj.modified_date = DateTime.Now;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Status Updates Successfully.."
});
}
else
{
return(new Error()
{
IsError = true, Message = " Record Not Found"
});
}
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = " Error"
});
}
}
public object UpdateComp(ParamComplaintDetails PR)
{
GRContext db = new GRContext();
try
{
tbl_complaintdetails objuser = db.tbl_complaintdetails.Where(r => r.CompID == PR.CompID).FirstOrDefault();
objuser.GrievanceAction = PR.GrievanceAction;
objuser.status = PR.status;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "User Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object CreateClass([FromBody] ClassParameter obj)
{
if (obj.UserId == null && obj.Password == null)
{
return(new Result {
IsSucess = false, ResultData = "UserId Requird"
});
}
GRContext db = new GRContext();
tbl_class objcls = new tbl_class();
var result = db.tbl_class.FirstOrDefault(r => r.class_name == obj.ClassName && r.course_name == obj.CourseName);
if (result != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowd"
});
}
objcls.class_name = obj.ClassName.ToString();
objcls.course_name = obj.CourseName.ToString();
objcls.Display = 1;
objcls.created_date = DateTime.Now;
db.tbl_class.Add(objcls);
db.SaveChanges();
return(new Result
{
IsSucess = true,
ResultData = "Class Created!"
});
}
public object NewCourse([FromBody] CourseParameter obje)
{
if (obje.UserId == null && obje.Password == null)
{
return(new Result {
IsSucess = false, ResultData = "UserId Required"
});
}
GRContext db = new GRContext();
tbl_courses objcourse = new tbl_courses();
var result = db.tbl_courses.FirstOrDefault(r => r.course_name == obje.CourseName);
if (result != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowed"
});
}
// objcourse.course_id = obje.Course_id;
objcourse.course_name = obje.CourseName.ToString();
objcourse.created_date = DateTime.Now;
objcourse.Display = 1;
db.tbl_courses.Add(objcourse);
db.SaveChanges();
return(new Result
{
IsSucess = true,
ResultData = "Course Created Successfully!"
});
}
public object UpdateUser(ParamRegistration PR)
{
try
{
tbl_user obj = context.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (PR.Password == null)
{
obj.name = PR.Name;
obj.email = PR.Email;
obj.contact = PR.Contact;
//obj.password = PR.Password;
}
else
{
obj.name = PR.Name;
obj.email = PR.Email;
obj.contact = PR.Contact;
obj.password = CryptIt.Encrypt(PR.Password);
}
context.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "User Updated Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object UserLive(StudentParameters obj)
{
try
{
// var status = db.tbl_user.Where(r => r.code == obj.code && r.type == obj.type).OrderByDescending(r => r.code).ToList();
tbl_user uobj = db.tbl_user.First(r => r.code == obj.Code && r.type == obj.Type);
if (uobj.Islive == 0)
{
uobj.Islive = 1;
}
else
{
uobj.Islive = 0;
}
uobj.code = obj.Code;
db.SaveChanges();
return(new Result
{
IsSucess = true,
ResultData = "Status Updated!"
});
}
catch (Exception E)
{
return(new Error()
{
IsError = true, Message = E.Message
});
}
}
public object SaveGrievance(ParamSaveGriveance obj)
{
if (obj.UserId == null)
{
return(new Result {
IsSucess = false, ResultData = "Invalid User."
});
}
int grievancetypeid = Convert.ToInt32(obj.GriveanceType);
var grievancetypelist = objcontext.tbl_grievance_list.Where(r => r.grivance_id == grievancetypeid).First();
tbl_postgriev objpost = new tbl_postgriev();
if (obj.Code == null)
{
return(new Result {
IsSucess = false, ResultData = "Invalid User."
});
}
else
{
objpost.code = obj.Code;
objpost.email = obj.Email;
objpost.grivtype = grievancetypelist.grivance_name;
objpost.subject = obj.Subject;
objpost.post = obj.PostDetails;
objpost.userid = obj.UserId;
objpost.status = "Pending";
objpost.Display = 1;
objpost.created_date = DateTime.Now;
objcontext.tbl_postgriev.Add(objpost);
//objcontext.SaveChanges();
tbl_complaintdetails comp = new tbl_complaintdetails();
comp.GrievanceType = grievancetypelist.grivance_name;
comp.Date = DateTime.Now.Date;
comp.Subject = objpost.subject;
comp.Post = objpost.post;
comp.status = objpost.status;
comp.GrievanceAction = "Pending";
comp.GrievMemID = grievancetypeid;
comp.StackHolderType = obj.Type;
comp.StackholderID = Convert.ToString(objpost.code);
comp.UserId = obj.UserId;
comp.Display = 1;
comp.created_date = DateTime.Now;
objcontext.tbl_complaintdetails.Add(comp);
objcontext.SaveChanges();
return(new Result {
IsSucess = true, ResultData = "Griveance Posted Sucessfully."
});
}
}
public object DeleteMember(MemberParameter PR)
{
GRContext db = new GRContext();
try
{
tbl_member objmember = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (objmember.Display == 1)
{
objmember.Display = 0;
}
else
{
objmember.Display = 1;
}
db.SaveChanges();
tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (objuser.Display == 1)
{
objuser.Display = 0;
}
else
{
objuser.Display = 1;
}
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Member Updated Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object GrievanceSave(GrievanceParam PR)
{
try
{
//var usercode = db.tbl_user.Where(r => r.code == PR.Code).FirstOrDefault();
if (PR.GrievanceName == null)
{
return(new Error()
{
IsError = true, Message = "Required Grievance Name"
});
}
tbl_grievance_list objuser = new tbl_grievance_list();
var result = db.tbl_grievance_list.Where(r => r.grivance_name == PR.GrievanceName);
if (result != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowd"
});
}
objuser.grivance_name = PR.GrievanceName;
objuser.grivance_description = PR.GrievanceDescription;
objuser.Display = 1;
objuser.created_date = DateTime.Now;
objuser.Isalloted = 0;
db.tbl_grievance_list.Add(objuser);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "User Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object UpdateMemberDetail(MemberParameter PR)
{
GRContext db = new GRContext();
try
{
tbl_member objmember = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault();
objmember.griType = PR.GriType;
objmember.designation = PR.Designation;
objmember.modified_date = DateTime.Now;
if (PR.GriType != null)
{
objmember.griType = PR.GriType;
tbl_grievance_list list = db.tbl_grievance_list.Where(r => r.grivance_name == objmember.griType).FirstOrDefault();
list.Isalloted = 1;
db.SaveChanges();
}
db.SaveChanges();
tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
objuser.name = PR.Name;
objuser.gender = PR.Gender;
objuser.email = PR.EmailId;
objuser.contact = PR.MobileNo;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Member Updated Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SetIsLiveStatusMember(ParamMember PM)
{
try
{
tbl_user objTBLUSER = gc.tbl_user.Where(r => r.UserId == PM.UserId && r.type == "Member" && r.Display == 1).FirstOrDefault();
if (objTBLUSER == null)
{
return(new Error()
{
IsError = true, Message = "Incorrect Code !"
});
}
else
{
if (objTBLUSER.Islive == 1)
{
objTBLUSER.Islive = 0;
}
else
{
objTBLUSER.Islive = 1;
}
//objTBLUSER.code = PM.Code;
gc.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Status Updated Sucessfully!"
});
}
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object SaveMember([FromBody] MemberParameter obj)
{
GRContext db = new GRContext();
var usercode = db.tbl_member.Where(r => r.code == obj.Code).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "User Code Already Exists."
});
}
tbl_user objuser = new tbl_user();
objuser.name = obj.Name.ToString();
objuser.UserId = Convert.ToInt32(obj.UserId);
objuser.code = obj.Code;
objuser.type = "Member";
objuser.gender = obj.Gender.ToString();
objuser.email = obj.EmailId.ToString();
objuser.contact = Convert.ToInt64(obj.MobileNo);
objuser.password = CryptIt.Encrypt(obj.Password);
objuser.status = 1;
objuser.Islive = 0;
objuser.Display = 1;
objuser.created_date = DateTime.Now;
db.tbl_user.Add(objuser);
try
{
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
tbl_member objmember = new tbl_member();
tbl_user omember = db.tbl_user.Where(r => r.code == obj.Code).FirstOrDefault();
objmember.UserId = omember.UserId;
objmember.code = Convert.ToInt32(obj.Code);
objmember.designation = obj.Designation.ToString();
if (obj.GriType != null)
{
objmember.griType = obj.GriType.ToString();
}
objmember.Display = 1;
objmember.created_date = DateTime.Now;
db.tbl_member.Add(objmember);
db.SaveChanges();
if (obj.GriType != null)
{
tbl_grievance_list list = db.tbl_grievance_list.Where(r => r.grivance_name == objmember.griType).FirstOrDefault();
list.Isalloted = 1;
db.SaveChanges();
}
return(new Result
{
IsSucess = true,
ResultData = "Member Created!"
});
}
public object SaveRegistration(ParamRegistration PR)
{
try
{
var usercode = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "User Code Already Exists."
});
}
tbl_user objuser = new tbl_user();
objuser.name = PR.Name;
objuser.UserId = PR.UserId;
objuser.type = PR.Type;
objuser.gender = PR.Gender;
objuser.code = PR.code;
objuser.email = PR.Email;
objuser.contact = PR.Contact;
string EncryptedPassword = CryptIt.Encrypt(PR.Password);
objuser.password = EncryptedPassword;
objuser.status = 1;
objuser.Islive = 1;
objuser.Display = 1;
objuser.created_date = DateTime.Now;
db.tbl_user.Add(objuser);
db.SaveChanges();
if (PR.Type == "Student")
{
tbl_student objstudent = new tbl_student();
objstudent.UserId = PR.UserId;
tbl_user obstudent = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objstudent.UserId = obstudent.UserId;
objstudent.code = PR.code;
objstudent.course_name = PR.CourseName;
objstudent.class_name = PR.ClassName;
objstudent.IsParent = 0;
objstudent.Display = 1;
objstudent.created_date = DateTime.Now;
db.tbl_student.Add(objstudent);
db.SaveChanges();
}
else if (PR.Type == "Faculty")
{
tbl_faculty objfaculty = new tbl_faculty();
objfaculty.UserId = PR.UserId;
tbl_user obfaculty = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objfaculty.UserId = obfaculty.UserId;
objfaculty.code = PR.code;
objfaculty.department = PR.CourseName;
objfaculty.designation = PR.Designation;
objfaculty.Display = 1;
objfaculty.created_date = DateTime.Now;
db.tbl_faculty.Add(objfaculty);
db.SaveChanges();
}
else if (PR.Type == "Parent")
{
tbl_parent objparent = new tbl_parent();
objparent.UserId = PR.UserId;
objparent.relationship = PR.Relationship;
tbl_user obstudent = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objparent.UserId = obstudent.UserId;
objparent.code = PR.code;
objparent.Display = 1;
objparent.created_date = DateTime.Now;
db.tbl_parent.Add(objparent);
db.SaveChanges();
//tbl_student objstudent = db.tbl_student.Where(r => r.UserId == PR.UserId).FirstOrDefault();
//objstudent.IsParent = 1;
//db.SaveChanges();
}
else if (PR.Type == "Staff")
{
tbl_staff objstaff = new tbl_staff();
objstaff.UserId = objuser.UserId;
tbl_user obstaff = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objstaff.UserId = objstaff.UserId;
objstaff.code = PR.code;
objstaff.department = PR.CourseName;
objstaff.designation = PR.Designation;
objstaff.Display = 1;
objstaff.created_date = DateTime.Now;
db.tbl_staff.Add(objstaff);
db.SaveChanges();
}
else
{
return(new Error()
{
IsError = true, Message = "User Type Not Matched."
});
}
return(new Result()
{
IsSucess = true, ResultData = "User Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}