public bool insertProperty(PropertyDetailsEdit Prop) { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); SqlCommand cmdid = new SqlCommand("Select top 1 * from PropertyListMaster order by PropertyID desc", conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr; dr = cmdid.ExecuteReader(); int propertyID = 0; if (dr.Read()) { propertyID = int.Parse(dr["PropertyID"].ToString()); } dr.Close(); propertyID++; SqlCommand cmdidp = new SqlCommand("Select * from ProjectMaster PM, LocationMaster LM where PM.LocationID=LM.LocationID and ProjectID=" + Prop.ProjectID, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader drp; drp = cmdidp.ExecuteReader(); //int projectID = 0; string mLocation = ""; string mproject = ""; if (drp.Read()) { // projectID = int.Parse(dr["ProjectID"].ToString()); mLocation = drp["Location"].ToString().Trim(); mproject = drp["ProjectName"].ToString().Trim(); } drp.Close(); //projectID++; SqlCommand cmdPT = new SqlCommand("Select * from PropertytypeMaster where PTID=" + Prop.PTID, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader drL; drL = cmdPT.ExecuteReader(); string PropertyT = ""; if (drL.Read()) { PropertyT = drL["PropertyType"].ToString(); } drL.Close(); string propertyIDLink = mproject + "-" + mLocation + " " + PropertyT + " " + propertyID; propertyIDLink = propertyIDLink.Replace(" ", " ").Replace(" ", " ").Replace(" ", " "); propertyIDLink = propertyIDLink.Replace(" ", "-"); SqlCommand cmd = new SqlCommand("Insert into PropertyListMaster (Estate_ID, Member_ID,ProjectID, PTID, BudgetID, Possession, StartPrice, BedRooms, BathRooms, Balconies, StoreRooms, SuperArea, CarpetArea, FaceSide, Floor, CarParking,PropertyID, Entry_date,Sales_Status) Values(@Estate_ID, 0, @ProjectID, @PTID, @BudgetID, @Possession, @StartPrice, @BedRooms, @BathRooms, @Balconies, @StoreRooms, @SuperArea, @CarpetArea, @FaceSide, @Floor, @CarParking, @PropertyID,@Created_Date,'N')", conn); cmd.Parameters.Add(new SqlParameter("@PropertyID", SqlDbType.Int)).Value = propertyID; cmd.Parameters.Add(new SqlParameter("@Estate_ID", SqlDbType.NVarChar, propertyIDLink.Trim().Length)).Value = propertyIDLink.Trim(); cmd.Parameters.Add(new SqlParameter("@ProjectID", SqlDbType.Int)).Value = Prop.ProjectID; cmd.Parameters.Add(new SqlParameter("@PTID", SqlDbType.Int)).Value = Prop.PTID; cmd.Parameters.Add(new SqlParameter("@BudgetID", SqlDbType.Int)).Value = Prop.BudgetID; cmd.Parameters.Add(new SqlParameter("@StartPrice", SqlDbType.NVarChar, Prop.StartPrice.ToString().Trim().Length)).Value = Prop.StartPrice.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@BedRooms", SqlDbType.NVarChar, Prop.BedRooms.ToString().Trim().Length)).Value = Prop.BedRooms.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@BathRooms", SqlDbType.NVarChar, Prop.BathRooms.ToString().Trim().Length)).Value = Prop.BathRooms.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Balconies", SqlDbType.NVarChar, Prop.Balconies.ToString().Trim().Length)).Value = Prop.Balconies.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@StoreRooms", SqlDbType.NVarChar, Prop.StoreRooms.ToString().Trim().Length)).Value = Prop.StoreRooms.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@SuperArea", SqlDbType.NVarChar, Prop.SuperArea.ToString().Trim().Length)).Value = Prop.SuperArea.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@CarpetArea", SqlDbType.NVarChar, Prop.CarpetArea.ToString().Trim().Length)).Value = Prop.CarpetArea.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@FaceSide", SqlDbType.NVarChar, Prop.FaceSide.ToString().Trim().Length)).Value = Prop.FaceSide.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Floor", SqlDbType.NVarChar, Prop.Floor.ToString().Trim().Length)).Value = Prop.Floor.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@CarParking", SqlDbType.NVarChar, Prop.CarParking.ToString().Trim().Length)).Value = Prop.CarParking.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Possession", SqlDbType.NVarChar, Prop.Possession.ToString().Trim().Length)).Value = Prop.Possession.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Created_Date", SqlDbType.DateTime)).Value = DateTime.Now.ToString("yyyy/MM/dd"); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); }
public bool UpdateProperty(PropertyDetailsEdit Prop) { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); SqlCommand cmdid = new SqlCommand("Select * from ProjectMaster PM, LocationMaster LM where PM.LocationID=LM.LocationID and ProjectID=" + Prop.ProjectID, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr; dr = cmdid.ExecuteReader(); int projectID = 0; string mLocation = ""; string mproject = ""; if (dr.Read()) { projectID = int.Parse(dr["ProjectID"].ToString()); mLocation = dr["Location"].ToString().Trim(); mproject = dr["ProjectName"].ToString().Trim(); } dr.Close(); //projectID++; SqlCommand cmdPT = new SqlCommand("Select * from PropertytypeMaster where PTID=" + Prop.PTID, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader drL; drL = cmdPT.ExecuteReader(); string PropertyT = ""; if (drL.Read()) { PropertyT = drL["PropertyType"].ToString(); } drL.Close(); string propertyIDLink = mproject + "-" + mLocation + " " + PropertyT + " " + Prop.PropertyID; propertyIDLink = propertyIDLink.Replace(" ", " ").Replace(" ", " ").Replace(" ", " "); propertyIDLink = propertyIDLink.Replace(" ", "-"); SqlCommand cmd = new SqlCommand("Update PropertyListMaster set ViewStatus=@ViewStatus, Estate_ID=@Estate_ID, ProjectID=@ProjectID, PTID=@PTID, Possession=@Possession, StartPrice=@StartPrice, BedRooms=@BedRooms, BathRooms=@BathRooms, Balconies=@Balconies, StoreRooms=@StoreRooms, SuperArea=@SuperArea, CarpetArea=@CarpetArea, FaceSide=@FaceSide, Floor=@Floor, CarParking=@CarParking where PropertyID=" + Prop.PropertyID, conn); cmd.Parameters.Add(new SqlParameter("@Estate_ID", SqlDbType.NVarChar, propertyIDLink.Trim().Length)).Value = propertyIDLink.Trim(); cmd.Parameters.Add(new SqlParameter("@ProjectID", SqlDbType.Int)).Value = Prop.ProjectID; cmd.Parameters.Add(new SqlParameter("@PTID", SqlDbType.Int)).Value = Prop.PTID; cmd.Parameters.Add(new SqlParameter("@StartPrice", SqlDbType.NVarChar, Prop.StartPrice.ToString().Trim().Length)).Value = Prop.StartPrice.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@BedRooms", SqlDbType.NVarChar, Prop.BedRooms.ToString().Trim().Length)).Value = Prop.BedRooms.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@BathRooms", SqlDbType.NVarChar, Prop.BathRooms.ToString().Trim().Length)).Value = Prop.BathRooms.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Balconies", SqlDbType.NVarChar, Prop.Balconies.ToString().Trim().Length)).Value = Prop.Balconies.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@StoreRooms", SqlDbType.NVarChar, Prop.StoreRooms.ToString().Trim().Length)).Value = Prop.StoreRooms.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@SuperArea", SqlDbType.NVarChar, Prop.SuperArea.ToString().Trim().Length)).Value = Prop.SuperArea.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@CarpetArea", SqlDbType.NVarChar, Prop.CarpetArea.ToString().Trim().Length)).Value = Prop.CarpetArea.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@FaceSide", SqlDbType.NVarChar, Prop.FaceSide.ToString().Trim().Length)).Value = Prop.FaceSide.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Floor", SqlDbType.NVarChar, Prop.Floor.ToString().Trim().Length)).Value = Prop.Floor.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@CarParking", SqlDbType.NVarChar, Prop.CarParking.ToString().Trim().Length)).Value = Prop.CarParking.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@Possession", SqlDbType.NVarChar, Prop.Possession.ToString().Trim().Length)).Value = Prop.Possession.ToString().Trim(); cmd.Parameters.Add(new SqlParameter("@ViewStatus", SqlDbType.Bit)).Value = Prop.ViewStatus; if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); }