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 }); } }