public int DL_InsCityMaster(ML_City_Master objML_Default)
{
SqlParameter[] par = { new SqlParameter("@CityId", objML_Default.CityId),
new SqlParameter("@CityName", objML_Default.CityName),
new SqlParameter("@StateId", objML_Default.StateId),
new SqlParameter("@CreatedBy", objML_Default.CreatedBy),
new SqlParameter("@ModifyBy", objML_Default.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "OSP_InsUpdCity", par));
}
public DataTable BL_EditCity(ML_City_Master objML_Default)
{
return(objCity.DL_EditCity(objML_Default));
}
public int BL_DeleteCity(ML_City_Master objML_Default)
{
return(objCity.DL_DeleteCity(objML_Default));
}
public int BL_InsCityDetail(ML_City_Master objML_Default)
{
return(objCity.DL_InsCityMaster(objML_Default));
}
public DataTable DL_EditCity(ML_City_Master objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.CityId), };
return(SqlHelper.ExecuteDataset(con, "SPCN_City_Edit", par).Tables[0]);
}
public int DL_DeleteCity(ML_City_Master objML_Default)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Default.CityId), };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_City_Delete", par));
}