/// <summary> /// This Method is used to Delete data into tbl_category table /// </summary> /// <param name="objCity">ID and Action</param> /// <returns>1 for success and -1 for fail</returns> public string DeleteCity(PropCity objCity, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_City", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); try { cmd.Parameters.AddWithValue("@ID", objCity.ID); cmd.Parameters.AddWithValue("@status", objCity.flag); cmd.Parameters.AddWithValue("@Action", "Delete"); return(cmd.ExecuteNonQuery().ToString()); } catch (Exception showError) { throw showError; } finally { cmd.Dispose(); objCon.Con.Close(); objCon.Con.Dispose(); } } else { return("Not Valid"); } }
/// <summary> /// This Method is used to Select data from tbl_City table /// </summary> /// <param name="objCity">Action</param> /// <returns>1 for success and -1 for fail</returns> public string StateWiseCity(PropCity objCity) { //if (userName != null && userName != "") //{ SqlCommand cmd = new SqlCommand("proc_City", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "Dropdown"); //cmd.Parameters.AddWithValue("@status", objCity.flag); cmd.Parameters.AddWithValue("@name", objCity.CityName); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "StateWiseCities"); objCon.Con.Close(); return(ds.GetXml()); //} //else //{ // return "Not Valid"; //} }
/// <summary> /// This Method is used to Select data from tbl_City table /// </summary> /// <param name="objCity">Action</param> /// <returns>1 for success and -1 for fail</returns> public string SelectCity(PropCity objCity, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_City", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "Select"); cmd.Parameters.AddWithValue("@status", objCity.flag); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "Cities"); objCon.Con.Close(); return(ds.GetXml()); } else { return("Not Valid"); } }
public string SelectCity(int flag) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropCity propCity = new PropCity(); propCity.flag = flag; BllCity objCity = new BllCity(); str = objCity.RecordSelect(propCity, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
public string RecordInsert(PropCity objProperty, string UserName) { Dllcity objDal = new Dllcity(); try { return(objDal.InsertCity(objProperty, UserName)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string StateWiseCities(PropCity objProperty) { Dllcity objDal = new Dllcity(); try { return(objDal.StateWiseCity(objProperty)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string DeleteCity(int ID, int Status) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropCity proCity = new PropCity(); proCity.ID = ID; proCity.flag = Status; BllCity objCity = new BllCity(); str = objCity.RecordDelete(proCity, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
public string InsertCity(int StateID, string City) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropCity proCity = new PropCity(); proCity.CityName = City; proCity.StateId = StateID; BllCity objCity = new BllCity(); str = objCity.RecordInsert(proCity, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
public string StateWisecity(int Status, int StateID) { string str = string.Empty; //if (Session["admin"] != "" || Session["admin"].ToString() != null) //{ PropCity proCity = new PropCity(); proCity.flag = Status; proCity.StateId = StateID; BllCity objcity = new BllCity(); str = objcity.StateWiseCities(proCity); return(str); //} //else //{ // return "Error in Authentication"; //} }
public string UpdateCity(string Name, int ID, int StateID) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropCity proCity = new PropCity(); proCity.CityName = Name; proCity.ID = ID; proCity.StateId = StateID; BllCity objCity = new BllCity(); str = objCity.RecordUpdate(proCity, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
/// <summary> /// This Method will be used to Post data into tbl_City table /// </summary> /// <param name="objCity">Name</param> /// <returns>1 for success and -1 for fail</returns> public string InsertCity(PropCity objCity, string userName) { if (userName != null && userName != "") { //proc_City is the stored procedure name which will be used to Insert data into the table SqlCommand cmd = new SqlCommand("proc_City", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Parameters.AddWithValue("@Name", objCity.CityName); cmd.Parameters.AddWithValue("@StateId", objCity.StateId); cmd.Parameters.AddWithValue("@Action", "Add"); return(cmd.ExecuteNonQuery().ToString()); } else { return("Not Valid"); } }