public OOfferMySpace InsertOfferMySpace(COfferMySpace objOffer)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OOfferMySpace obj_Offer = new OOfferMySpace();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_INSERTOFFERMYSPACE", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerID", objOffer.CustomerID);
sqlcmd_obj.Parameters.AddWithValue("@Name", objOffer.Name);
sqlcmd_obj.Parameters.AddWithValue("@PhoneNumber", objOffer.PhoneNumber);
sqlcmd_obj.Parameters.AddWithValue("@Email", objOffer.Email);
sqlcmd_obj.Parameters.AddWithValue("@OtherDetails", objOffer.Other);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_Offer.OfferMySpaceID = Convert.ToInt32(resultdt.Rows[0]["OfferMySpaceID"]);
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALOfferMySpace", "Proc: " + "CTAPP_PROC_INSERTOFFERMYSPACE", "InsertOfferMySpace");
throw;
}
return(obj_Offer);
}
public List <OCustomerVehiclePass> GetListOfPassesByCustomerID(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
List <OCustomerVehiclePass> obj_listOCustomerVehiclePass = new List <OCustomerVehiclePass>();
OCustomerVehiclePass obj_OCustomerVehiclePass = new OCustomerVehiclePass();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_GETLISTOFPASSESBYCUSTOMERID", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerID", objCustomerVehicle.CustomerID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
for (int i = 0; i < resultdt.Rows.Count; i++)
{
obj_OCustomerVehiclePass = new OCustomerVehiclePass();
//obj_OCustomerVehiclePass.CustomerVehiclePassID = Convert.ToInt32(resultdt.Rows[i]["CustomerVehiclePassID"]);
obj_OCustomerVehiclePass.CustomerVehicleID = Convert.ToInt32(resultdt.Rows[i]["CustomerVehicleID"]);
//obj_OCustomerVehiclePass.LocationID = Convert.ToInt32(resultdt.Rows[i]["LocationID"]);
obj_OCustomerVehiclePass.VehicleTypeID = Convert.ToInt32(resultdt.Rows[i]["VehicleTypeID"]);
obj_OCustomerVehiclePass.VehicleImage = Convert.ToString(resultdt.Rows[i]["VehicleImage"]);
obj_OCustomerVehiclePass.Model = Convert.ToString(resultdt.Rows[i]["Model"]);
obj_OCustomerVehiclePass.RegistrationNumber = Convert.ToString(resultdt.Rows[i]["RegistrationNumber"]);
obj_OCustomerVehiclePass.LocationName = Convert.ToString(resultdt.Rows[i]["LocationName"]);
obj_OCustomerVehiclePass.StartDate = Convert.ToDateTime(resultdt.Rows[i]["StartDate"]);
obj_OCustomerVehiclePass.ExpiryDate = Convert.ToDateTime(resultdt.Rows[i]["ExpiryDate"]);
obj_OCustomerVehiclePass.Amount = Convert.ToString(resultdt.Rows[i]["Amount"]);
obj_OCustomerVehiclePass.CardAmount = Convert.ToString(resultdt.Rows[i]["CardAmount"]);
obj_OCustomerVehiclePass.TotalAmount = "₹ " + Convert.ToString(resultdt.Rows[i]["TotalAmount"]) + " /-";
obj_OCustomerVehiclePass.PaymentTypeName = Convert.ToString(resultdt.Rows[i]["PaymentTypeName"]);
obj_OCustomerVehiclePass.PassPrice = "₹ " + Convert.ToString(resultdt.Rows[i]["PassPrice"]) + " /-";
obj_OCustomerVehiclePass.PassTypeName = Convert.ToString(resultdt.Rows[i]["PassTypeName"]);
obj_OCustomerVehiclePass.ValidUpTo = Convert.ToString(resultdt.Rows[i]["ValidUpTo"]);
obj_OCustomerVehiclePass.IsMultiLot = resultdt.Rows[i]["IsMultiLot"] == null ? false : Convert.ToBoolean(resultdt.Rows[i]["IsMultiLot"]);
obj_OCustomerVehiclePass.SingleOrMulti = Convert.ToString(resultdt.Rows[i]["SingleOrMulti"]);
obj_OCustomerVehiclePass.IssuedCard = resultdt.Rows[i]["IssuedCard"] == null ? false : Convert.ToBoolean(resultdt.Rows[i]["IssuedCard"]);
obj_OCustomerVehiclePass.CardNumber = Convert.ToString(resultdt.Rows[i]["CardNumber"]);
obj_listOCustomerVehiclePass.Add(obj_OCustomerVehiclePass);
}
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_GETLISTOFPASSESBYVEHICLEID", "GetListOfPassesByVehicleID");
throw;
}
return(obj_listOCustomerVehiclePass);
}
public OSupport InsertSupport(CSupport objSuffer)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OSupport obj_Support = new OSupport();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_INSERTSUPPORT", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerID", objSuffer.CustomerID);
sqlcmd_obj.Parameters.AddWithValue("@Name", objSuffer.Name);
sqlcmd_obj.Parameters.AddWithValue("@PhoneNumber", objSuffer.PhoneNumber);
sqlcmd_obj.Parameters.AddWithValue("@Email", objSuffer.Email);
sqlcmd_obj.Parameters.AddWithValue("@Message", objSuffer.Message);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_Support.SupportRequestID = Convert.ToInt32(resultdt.Rows[0]["SupportRequestID"]);
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALSupport", "Proc: " + "CTAPP_PROC_INSERTSUPPORT", "InsertSupport");
throw;
}
return(obj_Support);
}
public OCustomerVehiclePass UpdatePassTransactionID(CustomerVehiclePass objCustomerVehiclePass)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OCustomerVehiclePass obj_OCustomerVehiclePass = new OCustomerVehiclePass();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_UPDATEPASSTRANSACTIONID", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehiclePassID", objCustomerVehiclePass.CustomerVehiclePassID);
sqlcmd_obj.Parameters.AddWithValue("@IsMultiLot", objCustomerVehiclePass.IsMultiLot);
sqlcmd_obj.Parameters.AddWithValue("@TransactionID", objCustomerVehiclePass.TransactionID);
sqlcmd_obj.Parameters.AddWithValue("@UpdatedBy", objCustomerVehiclePass.CustomerID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_OCustomerVehiclePass.CustomerVehiclePassID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehiclePassID"]);
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALPass", "Proc: " + "CTAPP_PROC_UPDATEPASSTRANSACTIONID", "UpdatePassTransactionID");
throw;
}
return(obj_OCustomerVehiclePass);
}
public List <OCustomerVehicle> GetListOfCustomerVehicleWithType(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
List <OCustomerVehicle> obj_listOCustomerVehicle = new List <OCustomerVehicle>();
OCustomerVehicle obj_OCustomerVehicle = new OCustomerVehicle();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_GETLISTOFCUSTOMERVEHICLEWITHTYPE", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerID", objCustomerVehicle.CustomerID);
sqlcmd_obj.Parameters.AddWithValue("@VehicleTypeID", objCustomerVehicle.VehicleTypeID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
for (int i = 0; i < resultdt.Rows.Count; i++)
{
obj_OCustomerVehicle = new OCustomerVehicle();
obj_OCustomerVehicle.CustomerVehicleMapperID = Convert.ToInt32(resultdt.Rows[i]["CustomerVehicleMapperID"]);
obj_OCustomerVehicle.CustomerVehicleID = Convert.ToInt32(resultdt.Rows[i]["CustomerVehicleID"]);
obj_OCustomerVehicle.CustomerID = Convert.ToInt32(resultdt.Rows[i]["CustomerID"]);
obj_OCustomerVehicle.VehicleTypeCode = Convert.ToString(resultdt.Rows[i]["VehicleTypeCode"]);
obj_OCustomerVehicle.VehicleTypeID = Convert.ToInt32(resultdt.Rows[i]["VehicleTypeID"]);
obj_OCustomerVehicle.RegistrationNumber = Convert.ToString(resultdt.Rows[i]["RegistrationNumber"]);
obj_OCustomerVehicle.RegistrationNumberType = Convert.ToString(resultdt.Rows[i]["RegistrationNumberType"]);
obj_OCustomerVehicle.VehicleImage = "resource://InstaConsumer.Resources." + Convert.ToString(resultdt.Rows[i]["VehicleImage"]);
obj_OCustomerVehicle.Make = resultdt.Rows[i]["Make"] == null ? "" : Convert.ToString(resultdt.Rows[i]["Make"]);
obj_OCustomerVehicle.Model = resultdt.Rows[i]["Model"] == null ? "" : Convert.ToString(resultdt.Rows[i]["Model"]);
obj_OCustomerVehicle.Color = resultdt.Rows[i]["Color"] == null ? "" : Convert.ToString(resultdt.Rows[i]["Color"]);
obj_OCustomerVehicle.IsPrimaryVehicle = resultdt.Rows[i]["IsPrimaryVehicle"] == null ? false : Convert.ToBoolean(resultdt.Rows[i]["IsPrimaryVehicle"]);
obj_OCustomerVehicle.PrimaryVehicleImage = "resource://InstaConsumer.Resources." + Convert.ToString(resultdt.Rows[i]["PrimaryVehicleImage"]);
obj_OCustomerVehicle.IsActive = resultdt.Rows[i]["IsActive"] == null ? true : Convert.ToBoolean(resultdt.Rows[i]["IsActive"]);
obj_OCustomerVehicle.Name = Convert.ToString(resultdt.Rows[i]["Name"]);
obj_OCustomerVehicle.PhoneNumber = Convert.ToString(resultdt.Rows[i]["PhoneNumber"]);
//obj_OCustomerVehicle.CheckedFlag = resultdt.Rows[i]["CheckedFlag"] == null ? false : Convert.ToBoolean(resultdt.Rows[i]["CheckedFlag"]);
obj_listOCustomerVehicle.Add(obj_OCustomerVehicle);
}
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_GETLISTOFCUSTOMERVEHICLEWITHTYPE", "GetListOfCustomerVehicleWithType");
throw;
}
return(obj_listOCustomerVehicle);
}
public List <PassPrice> GetPassTypesByVehicleTypeID(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
List <PassPrice> lstPassPrice = null;
DataTable resultdt = new DataTable();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_GETPASSTYPESBYVEHICLETYPEID", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@VehicleTypeID", objCustomerVehicle.VehicleTypeID);
sqlcmd_obj.Parameters.AddWithValue("@LocationID", objCustomerVehicle.LocationID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
lstPassPrice = new List <PassPrice>();
for (var i = 0; i < resultdt.Rows.Count; i++)
{
PassPrice objPassPrice = new PassPrice();
objPassPrice.PassIndex = i;
objPassPrice.PassPriceID = resultdt.Rows[i]["PassPriceID"] == DBNull.Value ? 0 : Convert.ToInt32(resultdt.Rows[i]["PassPriceID"]);
objPassPrice.PassCode = resultdt.Rows[i]["PassCode"] == DBNull.Value ? "" : Convert.ToString(resultdt.Rows[i]["PassCode"]);
objPassPrice.StationAccess = resultdt.Rows[i]["StationAccess"] == DBNull.Value ? "" : Convert.ToString(resultdt.Rows[i]["StationAccess"]);
objPassPrice.StartDate = resultdt.Rows[i]["StartDate"] == DBNull.Value ? (Nullable <DateTime>)null : Convert.ToDateTime(resultdt.Rows[i]["StartDate"]);
objPassPrice.EndDate = resultdt.Rows[i]["EndDate"] == DBNull.Value ? (Nullable <DateTime>)null : Convert.ToDateTime(resultdt.Rows[i]["EndDate"]);
objPassPrice.Duration = resultdt.Rows[i]["Duration"] == DBNull.Value ? "" : Convert.ToString(resultdt.Rows[i]["Duration"]);
objPassPrice.Price = resultdt.Rows[i]["Price"] == DBNull.Value ? 0 : Convert.ToInt32(resultdt.Rows[i]["Price"]);
objPassPrice.PriceDisplay = "₹ " + (resultdt.Rows[i]["Price"] == DBNull.Value ? "0" : Convert.ToString(resultdt.Rows[i]["Price"])) + " /-";
objPassPrice.TagType = Convert.ToInt32(resultdt.Rows[i]["TagType"]);
objPassPrice.TagPrice = Convert.ToDecimal(resultdt.Rows[i]["TagPrice"]);
objPassPrice.VehicleTypeID = resultdt.Rows[i]["VehicleTypeID"] == DBNull.Value ? 0 : Convert.ToInt32(resultdt.Rows[i]["VehicleTypeID"]);
objPassPrice.PassTypeID = resultdt.Rows[i]["PassTypeID"] == DBNull.Value ? 0 : Convert.ToInt32(resultdt.Rows[i]["PassTypeID"]);
objPassPrice.PassTypeName = resultdt.Rows[i]["PassTypeName"] == DBNull.Value ? "" : Convert.ToString(resultdt.Rows[i]["PassTypeName"]);
objPassPrice.PassTypeCode = resultdt.Rows[i]["PassTypeCode"] == DBNull.Value ? "" : Convert.ToString(resultdt.Rows[i]["PassTypeCode"]);//New
objPassPrice.PassBordorColour = "#a3a3a3";
objPassPrice.PassBackgroundColour = "#FFFFFF";
objPassPrice.PassTextColour = "#a3a3a3";
lstPassPrice.Add(objPassPrice);
}
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALPass", "Proc: " + "CTAPP_PROC_GETPASSTYPESBYVEHICLETYPEID", "GetPassTypesByVehicleTypeID");
}
return(lstPassPrice);
}
public ORFIDCheckInOut entry(RFIDCheckIn objCheckIn)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
ORFIDCheckInOut obj_CheckInOut = new ORFIDCheckInOut();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_INSERTRFIDCHECKINOUT", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@RFIDCheckInOutID", DBNull.Value);
sqlcmd_obj.Parameters.AddWithValue("@LocationID", objCheckIn.locationId);
sqlcmd_obj.Parameters.AddWithValue("@LotID", objCheckIn.lotId);
sqlcmd_obj.Parameters.AddWithValue("@DeviceName", objCheckIn.deviceName);
sqlcmd_obj.Parameters.AddWithValue("@BeaconID", objCheckIn.beaconId);
sqlcmd_obj.Parameters.AddWithValue("@AvgTimeDuration", Convert.ToInt32(objCheckIn.avgTimeDuration));
sqlcmd_obj.Parameters.AddWithValue("@XCoordinate", objCheckIn.xCoordinate);
sqlcmd_obj.Parameters.AddWithValue("@YCoordinate", objCheckIn.yCoordinate);
sqlcmd_obj.Parameters.AddWithValue("@ErrorPrecision", objCheckIn.errorPrecision);
DateTimeOffset dateTimeOffset = DateTimeOffset.FromUnixTimeSeconds(objCheckIn.checkInTime).ToLocalTime();
DateTime checkInDateTime = dateTimeOffset.DateTime;
sqlcmd_obj.Parameters.AddWithValue("@CheckInTime", checkInDateTime);
sqlcmd_obj.Parameters.AddWithValue("@CheckOutTime", DBNull.Value);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_CheckInOut.RFIDCheckInOutID = Convert.ToInt32(resultdt.Rows[0]["RFIDCheckInOutID"]);
}
else
{
obj_CheckInOut.RFIDCheckInOutID = 0;
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALRFID", "Proc: " + "CTAPP_PROC_INSERTRFIDCHECKINOUT", "entry");
//throw;
obj_CheckInOut.RFIDCheckInOutID = 0;
}
return(obj_CheckInOut);
}
public OCustomerVehiclePass GetCustomerVehiclePassDetails(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OCustomerVehiclePass obj_OCustomerVehiclePass = new OCustomerVehiclePass();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_GETCUSTOMERVEHICLEPASSDETAILS", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleID", objCustomerVehicle.CustomerVehicleID);
sqlcmd_obj.Parameters.AddWithValue("@LocationID", objCustomerVehicle.LocationID);
sqlcmd_obj.Parameters.AddWithValue("@LocationParkingLotID", objCustomerVehicle.LocationParkingLotID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_OCustomerVehiclePass.CustomerVehiclePassID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehiclePassID"]);
obj_OCustomerVehiclePass.CustomerVehicleID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehicleID"]);
obj_OCustomerVehiclePass.LocationID = Convert.ToInt32(resultdt.Rows[0]["LocationID"]);
obj_OCustomerVehiclePass.StartDate = Convert.ToDateTime(resultdt.Rows[0]["StartDate"]);
obj_OCustomerVehiclePass.ExpiryDate = Convert.ToDateTime(resultdt.Rows[0]["ExpiryDate"]);
obj_OCustomerVehiclePass.IsMultiLot = resultdt.Rows[0]["IsMultiLot"] == null ? false : Convert.ToBoolean(resultdt.Rows[0]["IsMultiLot"]);
obj_OCustomerVehiclePass.LotOpenTime = Convert.ToString(resultdt.Rows[0]["LotOpenTime"]);
obj_OCustomerVehiclePass.LotCloseTime = Convert.ToString(resultdt.Rows[0]["LotCloseTime"]);
}
else
{
obj_OCustomerVehiclePass.CustomerVehiclePassID = 0;
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_GETCUSTOMERVEHICLEPASSDETAILS", "GetCustomerVehiclePassDetails");
throw;
}
return(obj_OCustomerVehiclePass);
}
public OCustomerVehicle InsertCustomerVehicle(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OCustomerVehicle obj_OCustomerVehicle = new OCustomerVehicle();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_INSERTUPDATECUSTOMERVEHICLE", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleID", 0);
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleMapperID", 0);
sqlcmd_obj.Parameters.AddWithValue("@CustomerID", objCustomerVehicle.CustomerID);
sqlcmd_obj.Parameters.AddWithValue("@VehicleTypeCode", objCustomerVehicle.VehicleTypeCode);
sqlcmd_obj.Parameters.AddWithValue("@Make", objCustomerVehicle.Make);
sqlcmd_obj.Parameters.AddWithValue("@Model", objCustomerVehicle.Model);
sqlcmd_obj.Parameters.AddWithValue("@Color", objCustomerVehicle.Color);
sqlcmd_obj.Parameters.AddWithValue("@RegistrationNumber", objCustomerVehicle.RegistrationNumber);
sqlcmd_obj.Parameters.AddWithValue("@IsPrimaryVehicle", objCustomerVehicle.IsPrimaryVehicle);
sqlcmd_obj.Parameters.AddWithValue("@IsActive", true);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_OCustomerVehicle.CustomerVehicleID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehicleID"]);
obj_OCustomerVehicle.VehicleTypeID = Convert.ToInt32(resultdt.Rows[0]["VehicleTypeID"]);
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_INSERTUPDATECUSTOMERVEHICLE", "InsertCustomerVehicle");
throw;
}
return(obj_OCustomerVehicle);
}
public User GetLoginUserDetails(UserLogin objUser)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
User objuser = new User();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("OPAPP_PROC_LoginVerification", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@USERNAME", objUser.UserName);
sqlcmd_obj.Parameters.AddWithValue("@PASSWORD", objUser.Password);
sqlcmd_obj.Parameters.AddWithValue("@Lattitude", objUser.Latitude);
sqlcmd_obj.Parameters.AddWithValue("@Longitude", objUser.Longitude);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
objuser.UserName = Convert.ToString(resultdt.Rows[0]["USERNAME"]);
objuser.UserID = resultdt.Rows[0]["UserID"] == DBNull.Value?0:Convert.ToInt32(resultdt.Rows[0]["UserID"]);
objuser.UserTypeID.UserTypeID = resultdt.Rows[0]["UserTypeID"] == DBNull.Value?0: Convert.ToInt32(resultdt.Rows[0]["UserTypeID"]);
objuser.LocatinID.LocationID = resultdt.Rows[0]["LocationID"] == DBNull.Value ? 0 : Convert.ToInt32(resultdt.Rows[0]["LocationID"]);
objuser.LocatinID.LocationName = Convert.ToString(resultdt.Rows[0]["LocationName"]);
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALUserLoginVerification", "Proc: " + "OPAPP_PROC_LoginVerification", "GetLoginUserDetails");
throw;
}
return(objuser);
}
public CustomerParkingSlot ValidateVehicleCheckIn(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
CustomerParkingSlot obj_CustomerParkingSlot = new CustomerParkingSlot();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_VALIDATEVEHICLECHECKIN", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleID", objCustomerVehicle.CustomerVehicleID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_CustomerParkingSlot.CustomerParkingSlotID = Convert.ToInt32(resultdt.Rows[0]["CustomerParkingSlotID"]);
obj_CustomerParkingSlot.LocationName = Convert.ToString(resultdt.Rows[0]["LocationName"]);
obj_CustomerParkingSlot.LocationParkingLotName = Convert.ToString(resultdt.Rows[0]["LocationParkingLotName"]);
}
else
{
obj_CustomerParkingSlot.CustomerParkingSlotID = 0;
obj_CustomerParkingSlot.LocationName = "";
obj_CustomerParkingSlot.LocationParkingLotName = "";
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_VALIDATEVEHICLECHECKIN", "UpdateCustomerVehicle");
throw;
}
return(obj_CustomerParkingSlot);
}
public OCustomerVehicle ValidateRegistrationNumber(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OCustomerVehicle obj_CustomerVehicle = new OCustomerVehicle();
string resultMsg = string.Empty;
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_VALIDATEREGISTRATIONNUMBER", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerID", objCustomerVehicle.CustomerID);
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleID", objCustomerVehicle.CustomerVehicleID);
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleMapperID", objCustomerVehicle.CustomerVehicleMapperID);
sqlcmd_obj.Parameters.AddWithValue("@RegistrationNumber", objCustomerVehicle.RegistrationNumber);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_CustomerVehicle.CustomerVehicleID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehicleID"]);
}
else
{
obj_CustomerVehicle.CustomerVehicleID = 0;
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_VALIDATEREGISTRATIONNUMBER", "ValidateRegistrationNumber");
throw;
}
return(obj_CustomerVehicle);
}
public CustomerParkingSlot GetVehicleDueAmount(CustomerVehicle objCustomerVehicle)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
CustomerParkingSlot obj_CustomerParkingSlot = new CustomerParkingSlot();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_GETVEHICLEDUEAMOUNT", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleID", objCustomerVehicle.CustomerVehicleID);
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
DataTable resultdt = new DataTable();
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_CustomerParkingSlot.DueCustomerParkingSlotID = Convert.ToInt32(resultdt.Rows[0]["CustomerParkingSlotID"]);
obj_CustomerParkingSlot.DueAmount = Convert.ToDecimal(resultdt.Rows[0]["DueAmount"]);
}
else
{
obj_CustomerParkingSlot.DueCustomerParkingSlotID = 0;
obj_CustomerParkingSlot.DueAmount = 0;
}
}
}
}
catch (Exception ex)
{
objExceptionlog.InsertException(ex.Message, "DALVehicle", "Proc: " + "CTAPP_PROC_GETVEHICLEDUEAMOUNT", "GetVehicleDueAmount");
throw;
}
return(obj_CustomerParkingSlot);
}
public OCustomerVehiclePass InsertCustomerVehiclePass(CustomerVehiclePass objCustomerVehiclePass)
{
DALExceptionManagment objExceptionlog = new DALExceptionManagment();
OCustomerVehiclePass obj_OCustomerVehiclePass = new OCustomerVehiclePass();
DataTable resultdt = new DataTable();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString()))
{
using (SqlCommand sqlcmd_obj = new SqlCommand("CTAPP_PROC_InsertCustomerVehiclePass", sqlconn_obj))
{
sqlcmd_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehiclePassID", ((objCustomerVehiclePass.CustomerVehiclePassID == null || objCustomerVehiclePass.CustomerVehiclePassID == 0) ? (object)DBNull.Value : Convert.ToInt32(objCustomerVehiclePass.CustomerVehiclePassID)));
sqlcmd_obj.Parameters.AddWithValue("@CustomerVehicleID", ((objCustomerVehiclePass.CustomerVehicleID == null || objCustomerVehiclePass.CustomerVehicleID == 0) ? (object)DBNull.Value : Convert.ToInt32(objCustomerVehiclePass.CustomerVehicleID)));
sqlcmd_obj.Parameters.AddWithValue("@PrimaryLocationParkingLotID", DBNull.Value);
sqlcmd_obj.Parameters.AddWithValue("@PassCardTypeMapperID", DBNull.Value);
sqlcmd_obj.Parameters.AddWithValue("@PaymentTypeID", Convert.ToInt32(ConfigurationManager.AppSettings["PaymentTypeID"]));
sqlcmd_obj.Parameters.AddWithValue("@IsMultiLot", ((objCustomerVehiclePass.IsMultiLot == null) ? false : Convert.ToBoolean(objCustomerVehiclePass.IsMultiLot)));
sqlcmd_obj.Parameters.AddWithValue("@StartDate", objCustomerVehiclePass.StartDate);
sqlcmd_obj.Parameters.AddWithValue("@ExpiryDate", objCustomerVehiclePass.ExpiryDate);
sqlcmd_obj.Parameters.AddWithValue("@IssuedCard", (objCustomerVehiclePass.IssuedCard == null ? false : objCustomerVehiclePass.IssuedCard));
sqlcmd_obj.Parameters.AddWithValue("@CardNumber", (objCustomerVehiclePass.CardNumber == null ? (object)DBNull.Value : objCustomerVehiclePass.CardNumber));
sqlcmd_obj.Parameters.AddWithValue("@Amount", (objCustomerVehiclePass.Amount == null ? (object)DBNull.Value : objCustomerVehiclePass.Amount));
sqlcmd_obj.Parameters.AddWithValue("@CardAmount", (objCustomerVehiclePass.CardAmount == null ? (object)DBNull.Value : objCustomerVehiclePass.CardAmount));
sqlcmd_obj.Parameters.AddWithValue("@TotalAmount", (objCustomerVehiclePass.TotalAmount == null ? (object)DBNull.Value : objCustomerVehiclePass.TotalAmount));
sqlcmd_obj.Parameters.AddWithValue("@TransactionID", (objCustomerVehiclePass.TransactionID == null ? (object)DBNull.Value : objCustomerVehiclePass.TransactionID));
sqlcmd_obj.Parameters.AddWithValue("@StatusID", ((objCustomerVehiclePass.StatusID == null || objCustomerVehiclePass.StatusID == 0) ? (object)DBNull.Value : objCustomerVehiclePass.StatusID));
sqlcmd_obj.Parameters.AddWithValue("@PassTypeID", ((objCustomerVehiclePass.PassTypeID == null || objCustomerVehiclePass.PassTypeID == 0) ? (object)DBNull.Value : Convert.ToInt32(objCustomerVehiclePass.PassTypeID)));
sqlcmd_obj.Parameters.AddWithValue("@LocationID", ((objCustomerVehiclePass.lstLocation[0].LocationID == null || objCustomerVehiclePass.lstLocation[0].LocationID == 0) ? (object)DBNull.Value : Convert.ToInt32(objCustomerVehiclePass.lstLocation[0].LocationID)));
sqlcmd_obj.Parameters.AddWithValue("@PassPriceID", ((objCustomerVehiclePass.PassPriceID == null || objCustomerVehiclePass.PassPriceID == 0) ? (object)DBNull.Value : Convert.ToInt32(objCustomerVehiclePass.PassPriceID)));
sqlcmd_obj.Parameters.AddWithValue("@CreatedBy", ((objCustomerVehiclePass.CustomerID == null || objCustomerVehiclePass.CustomerID == 0) ? (object)DBNull.Value : Convert.ToInt32(objCustomerVehiclePass.CustomerID)));
sqlcmd_obj.Parameters.AddWithValue("@DueCustomerParkingSlotID", objCustomerVehiclePass.DueCustomerParkingSlotID);
sqlcmd_obj.Parameters.AddWithValue("@PaidDueAmount", (objCustomerVehiclePass.PaidDueAmount == 0 ? (object)DBNull.Value : objCustomerVehiclePass.PaidDueAmount));
sqlcmd_obj.Parameters.AddWithValue("@IsDueAmountPaid", (objCustomerVehiclePass.PaidDueAmount == 0 ? (object)DBNull.Value : objCustomerVehiclePass.IsDueAmountPaid));
sqlcmd_obj.Parameters.AddWithValue("@DueAmountPaidOn", (objCustomerVehiclePass.PaidDueAmount == 0 ? (object)DBNull.Value : objCustomerVehiclePass.DueAmountPaidOn));
sqlconn_obj.Open();
SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj);
sqldap.Fill(resultdt);
if (resultdt.Rows.Count > 0)
{
obj_OCustomerVehiclePass.CustomerVehiclePassID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehiclePassID"]);
obj_OCustomerVehiclePass.CustomerVehicleID = Convert.ToInt32(resultdt.Rows[0]["CustomerVehicleID"]);
obj_OCustomerVehiclePass.Model = Convert.ToString(resultdt.Rows[0]["Model"]);
obj_OCustomerVehiclePass.RegistrationNumber = Convert.ToString(resultdt.Rows[0]["RegistrationNumber"]);
obj_OCustomerVehiclePass.CustomerID = Convert.ToInt32(resultdt.Rows[0]["CustomerID"]);
obj_OCustomerVehiclePass.Name = Convert.ToString(resultdt.Rows[0]["Name"]);
obj_OCustomerVehiclePass.LocationID = Convert.ToInt32(resultdt.Rows[0]["LocationID"]);
obj_OCustomerVehiclePass.VehicleTypeID = Convert.ToInt32(resultdt.Rows[0]["VehicleTypeID"]);
obj_OCustomerVehiclePass.VehicleImage = "resource://InstaConsumer.Resources." + Convert.ToString(resultdt.Rows[0]["VehicleImage"]);
obj_OCustomerVehiclePass.LocationName = Convert.ToString(resultdt.Rows[0]["LocationName"]);
obj_OCustomerVehiclePass.StartDate = Convert.ToDateTime(resultdt.Rows[0]["StartDate"]);
obj_OCustomerVehiclePass.ExpiryDate = Convert.ToDateTime(resultdt.Rows[0]["ExpiryDate"]);
obj_OCustomerVehiclePass.Amount = "₹ " + Convert.ToString(resultdt.Rows[0]["Amount"]) + " /-";
obj_OCustomerVehiclePass.CardAmount = Convert.ToString(resultdt.Rows[0]["CardAmount"]);
obj_OCustomerVehiclePass.TotalAmount = "₹ " + Convert.ToString(resultdt.Rows[0]["TotalAmount"]) + " /-";
obj_OCustomerVehiclePass.IsMultiLot = resultdt.Rows[0]["IsMultiLot"] == null ? false : Convert.ToBoolean(resultdt.Rows[0]["IsMultiLot"]);
obj_OCustomerVehiclePass.IssuedCard = resultdt.Rows[0]["IssuedCard"] == null ? false : Convert.ToBoolean(resultdt.Rows[0]["IssuedCard"]);
obj_OCustomerVehiclePass.CardNumber = Convert.ToString(resultdt.Rows[0]["CardNumber"]);
obj_OCustomerVehiclePass.PaymentTypeName = Convert.ToString(resultdt.Rows[0]["PaymentTypeName"]);
obj_OCustomerVehiclePass.PassTypeName = Convert.ToString(resultdt.Rows[0]["PassTypeName"]);
obj_OCustomerVehiclePass.PassName = Convert.ToString(resultdt.Rows[0]["PassName"]);
obj_OCustomerVehiclePass.PassCode = Convert.ToString(resultdt.Rows[0]["PassCode"]);
obj_OCustomerVehiclePass.SingleOrMulti = Convert.ToString(resultdt.Rows[0]["StationAccess"]);
obj_OCustomerVehiclePass.PassPriceID = Convert.ToInt32(resultdt.Rows[0]["PassPriceID"]);
obj_OCustomerVehiclePass.TagType = Convert.ToString(resultdt.Rows[0]["TagType"]);
obj_OCustomerVehiclePass.CustomerName = Convert.ToString(resultdt.Rows[0]["CustomerName"]);
obj_OCustomerVehiclePass.CustomerPhoneNumber = Convert.ToString(resultdt.Rows[0]["CustomerPhoneNumber"]);
obj_OCustomerVehiclePass.CustomerEmail = Convert.ToString(resultdt.Rows[0]["CustomerEmail"]);
obj_OCustomerVehiclePass.CustomerProfileImage = resultdt.Rows[0]["CustomerProfileImage"] == DBNull.Value ? null :
(byte[])resultdt.Rows[0]["CustomerProfileImage"];
}
else
{
obj_OCustomerVehiclePass.CustomerVehiclePassID = 0;
}
}
}
}
catch (Exception ex)
{
obj_OCustomerVehiclePass.CustomerVehiclePassID = 0;
objExceptionlog.InsertException(objCustomerVehiclePass.StartDate + " Expiry " + objCustomerVehiclePass.ExpiryDate + " " + ex.Message, "DALPass", "Proc: " + "CTAPP_PROC_InsertCustomerVehiclePass", "InsertCustomerVehiclePass");
}
return(obj_OCustomerVehiclePass);
}
