public static bool insertUserType(tblUserType userType, bool isInsert) { bool status = false; if (userType != null) { SampleDatabaseDataContext dc = new SampleDatabaseDataContext(); if (isInsert) { //Case of Inserting a new UserType dc.tblUserTypes.InsertOnSubmit(userType); } else { //Case of Updating a new UserType tblUserType dbUserType = dc.tblUserTypes.Where(x => x.UserTypeID == userType.UserTypeID).SingleOrDefault(); dbUserType.Name = userType.Name; } dc.SubmitChanges(); status = true; } return(status); }
/// <summary> /// Insert UserType Information /// </summary> /// <param name="data">UserType Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> UserType(tblUserType data) { erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { int propertyFind = db.tblUserType.Count(); if (propertyFind > 0) { data.id = db.tblUserType.Max(s => s.id); } else { data.id = 1; } db.tblUserType.Add(data); result = db.SaveChanges(); Message = "Affected Row: " + result.ToString(); return(new Tuple <ErrorObject, string>(erros.IfError(false), Message)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, string>(erros, String.Empty)); } }
/// <summary> /// Return Affected Row Or Error If Exist /// </summary> /// <param name="request">CellarArea Information</param> /// <returns>Affected Row Or Error If Exist</returns> public static GetUserTypeResponse UserType(GetUserTypeResponse request) { GetUserTypeResponse response = new GetUserTypeResponse(); try { tblUserType UserType = new tblUserType() { id = request.UserType.id, name = request.UserType.name, detail = request.UserType.detail, createDate = request.UserType.createDate, upDateDate = DateTime.Now, deleteDate = null, state = "Active" }; var result = UserTypeData.Update.UserType(UserType); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2; } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
static void Main(string[] args) { tblUserType utype = new tblUserType(); utype.UserTypeId = 6; utype.UserType = "kushan"; UnitOfWork unitOfWork = new UnitOfWork(); IRepository <tblUserType> repository = unitOfWork.GetRepository <tblUserType>(); repository.Insert(utype); unitOfWork.SaveChanges(); }
protected void userTypeList_SelectedIndexChanged(object sender, EventArgs e) { btn_save.Text = "Update"; tb_userType.Text = ""; hdn_fieldID.Value = userTypeList.DataKeys[this.userTypeList.SelectedRow.RowIndex].Values[0].ToString(); if (!string.IsNullOrEmpty(hdn_fieldID.Value)) { tblUserType dbobj = UserTypeManager.getUserTypeById(new Guid(hdn_fieldID.Value)); if (dbobj != null) { tb_userType.Text = dbobj.Name; } } }
public void DeleteTest() { using (PortfolioEntities dc = new PortfolioEntities()) { Guid userTypeGuid = Guid.Parse("11112222-3333-4444-5555-666677778888"); tblUserType userType = dc.tblUserTypes.FirstOrDefault(u => u.Id == userTypeGuid); dc.tblUserTypes.Remove(userType); dc.SaveChanges(); tblUserType deletedUserType = dc.tblUserTypes.FirstOrDefault(u => u.Id == userTypeGuid); Assert.IsNull(deletedUserType); } }
bool IUserType.Insert(UserTypeViewModel model) { using (var ent = new CustomerSupportEntities()) { var newRow = new tblUserType(); newRow.UserTypeName = model.UserTypeName; newRow.UserTypes.Add(newRow); int success = ent.SaveChanges(); if (success > 0) { return true; } else { return false; } } }
public void UpdateTest() { using (PortfolioEntities dc = new PortfolioEntities()) { //Retrieve test userType based on ID and update it Guid userTypeGuid = Guid.Parse("11112222-3333-4444-5555-666677778888"); tblUserType userType = dc.tblUserTypes.FirstOrDefault(u => u.Id == userTypeGuid); userType.Description = "UpdatedUserType"; //Save changes and get it back out dc.SaveChanges(); tblUserType updatedUserType = dc.tblUserTypes.FirstOrDefault(u => u.Description == "UpdatedUserType"); //Make sure the Ids match Assert.AreEqual(userType.Id, updatedUserType.Id); } }
protected void Page_Load(object sender, EventArgs e) { heading.Text = "Add User Type"; bindData(); lblerrormsg.Text = " "; if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { try { hdn_fieldID.Value = Request.QueryString["id"]; if (!string.IsNullOrEmpty(hdn_fieldID.Value)) { btn_save.Text = "Update"; heading.Text = "Update User Type"; tblUserType dbobj = UserTypeManager.getUserTypeById(new Guid(hdn_fieldID.Value)); if (dbobj != null) { tb_userType.Text = dbobj.Name; } } } catch (Exception ex) { lblerrormsg.Text = ex.Message; } } if (!string.IsNullOrEmpty(Request.QueryString["stat"])) { string message = Request.QueryString["stat"]; if (message == "updateSuccess") { lblerrormsg.Text = "User Type Updated Successfully"; } else if (message == "updateFail") { lblerrormsg.Text = "Could Not Update User Type"; } } } }
public static bool deleteUserType(tblUserType userType) { bool status = false; if (userType != null) { SampleDatabaseDataContext dc = new SampleDatabaseDataContext(); tblUserType dbobj = dc.tblUserTypes.Where(x => x.UserTypeID == userType.UserTypeID).SingleOrDefault(); if (dbobj != null) { dc.tblUserTypes.DeleteOnSubmit(dbobj); dc.SubmitChanges(); status = true; } } return(status); }
protected void userTypeList_RowDeleting(object sender, GridViewDeleteEventArgs e) { //Fetch the Id of the Current userType that is we want to delete try { hdn_fieldID.Value = userTypeList.DataKeys[e.RowIndex].Values[0].ToString(); } catch (Exception ex) { lblerrormsg.Text = ex.Message; } /* * //Validate if such Category is being used by any od the users or not! * //Fetch all userTypes being selected * //Later to be changed to Guid * foreach (UserDetail user in UserManager.GetAllUsers()) { * try * { * if (hdn_fieldID.Value == user.UserType) { * lblerrormsg.Text = "Cannot Delete UserType! The userType is being applied to existing Users!!"; * return; * } * } * catch (Exception ex) { * lblerrormsg.Text = ex.Message; * } * }*/ if (!string.IsNullOrEmpty(hdn_fieldID.Value)) { tblUserType dbUserType = UserTypeManager.getUserTypeById(new Guid(hdn_fieldID.Value)); if (dbUserType != null) { bool statusOfDelete = UserTypeManager.deleteUserType(dbUserType); lblerrormsg.Text = statusOfDelete ? "UserType Deleted Successfully!!" : "Couldnot Delete UserType"; hdn_fieldID.Value = ""; bindData(); } } }
public ActionResult SaveUser(string UserType) { var data = db.tblUserType.Where(x => x.Name == UserType).Count(); if (data > 0) { TempData["Msg"] = "" + UserType + "" + " " + " Is already exists. "; } else { tblUserType type = new tblUserType(); type.Name = UserType; type.Status = false; db.tblUserType.Add(type); db.SaveChanges(); ModelState.Clear(); TempData["Msg"] = "Saved Successfully"; } return(RedirectToAction("RoleSettings")); }
public void LoadById(Guid id) { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblUserType userType = dc.tblUserTypes.Where(ut => ut.Id == id).FirstOrDefault(); if (userType != null) { Id = userType.Id; Description = userType.Description; } else { throw new Exception("User Type not found"); } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Update User Type Information /// </summary> /// <param name="data">UserType Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> UserType(tblUserType data) { erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { db.Entry(data).State = EntityState.Modified; result = db.SaveChanges(); Message = "Affected Row: " + result.ToString(); return(new Tuple <ErrorObject, string>(erros.IfError(false), Message)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, string>(erros, String.Empty)); } }
public int Update() { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblUserType userType = dc.tblUserTypes.Where(ut => ut.Id == Id).FirstOrDefault(); if (userType != null) { userType.Description = Description; return(dc.SaveChanges()); } else { throw new Exception("User Type not found"); } } } catch (Exception ex) { throw ex; } }
public int Insert() { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblUserType userType = new tblUserType() { Id = Guid.NewGuid(), Description = Description }; //Save the Id this.Id = userType.Id; dc.tblUserTypes.Add(userType); return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public void InsertTest() { using (PortfolioEntities dc = new PortfolioEntities()) { //Create a userType tblUserType userType = new tblUserType { //UserType a GUID for testing purposes Id = Guid.Parse("11112222-3333-4444-5555-666677778888"), Description = "Test" }; //Add the userType to the database dc.tblUserTypes.Add(userType); //Commit changes int rowsInserted = dc.SaveChanges(); Assert.IsTrue(rowsInserted == 1); } }
/// <summary> /// Return UserType By Specific ID /// </summary> /// <param name="id">UserType ID</param> /// <returns>UserType By Specific ID Or null If Exist Error</returns> public static Tuple <ErrorObject, tblUserType> GetUserType(int id) { tblUserType UserType = new tblUserType(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { UserType = db.tblUserType.Find(id); } erros.Error = false; return(new Tuple <ErrorObject, tblUserType>(erros.IfError(false), UserType)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblUserType>(erros, UserType)); } }
/// <summary> /// Update User Type Information /// </summary> /// <param name="data">UserType Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> UserType(tblUserType data) { erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { var row = db.tblUserType.Single(p => p.id == data.id); row.name = data.name; row.detail = data.detail; row.upDateDate = data.upDateDate; result = db.SaveChanges(); Message = "Affected Row: " + result.ToString(); return(new Tuple <ErrorObject, string>(erros.IfError(false), Message)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, string>(erros, String.Empty)); } }
/// <summary> /// There are no comments for tblUserType in the schema. /// </summary> public void AddTotblUserType(tblUserType tblUserType) { base.AddObject("tblUserType", tblUserType); }
protected void btn_save_Click(object sender, EventArgs e) { //Check if Empty or not if (string.IsNullOrEmpty(tb_userType.Text)) { lblerrormsg.Text = "UserType Column Cannot be Empty!!"; tb_userType.Focus(); return; } //Check if already Inserted or not foreach (tblUserType UserType in UserTypeManager.getAllUserTypes()) { if (UserType.Name.ToUpper() == tb_userType.Text.ToUpper()) { lblerrormsg.Text = "UserType Duplicate!! Already Inserted!!"; tb_userType.Focus(); tb_userType.Text = ""; return; } } //To Find if it is a case of Insert or Update bool isInsert; //Create an Object of Talbe /class tblUserType tblUserType userType = new tblUserType(); if (string.IsNullOrEmpty(hdn_fieldID.Value)) { //Case of Creating a new user Type userType.UserTypeID = Guid.NewGuid(); isInsert = true; } else { //Case of Updating a user type userType.UserTypeID = new Guid(hdn_fieldID.Value); isInsert = false; } userType.Name = tb_userType.Text; bool status = UserTypeManager.insertUserType(userType, isInsert); //Confirmation of Insert/Edit to the User if (status) { bindData(); if (isInsert) { lblerrormsg.Text = "SuccessFully Inserted New UserType!!"; } else { string stat = "updateSuccess"; Response.Redirect("~/Web/User/UserTypeList.aspx?stat=" + stat); } } else { if (isInsert) { lblerrormsg.Text = "Cannot Insert New UserType"; } else { string stat = "updateFail"; Response.Redirect("~/Web/User/UserTypeList.aspx?stat=" + stat); } } }
/// <summary> /// Create a new tblUserType object. /// </summary> /// <param name="userTypeID">Initial value of UserTypeID.</param> public static tblUserType CreatetblUserType(string userTypeID) { tblUserType tblUserType = new tblUserType(); tblUserType.UserTypeID = userTypeID; return tblUserType; }