/// <summary>
/// Method to Get the Particular Record from Database
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Sarai GetSingleRecordDetail(int Id)
{
Sarai obj = new Sarai();
string strQuery = "";
strQuery = strQuery + System.Environment.NewLine + "SELECT M.ID AS Id,";
strQuery = strQuery + System.Environment.NewLine + " M.NAME AS Name,";
strQuery = strQuery + System.Environment.NewLine + " M.ADDRESS AS Address,";
strQuery = strQuery + System.Environment.NewLine + " M.CITY AS City,";
strQuery = strQuery + System.Environment.NewLine + " M.PINCODE AS Pincode,";
strQuery = strQuery + System.Environment.NewLine + " M.STATE AS State,";
strQuery = strQuery + System.Environment.NewLine + " M.IS_ACTIVE AS IsActive,";
strQuery = strQuery + System.Environment.NewLine + " M.MAX_ADULT_COUNT AS MaxAdultCount,";
strQuery = strQuery + System.Environment.NewLine + " M.MAX_CHILDREN_COUNT AS MaxChildrenCount,";
strQuery = strQuery + System.Environment.NewLine + " M.CHECK_IN_TIME AS CheckInTime,";
strQuery = strQuery + System.Environment.NewLine + " M.CHECK_OUT_TIME AS CheckOutTime,";
strQuery = strQuery + System.Environment.NewLine + " M.MAX_ROOM_BOOKING_DAYS_FROM_ONLINE_PORTAL AS MaxRoomBookingDaysFromOnlinePortal,";
strQuery = strQuery + System.Environment.NewLine + " M.MAX_ROOMS_COUNT_FOR_SINGLE_BOOKING_FROM_ONLINE_PORTAL AS MaxRoomsCountForSingleBookingFromOnlinePortal,";
strQuery = strQuery + System.Environment.NewLine + " M.PRIOR_DAYS_COUNT_FOR_ONLINE_PORTAL AS PriorDaysCountForOnlinePortal,";
strQuery = strQuery + System.Environment.NewLine + " M.DAYS_COUNT_FOR_NEXT_BOOKING_FROM_ONLINE_PORTAL AS DaysCountForNextBookingFromOnlinePortal";
strQuery = strQuery + System.Environment.NewLine + "FROM SARAI_MASTER M";
strQuery = strQuery + System.Environment.NewLine + "WHERE M.ID = "+ Id.ToString();
obj = Db.DapperGet <Sarai>(strQuery);
return(obj);
}
/// <summary>
/// Method to Save the Entry
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int SaveData(Sarai obj)
{
int Id = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ID", obj.Id));
parameters.Add(new SqlParameter("@NAME", obj.Name));
parameters.Add(new SqlParameter("@REMARKS", obj.Remarks));
parameters.Add(new SqlParameter("@IS_ACTIVE", obj.IsActive));
parameters.Add(new SqlParameter("@ROW_VERSION", obj.RowVersion));
parameters.Add(new SqlParameter("@CHECKSUM_VALUE", obj.CheckSumValue));
parameters.Add(new SqlParameter("@SUPERADMIN_USERNAME", Localizer.CurrentUser.SuperAdminName));
parameters.Add(new SqlParameter("@USER_MASTER_ID", Localizer.CurrentUser.Id));
DataTable dt = Db.GetDataTable("SAVE_UPDATE_SARAI_MASTER", parameters);
if (dt.Rows.Count > 0)
{
Id = Convert.ToInt32(dt.Rows[0][0]);
}
return(Id);
}
