} //end function public CollageAdmin CollageAdminSelectByID(int intUserId) { try { string sp_name = "CollageAdminSelectByID"; comCollageAdmin.Parameters.AddWithValue("UserId", intUserId); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsCollageAdmin.Tables[0].Rows.Count == 1) { DataRow drCollageAdmin = dsCollageAdmin.Tables[0].Rows[0]; CollageAdmin objCollageAdmin = new CollageAdmin(); objCollageAdmin.UserId = Convert.ToInt64(drCollageAdmin["UserId"]); objCollageAdmin.UserName = Convert.ToString(drCollageAdmin["UserName"]); objCollageAdmin.UserPassword = Convert.ToString(drCollageAdmin["UserPassword"]); objCollageAdmin.UserEmail = Convert.ToString(drCollageAdmin["UserEmail"]); objCollageAdmin.UserRole = Convert.ToString(drCollageAdmin["UserRole"]); objCollageAdmin.UserContectNo = Convert.ToString(drCollageAdmin["UserContectNo"]); objCollageAdmin.UserCNIC = Convert.ToString(drCollageAdmin["UserCNIC"]); objCollageAdmin.AddedById = Convert.ToInt32(drCollageAdmin["AddedById"]); objCollageAdmin.AddedByDateTime = Convert.ToDateTime(drCollageAdmin["AddedByDateTime"]); objCollageAdmin.UserIsEnabled = Convert.ToBoolean(drCollageAdmin["UserIsEnabled"]); objCollageAdmin.LastEnableDateTime = Convert.ToDateTime(drCollageAdmin["LastEnableDateTime"]); objCollageAdmin.Remarks = Convert.ToString(drCollageAdmin["Remarks"]); objCollageAdmin.UserPic = Convert.ToString(drCollageAdmin["UserPic"]); return(objCollageAdmin); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
private void btnUserSave_Click(object sender, EventArgs e) { Image admin_pic = picUser.Image; admin_pic.Save("images//admin//" + txtUserCNIC.Text + ".jpg"); if (IsFormValidate()) { CollageAdmin objAdmin = new CollageAdmin(); objAdmin.UserId = Convert.ToInt32(txtUserName.Tag); objAdmin.UserEmail = txtUserEmail.Text; objAdmin.UserName = txtUserName.Text; objAdmin.UserPassword = txtUserPassword.Text; objAdmin.UserRole = cmbUserRole.Text; objAdmin.UserContectNo = txtUserContactNo.Text; objAdmin.UserCNIC = txtUserCNIC.Text; objAdmin.AddedById = Convert.ToInt32(this.Tag); objAdmin.AddedByDateTime = DateTime.Now; objAdmin.UserIsEnabled = true; objAdmin.LastEnableDateTime = DateTime.Now; objAdmin.Remarks = txtUserRemarks.Text; objAdmin.UserPic = "images//admin//" + txtUserCNIC.Text + ".jpg"; long UserId = objAdmin.InsertUpdateCollageAdmin(); if (UserId > 0) { UserDataGridView.DataSource = CollageAdminController.CollageAdminSelectAll(); SuccessMessage.SHowDialog("Record Entered Successfully"); txtUserName.Focus(); } else { ErrorMessage.SHowDialog("Error in Entry"); txtUserName.Focus(); } } }
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { CollageAdminList.Clear(); foreach (DataRow drCollageAdmin in dsCollageAdmin.Tables[0].Rows) { CollageAdmin objCollageAdmin = new CollageAdmin(); objCollageAdmin.UserId = Convert.ToInt64(drCollageAdmin["UserId"]); objCollageAdmin.UserName = Convert.ToString(drCollageAdmin["UserName"]); objCollageAdmin.UserPassword = Convert.ToString(drCollageAdmin["UserPassword"]); objCollageAdmin.UserEmail = Convert.ToString(drCollageAdmin["UserEmail"]); objCollageAdmin.UserRole = Convert.ToString(drCollageAdmin["UserRole"]); objCollageAdmin.UserContectNo = Convert.ToString(drCollageAdmin["UserContectNo"]); objCollageAdmin.UserCNIC = Convert.ToString(drCollageAdmin["UserCNIC"]); objCollageAdmin.AddedById = Convert.ToInt32(drCollageAdmin["AddedById"]); objCollageAdmin.AddedByDateTime = Convert.ToDateTime(drCollageAdmin["AddedByDateTime"]); objCollageAdmin.UserIsEnabled = Convert.ToBoolean(drCollageAdmin["UserIsEnabled"]); objCollageAdmin.LastEnableDateTime = Convert.ToDateTime(drCollageAdmin["LastEnableDateTime"]); objCollageAdmin.Remarks = Convert.ToString(drCollageAdmin["Remarks"]); objCollageAdmin.UserPic = Convert.ToString(drCollageAdmin["UserPic"]); CollageAdminList.Add(objCollageAdmin); } }
public static Int64 InsertUpdateCollageAdmin(CollageAdmin objIUCollageAdmin) { Int64 new_id = objIUCollageAdmin.InsertUpdateCollageAdmin(); return(new_id); }