/// <summary>
/// Method to Save the Entry
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int SaveData(SaraiRoomRent obj)
{
int Id = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ID", obj.Id));
parameters.Add(new SqlParameter("@SARAI_MASTER_ID", obj.FromDate));
parameters.Add(new SqlParameter("@ROOM_CATEGORY_MASTER_ID", obj.ToDate));
parameters.Add(new SqlParameter("@FROM_DATE", obj.Remarks));
parameters.Add(new SqlParameter("@TO_DATE", obj.IsActive));
parameters.Add(new SqlParameter("@AMOUNT", obj.RowVersion));
parameters.Add(new SqlParameter("@IS_ACTIVE", obj.IsActive));
parameters.Add(new SqlParameter("@ROW_VERSION", obj.RowVersion));
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_ROOM_RENT", parameters);
if (dt.Rows.Count > 0)
{
Id = Convert.ToInt32(dt.Rows[0][0]);
}
return(Id);
}
/// <summary>
/// Method to Get the Particular Record from Database
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public SaraiRoomRent GetSingleRecordDetail(int Id)
{
SaraiRoomRent obj = new SaraiRoomRent();
string strQuery = "";
strQuery = strQuery + System.Environment.NewLine + "SELECT M.ID AS Id,";
strQuery = strQuery + System.Environment.NewLine + " M.SARAI_MASTER_ID AS SaraiMasterId,";
strQuery = strQuery + System.Environment.NewLine + " M.ROOM_CATEGORY_MASTER_ID AS RoomCategoryMasterId,";
strQuery = strQuery + System.Environment.NewLine + " M.FROM_DATE AS FromDate,";
strQuery = strQuery + System.Environment.NewLine + " M.TO_DATE AS ToDate,";
strQuery = strQuery + System.Environment.NewLine + " M.AMOUNT AS Amount,";
strQuery = strQuery + System.Environment.NewLine + " M.IS_ACTIVE AS IsActive,";
strQuery = strQuery + System.Environment.NewLine + " M.ROW_VERSION AS [RowVersion],";
strQuery = strQuery + System.Environment.NewLine + " M.CREATED_BY AS CreatedByUserId,";
strQuery = strQuery + System.Environment.NewLine + " ISNULL(C_UM.NAME, '') AS CreatedByUserName,";
strQuery = strQuery + System.Environment.NewLine + " M.CREATE_DATE AS CreateDate,";
strQuery = strQuery + System.Environment.NewLine + " ISNULL(M.MODIFIED_BY, 0) AS ModifiedByUserId,";
strQuery = strQuery + System.Environment.NewLine + " M.MODIFY_DATE AS ModifyDate,";
strQuery = strQuery + System.Environment.NewLine + " ISNULL(M_UM.NAME, '') AS ModifiedByUserName";
strQuery = strQuery + System.Environment.NewLine + "FROM SARAI_ROOM_RENT M";
strQuery = strQuery + System.Environment.NewLine + "INNER JOIN USER_MASTER C_UM";
strQuery = strQuery + System.Environment.NewLine + "ON M.CREATED_BY = C_UM.ID";
strQuery = strQuery + System.Environment.NewLine + "LEFT JOIN USER_MASTER M_UM";
strQuery = strQuery + System.Environment.NewLine + "ON M.MODIFIED_BY = M_UM.ID";
strQuery = strQuery + System.Environment.NewLine + "WHERE M.ID = "+ Id.ToString();
obj = Db.DapperGet <SaraiRoomRent>(strQuery);
return(obj);
}
