public ActionResult staffUpdate(Staff staff, Address address, AdditionalContactInfoModel aci) { bool success; StaffDataController dataController = new StaffDataController(); staff.deleted = true; success = dataController.InsertStaff(staff, address, aci); return(Content(success.ToString())); }
/********************************************************** UPDATE METHODS ***********************************************************/ //update Staff Member public bool staffUpdate(Staff thisStaff, Address staffAddress, AdditionalContactInfoModel staffContact) { try { //Update Staff DbCommand upd_Staff = db.GetStoredProcCommand("upd_Staff"); // db.AddInParameter(dbCommand, "@parameterName", DbType.TypeName, variableName); db.AddInParameter(upd_Staff, "@staffID", DbType.String, thisStaff.staffID); db.AddInParameter(upd_Staff, "@firstName", DbType.String, thisStaff.firstName); db.AddInParameter(upd_Staff, "@lastName", DbType.String, thisStaff.lastName); db.AddInParameter(upd_Staff, "@handicapped", DbType.Boolean, 0); db.AddInParameter(upd_Staff, "@staffAltID", DbType.String, thisStaff.staffAltID); db.AddInParameter(upd_Staff, "@deleted", DbType.Boolean, thisStaff.deleted); db.AddInParameter(upd_Staff, "@staffSSN", DbType.Int32, thisStaff.SSN); db.ExecuteNonQuery(upd_Staff); //update Staff's Addresses DbCommand upd_Addresses = db.GetStoredProcCommand("upd_Addresses"); db.AddInParameter(upd_Addresses, "@memberID", DbType.Int32, thisStaff.staffID); db.AddInParameter(upd_Addresses, "@memberTypeID", DbType.Int32, thisStaff.memberTypeID); db.AddInParameter(upd_Addresses, "@addressesID", DbType.Int32, staffAddress.addressesID); db.AddInParameter(upd_Addresses, "@addressTypeID", DbType.Int32, staffAddress.addressesType); db.AddInParameter(upd_Addresses, "@address1", DbType.String, staffAddress.address1); db.AddInParameter(upd_Addresses, "@address2", DbType.String, staffAddress.address2); db.AddInParameter(upd_Addresses, "@city", DbType.String, staffAddress.city); db.AddInParameter(upd_Addresses, "@st", DbType.String, staffAddress.state); db.AddInParameter(upd_Addresses, "@zip", DbType.Int32, staffAddress.zip); db.AddInParameter(upd_Addresses, "@county", DbType.String, ""); db.AddInParameter(upd_Addresses, "@deleted", DbType.Boolean, staffAddress.deleted); db.ExecuteNonQuery(upd_Addresses); //update Staff's Additional Contact Info DbCommand upd_AdditionalContactInfo = db.GetStoredProcCommand("upd_AdditionalContactInfo"); db.AddInParameter(upd_AdditionalContactInfo, "@additionalContactInfoID", DbType.Int32, staffContact.additionalContactInfoID); db.AddInParameter(upd_AdditionalContactInfo, "@additionalContactInfo", DbType.String, staffContact.additionalContactInfo); db.AddInParameter(upd_AdditionalContactInfo, "@additionalContactInfoTypeID", DbType.Int32, staffContact.additionalContactInfoTypeID); db.AddInParameter(upd_AdditionalContactInfo, "@deleted", DbType.Boolean, staffContact.deleted); db.ExecuteNonQuery(upd_AdditionalContactInfo); return(true); } catch { return(false); } }
//gets contact info by a dataset public AdditionalContactInfoModel GetAddContactInfoByDataSet(DataSet ds) { //datasets passed through only have one row so we access that row DataRow dr = ds.Tables[0].Rows[0]; //then assign values from that row to a new Address model AdditionalContactInfoModel thisAddContactInfo = new AdditionalContactInfoModel() { additionalContactInfo = dr.Field <string>("additionalContactInfo") }; return(thisAddContactInfo); }
public AdditionalContactInfoModel UpdateAdditionalContactInformation(AdditionalContactInfoModel additionalContactInfo, int memberID, int memberTypeID) { DbCommand upd_AdditionalContactInfo = db.GetStoredProcCommand("upd_AdditionalContactInformation"); db.AddInParameter(upd_AdditionalContactInfo, "@additionalContactInfoID", DbType.Int32, additionalContactInfo.additionalContactInfoID); db.AddInParameter(upd_AdditionalContactInfo, "@additionalContactInfo", DbType.String, additionalContactInfo.additionalContactInfo); db.AddOutParameter(upd_AdditionalContactInfo, "@success", DbType.Boolean, 1); try { db.ExecuteNonQuery(upd_AdditionalContactInfo); } catch (Exception e) { Debug.WriteLine("UpdateAdditionalContactInfo failed, exception: {0}", e); } return(additionalContactInfo); }
public bool DeleteAdditionalContactInformation(AdditionalContactInfoModel additionalContactInfo) { DbCommand del_AdditionalContactInfo = db.GetStoredProcCommand("del_AdditionalContactInformation"); db.AddInParameter(del_AdditionalContactInfo, "@additionalContactInfoID", DbType.Int32, additionalContactInfo.additionalContactInfoID); db.AddOutParameter(del_AdditionalContactInfo, "@success", DbType.Boolean, 1); bool success; try { db.ExecuteNonQuery(del_AdditionalContactInfo); success = Convert.ToBoolean(db.GetParameterValue(del_AdditionalContactInfo, "@success")); } catch (Exception e) { Debug.WriteLine("DeleteAdditionalContactInfo failed, exception: {0}", e); success = false; } return(success); }
public AdditionalContactInfoModel InsertAdditionalContactInformation(AdditionalContactInfoModel additionalContactInfo, int memberID, int memberTypeID) { DbCommand ins_AdditionalContactInformation = db.GetStoredProcCommand("ins_AdditionalContactInformation"); db.AddInParameter(ins_AdditionalContactInformation, "@memberID", DbType.Int32, memberID); db.AddInParameter(ins_AdditionalContactInformation, "@memberTypeID", DbType.Int32, memberTypeID); db.AddInParameter(ins_AdditionalContactInformation, "@additionalContactInfoTypeID", DbType.Int32, additionalContactInfo.additionalContactInfoTypeID); db.AddInParameter(ins_AdditionalContactInformation, "@additionalContactInfo", DbType.String, additionalContactInfo.additionalContactInfo); db.AddOutParameter(ins_AdditionalContactInformation, "@additionalContactInfoID", DbType.Int32, sizeof(int)); try { db.ExecuteNonQuery(ins_AdditionalContactInformation); additionalContactInfo.additionalContactInfoID = Convert.ToInt32(db.GetParameterValue(ins_AdditionalContactInformation, "@additionalContactInfoID")); } catch (Exception e) { Debug.WriteLine("InsertContactInformation failed, exception: {0}", e); } return(additionalContactInfo); }
/*********************************************************** INSERT METHODS *******************************************************/ public bool InsertStaff(Staff thisStaff, Address thisAddress, AdditionalContactInfoModel staffContact) { try { int addressID; string staffAltID; int staffID; string shortFirst; string shortLast; shortFirst = StringTool.Truncate(thisStaff.firstName, 4); shortLast = StringTool.Truncate(thisStaff.lastName, 4); //insert Staff's Addresses DbCommand ins_Addresses = db.GetStoredProcCommand("ins_Addresses"); db.AddInParameter(ins_Addresses, "@memberID", DbType.Int32, thisStaff.staffID); db.AddInParameter(ins_Addresses, "@memberTypeID", DbType.Int32, thisStaff.memberTypeID); db.AddInParameter(ins_Addresses, "@addressTypeID", DbType.Int32, thisAddress.addressTypeID); db.AddInParameter(ins_Addresses, "@address1", DbType.String, thisAddress.address1); db.AddInParameter(ins_Addresses, "@address2", DbType.String, thisAddress.address2); db.AddInParameter(ins_Addresses, "@city", DbType.String, thisAddress.city); db.AddInParameter(ins_Addresses, "@st", DbType.String, thisAddress.state); db.AddInParameter(ins_Addresses, "@zip", DbType.Int32, thisAddress.zip); db.AddInParameter(ins_Addresses, "@county", DbType.String, ""); db.AddInParameter(ins_Addresses, "@deleted", DbType.Boolean, false); db.AddOutParameter(ins_Addresses, "@addressID", DbType.Int32, sizeof(Int32)); db.ExecuteScalar(ins_Addresses); addressID = (int)db.GetParameterValue(ins_Addresses, "@addressID"); //Inserts staff DbCommand ins_Staff = db.GetStoredProcCommand("ins_StaffMember"); db.AddInParameter(ins_Staff, "@staffTypeID", DbType.Int32, thisStaff.staffTypeID); db.AddInParameter(ins_Staff, "@addressesID", DbType.Int32, Convert.ToInt32(addressID)); db.AddInParameter(ins_Staff, "@memberTypeID", DbType.Int32, thisStaff.memberTypeID); db.AddInParameter(ins_Staff, "@firstName", DbType.String, thisStaff.firstName); db.AddInParameter(ins_Staff, "@lastName", DbType.String, thisStaff.lastName); db.AddInParameter(ins_Staff, "@handicapped", DbType.Boolean, thisStaff.handicapped); db.AddInParameter(ins_Staff, "@staffAltID", DbType.String, thisStaff.staffAltID); db.AddInParameter(ins_Staff, "@deleted", DbType.Boolean, thisStaff.deleted); db.AddInParameter(ins_Staff, "@ssn", DbType.String, thisStaff.SSN); db.AddInParameter(ins_Staff, "@dob", DbType.Date, thisStaff.DOB); db.AddInParameter(ins_Staff, "@staffStatus", DbType.Int32, thisStaff.status); db.AddOutParameter(ins_Staff, "@staffID", DbType.Int32, sizeof(int)); db.ExecuteScalar(ins_Staff); staffID = (int)db.GetParameterValue(ins_Staff, "@staffID"); //insert Staff's Additional Contact Info DbCommand ins_AdditionalContactInfo = db.GetStoredProcCommand("ins_AdditionalContactInfo"); db.AddInParameter(ins_AdditionalContactInfo, "@memberTypeID", DbType.Int32, thisStaff.memberTypeID); db.AddInParameter(ins_AdditionalContactInfo, "@additionalContactInfo", DbType.String, staffContact.additionalContactInfo); db.AddInParameter(ins_AdditionalContactInfo, "@additionalContactInfoTypeID", DbType.Int32, staffContact.additionalContactInfoTypeID); db.AddInParameter(ins_AdditionalContactInfo, "@deleted", DbType.Boolean, false); db.AddInParameter(ins_AdditionalContactInfo, "@memberID", DbType.Int32, staffID); db.ExecuteNonQuery(ins_AdditionalContactInfo); //enters Staff Alt ID into table staffAltID = shortFirst + shortLast + thisStaff.staffID.ToString(); DbCommand upd_StaffAltID = db.GetStoredProcCommand("upd_StaffAltID"); db.AddInParameter(upd_StaffAltID, "@staffID", DbType.Int32, staffID); db.AddInParameter(upd_StaffAltID, "@staffAltID", DbType.String, staffAltID); db.ExecuteNonQuery(upd_StaffAltID); return(true); } catch { return(false); } }
public Staff GetStaffMember(int staffID) { DbCommand dbCommand = db.GetStoredProcCommand("get_StaffByID"); db.AddInParameter(dbCommand, "staffID", DbType.Int32, staffID); // db.AddInParameter(dbCommand, "@parameterName", DbType.TypeName, variableName); DataSet ds = db.ExecuteDataSet(dbCommand); DataRow dr = ds.Tables[0].Rows[0]; Staff currentStaff = new Staff() { staffID = dr.Field <int>("staffID"), staffTypeID = dr.Field <int>("staffTypeID"), staffType = dr.Field <string>("staffType"), addressesID = dr.Field <int>("addressesID"), memberTypeID = dr.Field <int>("memberTypeID"), firstName = dr.Field <string>("firstName"), lastName = dr.Field <string>("lastName"), handicapped = dr.Field <bool>("handicapped"), fullName = dr.Field <string>("firstName") + " " + dr.Field <string>("lastName"), staffAltID = dr.Field <string>("staffAltID"), sexID = dr.Field <int>("sexID"), deleted = dr.Field <bool>("deleted"), SSN = dr.Field <int>("ssn"), DOB = dr.IsNull("dob") ? new DateTime(1900, 1, 1) : dr.Field <DateTime>("dob"), }; Address thisAddress = new Address() { addressesID = dr.Field <int>("addressesID"), addressTypeID = dr.Field <int>("addressesTypeID"), address1 = dr.Field <string>("address1"), address2 = dr.Field <string>("address2"), city = dr.Field <string>("city"), state = dr.Field <string>("st"), zip = dr.Field <int>("zip"), mapsco = dr.Field <string>("mapsco"), addressesType = dr.Field <string>("addressesType") }; AdditionalContactInfoModel thisContact = new AdditionalContactInfoModel() { additionalContactInfoID = dr.Field <int>("additionalContactInfoID"), additionalContactInfo = dr.Field <string>("additionalContactInfo"), additionalContactInfoTypeID = dr.Field <int>("additionalContactInfoTypeID"), additionalContactInfoType = dr.Field <string>("additionalContactInfoType"), }; //var timeHeaderList = (from drRow in ds.Tables[0].AsEnumerable() // select new TimeHeaderModel() // { // weekEnding = drRow.Field<string>("weekEnding") // }).ToList(); currentStaff.staffAddress = thisAddress; currentStaff.staffContact = thisContact; //Addresses addr = new Addresses(); //currentStaff.staffAddress = addr.GetAddressByDataSet(ds); return(currentStaff); }