public PresentAddress GetPresentAddress(int n1userId)
{
conn = new SqlConnection(cs.DBConn);
conn.Open();
string query = "SELECT PresentAddresses.PrFlatNo,PresentAddresses.PrHouseNo,PresentAddresses.PrRoadNo,PresentAddresses.PrBlock, PresentAddresses.PrArea, Divisions.Division, Districts.District, Thanas.Thana,PostOffice.PostOfficeName, PostOffice.PostCode FROM PresentAddresses INNER JOIN PostOffice ON PresentAddresses.PostOfficeId = PostOffice.PostOfficeId INNER JOIN Thanas ON PostOffice.T_ID = Thanas.T_ID INNER JOIN Districts ON Thanas.D_ID = Districts.D_ID INNER JOIN Divisions ON Districts.Division_ID = Divisions.Division_ID where PresentAddresses.UserId='" + n1userId + "'";
cmd = new SqlCommand(query, conn);
SqlDataReader rdr = cmd.ExecuteReader();
PresentAddress apAddress = new PresentAddress();
while (rdr.Read())
{
apAddress.PreFlatNo = rdr[0].ToString();
apAddress.PreHouseNo = rdr[1].ToString();
apAddress.PreRoadNo = rdr[2].ToString();
apAddress.PreBlock = rdr[3].ToString();
apAddress.PreArea = rdr[4].ToString();
apAddress.PreDivision = rdr[5].ToString();
apAddress.PreDistrict = rdr[6].ToString();
apAddress.PreThana = rdr[7].ToString();
apAddress.PostOfficeName = rdr[8].ToString();
apAddress.PrePostCode = rdr[9].ToString();
}
rdr.Close();
conn.Close();
return(apAddress);
}
public int SavePresentAddress(PresentAddress apresentAddress)
{
conn = new SqlConnection(cs.DBConn);
conn.Open();
string qry2 = "insert into PresentAddresses(PrFlatNo,PrHouseNo,PrRoadNo,PrBlock,PrArea,PrLandMark,PrRoadName,PrBuilding,PostOfficeId,UserId) Values(@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9,@d10)";
cmd = new SqlCommand(qry2, conn);
cmd.Parameters.AddWithValue("@d1", string.IsNullOrEmpty(apresentAddress.PreFlatNo) ? (object)DBNull.Value : apresentAddress.PreFlatNo);
cmd.Parameters.AddWithValue("@d2", string.IsNullOrWhiteSpace(apresentAddress.PreHouseNo)?(object)DBNull.Value:apresentAddress.PreHouseNo);
cmd.Parameters.AddWithValue("@d3", string.IsNullOrWhiteSpace(apresentAddress.PreRoadNo) ? (object)DBNull.Value : apresentAddress.PreRoadNo);
cmd.Parameters.AddWithValue("@d4", string.IsNullOrWhiteSpace(apresentAddress.PreBlock) ? (object)DBNull.Value : apresentAddress.PreBlock);
cmd.Parameters.AddWithValue("@d5", string.IsNullOrWhiteSpace(apresentAddress.PreArea) ? (object)DBNull.Value : apresentAddress.PreArea);
cmd.Parameters.AddWithValue("@d6", string.IsNullOrWhiteSpace(apresentAddress.PreLandmark) ? (object)DBNull.Value : apresentAddress.PreLandmark);
cmd.Parameters.AddWithValue("@d7", string.IsNullOrWhiteSpace(apresentAddress.PreRoadName) ? (object)DBNull.Value : apresentAddress.PreRoadName);
cmd.Parameters.AddWithValue("@d8", string.IsNullOrWhiteSpace(apresentAddress.PreBuilding) ? (object)DBNull.Value : apresentAddress.PreBuilding);
cmd.Parameters.AddWithValue("@d9", apresentAddress.PrePostOfficeId);
cmd.Parameters.AddWithValue("@d10", apresentAddress.UserId);
affectedRows2 = cmd.ExecuteNonQuery();
conn.Close();
return(affectedRows2);
// cmd.Parameters.AddWithValue("@d1", apresentAddress.PreFlatNo);
//cmd.Parameters.AddWithValue("@d2", apresentAddress.PreHouseNo);
// cmd.Parameters.AddWithValue("@d3", apresentAddress.PreRoadNo);
//cmd.Parameters.AddWithValue("@d4", apresentAddress.PreBlock);
//cmd.Parameters.AddWithValue("@d5", apresentAddress.PreArea);
//cmd.Parameters.AddWithValue("@d6", apresentAddress.PreLandmark);
//cmd.Parameters.AddWithValue("@d7", apresentAddress.PreRoadName);
//cmd.Parameters.AddWithValue("@d8", apresentAddress.PreBuilding);
}
private void PresentAddress_Enter(object sender, EventArgs e)
{
if (PresentAddress.Text.Equals("Present Address"))
{
PresentAddress.Clear();
}
}
private void UpdatePresentAddress()
{
UserGateway aGateway = new UserGateway();
PresentAddress akAddress = new PresentAddress();
akAddress.PreFlatNo = txtPreFlatNo.Text;
akAddress.PreHouseNo = txtPreHouseNo.Text;
akAddress.PreRoadNo = txtPreRoadNo.Text;
akAddress.PreBlock = txtPreBlock.Text;
akAddress.PreArea = txtPreArea.Text;
akAddress.PreLandmark = txtPreLandMark.Text;
akAddress.PreRoadName = txtPreRoadName.Text;
akAddress.PreBuilding = txtPreBuildingName.Text;
akAddress.PrePostOfficeId = Convert.ToInt32(postofficeIdPr);
akAddress.UserId = Convert.ToInt32(gUserId);
aGateway.UpdatePresentAddress(akAddress);
}
public void UpdatePresentAddress(PresentAddress akAddress)
{
conn = new SqlConnection(cs.DBConn);
conn.Open();
string qry = "Update PresentAddresses Set PrFlatNo=@d1,PrHouseNo=@d2,PrRoadNo=@d3,PrBlock=@d4,PrArea=@d5,PrLandMark=@d6,PrRoadName=@d7,PrBuilding=@d8,PostOfficeId=@d9 where UserId='" + akAddress.UserId + "' ";
cmd = new SqlCommand(qry, conn);
cmd.Parameters.AddWithValue("@d1", string.IsNullOrEmpty(akAddress.PreFlatNo) ? (object)DBNull.Value : akAddress.PreFlatNo);
cmd.Parameters.AddWithValue("@d2", string.IsNullOrWhiteSpace(akAddress.PreHouseNo) ? (object)DBNull.Value : akAddress.PreHouseNo);
cmd.Parameters.AddWithValue("@d3", string.IsNullOrWhiteSpace(akAddress.PreRoadNo) ? (object)DBNull.Value : akAddress.PreRoadNo);
cmd.Parameters.AddWithValue("@d4", string.IsNullOrWhiteSpace(akAddress.PreBlock) ? (object)DBNull.Value : akAddress.PreBlock);
cmd.Parameters.AddWithValue("@d5", string.IsNullOrWhiteSpace(akAddress.PreArea) ? (object)DBNull.Value : akAddress.PreArea);
cmd.Parameters.AddWithValue("@d6", string.IsNullOrWhiteSpace(akAddress.PreLandmark) ? (object)DBNull.Value : akAddress.PreLandmark);
cmd.Parameters.AddWithValue("@d7", string.IsNullOrWhiteSpace(akAddress.PreRoadName) ? (object)DBNull.Value : akAddress.PreRoadName);
cmd.Parameters.AddWithValue("@d8", string.IsNullOrWhiteSpace(akAddress.PreBuilding) ? (object)DBNull.Value : akAddress.PreBuilding);
cmd.Parameters.AddWithValue("@d9", akAddress.PrePostOfficeId);
cmd.ExecuteReader();
conn.Close();
}
public int PerManantSameAsPresentAddress(PresentAddress apresentAddress)
{
aUserGateway = new UserGateway();
return(aUserGateway.PerManantSameAsPresentAddress(apresentAddress));
}
public int SavePresentAddress(PresentAddress apresentAddress)
{
aUserGateway = new UserGateway();
return(aUserGateway.SavePresentAddress(apresentAddress));
}
private void PresentAddress_Click(object sender, EventArgs e)
{
PresentAddress.Clear();
}
