/// <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");
}
}
