public JsonResult RestrictPassSaleLimit(PassSaleLimit PassSaleLimitData)
{
string success = "";
try
{
int result = passTypeDAL_obj.RestrictPassSaleLimit(PassSaleLimitData, Convert.ToString(Session["UserID"]));
if (result > 0)
{
success = "Success";
}
else
{
success = "Failed";
}
if (result == -1)
{
success = "Data Exists";
}
return(Json(success, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
public int RestrictPassSaleLimit(PassSaleLimit pass_data, string CreatedBy)
{
sqlhelper_obj = new SqlHelper();
string pass_data_status = string.Empty;
int result;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection())
{
sqlconn_obj.ConnectionString = sqlhelper_obj.GetConnectionSrting();
using (SqlCommand sqlcmd_details_obj = new SqlCommand("PARK_PROC_SavePassSaleLimit", sqlconn_obj))
{
sqlcmd_details_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_details_obj.CommandTimeout = 0;
if (pass_data.PassSaleLimitID.ToString() != "" && pass_data.PassSaleLimitID != 0)
{
sqlcmd_details_obj.Parameters.AddWithValue("@StmtType", "Update");
sqlcmd_details_obj.Parameters.AddWithValue("@PassSaleLimitID", pass_data.PassSaleLimitID);
}
else
{
sqlcmd_details_obj.Parameters.AddWithValue("@StmtType", "Insert");
sqlcmd_details_obj.Parameters.AddWithValue("@PassSaleLimitID", DBNull.Value);
}
sqlcmd_details_obj.Parameters.AddWithValue("@PassTypeID", pass_data.PassTypeID);
sqlcmd_details_obj.Parameters.AddWithValue("@VehicleTypeID", pass_data.VehicleTypeID);
sqlcmd_details_obj.Parameters.AddWithValue("@LimitPercentage", String.IsNullOrEmpty(Convert.ToString(pass_data.LimitPercentage)) ? (object)DBNull.Value : Convert.ToString(pass_data.LimitPercentage).Trim());
sqlcmd_details_obj.Parameters.AddWithValue("@UpdatedBy", Convert.ToInt32(CreatedBy));
if (pass_data.IsActive.ToString() == "")
{
sqlcmd_details_obj.Parameters.AddWithValue("@IsActive", true);
}
else
{
sqlcmd_details_obj.Parameters.AddWithValue("@IsActive", Convert.ToBoolean(pass_data.IsActive));
}
sqlcmd_details_obj.Parameters.Add("@Output_identity", SqlDbType.Int).Direction = ParameterDirection.Output;
sqlconn_obj.Open();
int res = sqlcmd_details_obj.ExecuteNonQuery();
result = Convert.ToInt32(sqlcmd_details_obj.Parameters["@Output_identity"].Value);
sqlconn_obj.Close();
}
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <PassSaleLimit> GetPassSaleLimitList()
{
IList <PassSaleLimit> passsaleLimitList = new List <PassSaleLimit>();
sqlhelper_obj = new SqlHelper();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection())
{
sqlconn_obj.ConnectionString = sqlhelper_obj.GetConnectionSrting();
using (SqlCommand sqlcmd_obj = new SqlCommand("PARK_PROC_GetAllPassSaleLimits", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.CommandTimeout = 0;
DataSet ds;
using (SqlDataAdapter da = new SqlDataAdapter(sqlcmd_obj))
{
ds = new DataSet();
da.Fill(ds);
}
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
PassSaleLimit pass_obj = new PassSaleLimit();
pass_obj.PassSaleLimitID = Convert.ToInt32(dt.Rows[i]["PassSaleLimitID"]);
pass_obj.PassTypeID = Convert.ToInt32(dt.Rows[i]["PassTypeID"]);
pass_obj.VehicleTypeID = Convert.ToInt32(dt.Rows[i]["VehicleTypeID"]);
pass_obj.LimitPercentage = Convert.ToInt32(dt.Rows[i]["LimitPercentage"]);
pass_obj.VehicleTypeName = Convert.ToString(dt.Rows[i]["VehicleTypeName"]);
pass_obj.PassTypeName = Convert.ToString(dt.Rows[i]["PassTypeName"]);
pass_obj.IsActive = Convert.ToBoolean(dt.Rows[i]["IsActive"]);
pass_obj.UpdatedOn = dt.Rows[i]["UpdatedOn"] == DBNull.Value ? Convert.ToDateTime(null) : Convert.ToDateTime(dt.Rows[i]["UpdatedOn"]);
passsaleLimitList.Add(pass_obj);
}
}
}
return(passsaleLimitList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <PassSaleLimit> EditPassSaleLimit(int PassSaleLimitID)
{
sqlhelper_obj = new SqlHelper();
List <PassSaleLimit> pass_List = new List <PassSaleLimit>();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection())
{
sqlconn_obj.ConnectionString = sqlhelper_obj.GetConnectionSrting();
using (SqlCommand sqlcmd_details_obj = new SqlCommand("PARK_PROC_GetPassSaleLimitByID", sqlconn_obj))
{
sqlcmd_details_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_details_obj.CommandTimeout = 0;
sqlcmd_details_obj.Parameters.AddWithValue("@PassSaleLimitID", PassSaleLimitID);
DataSet ds;
using (SqlDataAdapter sql_dp = new SqlDataAdapter(sqlcmd_details_obj))
{
ds = new DataSet();
sql_dp.Fill(ds);
}
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
PassSaleLimit pass_obj = new PassSaleLimit();
pass_obj.PassSaleLimitID = Convert.ToInt32(row["PassSaleLimitID"]);
pass_obj.PassTypeID = Convert.ToInt32(row["PassTypeID"]);
pass_obj.VehicleTypeID = Convert.ToInt32(row["VehicleTypeID"]);
pass_obj.LimitPercentage = Convert.ToInt32(row["LimitPercentage"]);
pass_obj.IsActive = Convert.ToBoolean(row["IsActive"]);
pass_List.Add(pass_obj);
}
}
}
return(pass_List);
}
catch (Exception ex)
{
throw ex;
}
}
