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