public bool updateMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO) { try { if (con.State == ConnectionState.Closed) { con.Open(); } query = "updateMpDetails"; cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@guId", userMasterBO.guid); cmd.Parameters.AddWithValue("@email", userMasterBO.email); cmd.Parameters.AddWithValue("@password", userMasterBO.password); cmd.Parameters.AddWithValue("@firstName", userMasterBO.firstName); cmd.Parameters.AddWithValue("@middleName", userMasterBO.middleName); cmd.Parameters.AddWithValue("@lastName", userMasterBO.lastName); cmd.Parameters.AddWithValue("@socialNetwork", userMasterBO.socialNetwork); cmd.Parameters.AddWithValue("@snTypeId", userMasterBO.snTypeId); cmd.Parameters.AddWithValue("@status", userMasterBO.status); cmd.Parameters.AddWithValue("@profilepic", userMasterBO.profilePicPath); // now the part of mpdetails table cmd.Parameters.AddWithValue("@mpId", mpDetailsBO.mpId); cmd.Parameters.AddWithValue("@countryId", mpDetailsBO.countryId); cmd.Parameters.AddWithValue("@constituencyId", mpDetailsBO.constituencyId); cmd.Parameters.AddWithValue("@electedYear", mpDetailsBO.electedYear); cmd.Parameters.AddWithValue("@partyId", mpDetailsBO.partyId); cmd.Parameters.AddWithValue("@phone", mpDetailsBO.phone); cmd.Parameters.AddWithValue("@mobile", mpDetailsBO.mobile); cmd.Parameters.AddWithValue("@qualification", mpDetailsBO.qualification); cmd.Parameters.AddWithValue("@professioin", mpDetailsBO.profession); cmd.Parameters.AddWithValue("@permanentAddress", mpDetailsBO.permenantAddress); cmd.Parameters.AddWithValue("@permanentDistrictId", mpDetailsBO.permanentDistrict); cmd.Parameters.AddWithValue("@permanentStateId", mpDetailsBO.permanentState); cmd.Parameters.AddWithValue("@currentAddress", mpDetailsBO.currentAddress); cmd.Parameters.AddWithValue("@currentDistrictId", mpDetailsBO.currentDistrictId); cmd.Parameters.AddWithValue("@currentStateId", mpDetailsBO.currentStateId); SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.Bit); message.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); return(bool.Parse(message.Value.ToString())); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public string registerMp(mpDetailsBO MpDetailsBO,userMasterBO UserMasterBO) { try { return MpDetailsDAL.registerMp(MpDetailsBO, UserMasterBO); } catch { throw; } finally { } }
public bool saveMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO) { try { return(mpDetailsDAL.saveMpDetails(userMasterBO, mpDetailsBO)); } catch { throw; } finally { } }
public string registerMp(mpDetailsBO MpDetailsBO,userMasterBO UserMasterBO) { try { cmd = new SqlCommand("regMp", care); cmd.CommandType = CommandType.StoredProcedure; if (care.State == ConnectionState.Closed) { care.Open(); } cmd.Parameters.AddWithValue("@email", UserMasterBO.email); cmd.Parameters.AddWithValue("@pasword",UserMasterBO.password); cmd.Parameters.AddWithValue("@roleId",UserMasterBO.roleId); cmd.Parameters.AddWithValue("@firstName",UserMasterBO.firstName); cmd.Parameters.AddWithValue("@middleName",UserMasterBO.middleName); cmd.Parameters.AddWithValue("@lastName",UserMasterBO.lastName); cmd.Parameters.AddWithValue("@socialNetwork",UserMasterBO.socialNetwork); cmd.Parameters.AddWithValue("@sntypeId",UserMasterBO.snTypeId); cmd.Parameters.AddWithValue("@status",UserMasterBO.status); cmd.Parameters.AddWithValue("@passcode",UserMasterBO.passcode); cmd.Parameters.AddWithValue("@profilePic",UserMasterBO.profilePic); cmd.Parameters.AddWithValue("@countryId", MpDetailsBO.countryId); cmd.Parameters.AddWithValue("@constituencyId", MpDetailsBO.constituencyId); cmd.Parameters.AddWithValue("@electedYear", MpDetailsBO.electedYear); cmd.Parameters.AddWithValue("@partyId", MpDetailsBO.partyId); cmd.Parameters.AddWithValue("@phone", MpDetailsBO.phone); cmd.Parameters.AddWithValue("@mobile", MpDetailsBO.mobile); cmd.Parameters.AddWithValue("@qualification", MpDetailsBO.qualification); cmd.Parameters.AddWithValue("@profession", MpDetailsBO.profession); cmd.Parameters.AddWithValue("@permenantAddr", MpDetailsBO.permenantAddress); cmd.Parameters.AddWithValue("@permenantDistId", MpDetailsBO.permenantDist); cmd.Parameters.AddWithValue("@permenantStateId", MpDetailsBO.permanentState); cmd.Parameters.AddWithValue("@CurrentAddr", MpDetailsBO.currentAddress); cmd.Parameters.AddWithValue("@currentDistId", MpDetailsBO.currentDistrictId); cmd.Parameters.AddWithValue("@currentStateId", MpDetailsBO.currentStateId); cmd.ExecuteNonQuery(); return "done"; } catch { throw; } finally { care.Close(); } }
public bool updateMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO) { try { return mpDetailsDAL.updateMpDetails(userMasterBO, mpDetailsBO); } catch { throw; } finally { } }
public bool updateMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO) { try { if (con.State == ConnectionState.Closed) { con.Open(); } query = "updateMpDetails"; cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@guId", userMasterBO.guid); cmd.Parameters.AddWithValue("@email", userMasterBO.email); cmd.Parameters.AddWithValue("@password", userMasterBO.password); cmd.Parameters.AddWithValue("@firstName", userMasterBO.firstName); cmd.Parameters.AddWithValue("@middleName", userMasterBO.middleName); cmd.Parameters.AddWithValue("@lastName", userMasterBO.lastName); cmd.Parameters.AddWithValue("@socialNetwork", userMasterBO.socialNetwork); cmd.Parameters.AddWithValue("@snTypeId", userMasterBO.snTypeId); cmd.Parameters.AddWithValue("@status", userMasterBO.status); cmd.Parameters.AddWithValue("@profilepic", userMasterBO.profilePicPath); // now the part of mpdetails table cmd.Parameters.AddWithValue("@mpId", mpDetailsBO.mpId); cmd.Parameters.AddWithValue("@countryId", mpDetailsBO.countryId); cmd.Parameters.AddWithValue("@constituencyId", mpDetailsBO.constituencyId); cmd.Parameters.AddWithValue("@electedYear", mpDetailsBO.electedYear); cmd.Parameters.AddWithValue("@partyId", mpDetailsBO.partyId); cmd.Parameters.AddWithValue("@phone", mpDetailsBO.phone); cmd.Parameters.AddWithValue("@mobile", mpDetailsBO.mobile); cmd.Parameters.AddWithValue("@qualification", mpDetailsBO.qualification); cmd.Parameters.AddWithValue("@professioin", mpDetailsBO.profession); cmd.Parameters.AddWithValue("@permanentAddress", mpDetailsBO.permenantAddress); cmd.Parameters.AddWithValue("@permanentDistrictId", mpDetailsBO.permanentDistrict); cmd.Parameters.AddWithValue("@permanentStateId", mpDetailsBO.permanentState); cmd.Parameters.AddWithValue("@currentAddress", mpDetailsBO.currentAddress); cmd.Parameters.AddWithValue("@currentDistrictId", mpDetailsBO.currentDistrictId); cmd.Parameters.AddWithValue("@currentStateId", mpDetailsBO.currentStateId); SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.Bit); message.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); return (bool.Parse(message.Value.ToString())); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }