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